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 |
Explain difference betn dataset and recordset?
What is the difference between Classic ASP and ASP.Net?
Explain repository pattern in asp.net mvc? : asp.net mvc
What is the function of the ViewState property?
7. Do you have reference list?
4 Answers CMC, Hotel Jobs, Mannar Company, Qatar Petroleums, Swatz Oils,
What are the properties of the eventargs argument when capturing keyboard events?
what are the Custom controls in asp.net?
What are type/key pairs in client script registration? Can there be 2 scripts with the same type/key pair name?
Explain security types in asp.net?
What methods are fired during the page load?
7 Answers InSync Tech-Fin, Siebel Systems, Visual Soft,
Is It Possible For Whole Page is Saved In View State? What Is View State?
2 Answers Phoenix Technologies,
What is the difference between a thread and a process?
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)