how can i call output parameters from ado.net
Answers were Sorted based on User's Feedback
Answer / vallabh naik
SqlParameter arParams = New SqlParameter("@FeedbackID",
SqlDbType.Int);
arParams.Direction = ParameterDirection.Output;
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vineet tiwari
u can call output parameters in ado.net through store
procedure.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / krishnarao
i have to write a one example
sqlconnection con=new sqlconnection(" u can write
Connection string here);
sqlcommand cmd=new sqlcommand();
cmd.ConnectionString=con;
cmd.CommandText="u can write stored procedure name here";
cmd.CommandType=CommandType.StoredProcedure;
SqlDataReader dr;
dr=cmd.ExecuteReader();//the stored procedure will be
executed here.the out put parameters will be stored into
datareader.
TextBox.Text1=dr.GetValue(0).ToString();//get the output
values here.
TextBox.Text2=dr.GetValue(1).ToString();//get the output
values here.
| Is This Answer Correct ? | 3 Yes | 6 No |
If you want a certain ASP.NET function executed on MouseOver for a certain button. Where do you add an event handler?
How do you implement sql caching in asp.net?
How many languages are supported by .NET at present time?
What is an iHTTPModule, and explain its implementation with its limitations?
Why we are using mvc instead of asp.net? : Asp.Net MVC
What is state management in asp.net with example?
What is break mode?
What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
How can we inherit a static variable?
Can we handle the error and redirect to some pages using web.config?
Name the namespace which is used by ado.net?
What is a 404 redirect?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)