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 |
Describe the .net base class library.
Differentiate between a page theme and a global theme?
How to call a child form method from the master page?
Describe the role of inetinfo.exe, aspnet_isapi.dll and aspnet_wp.exe in the page loading process
1 Answers HCL, Siebel Systems, Visual Soft,
Differentiate strong typing and weak typing
How many web.config a application can have ?
6 Answers Keane India Ltd, Manhattan, Vertex,
Features in ASP.NET?
What is the maximum length of textbox
How to set/get parent page values in child page in asp.net
Which method is used to force all the validation controls to run?
how can we display records in single datagrid using two datasets in different place?
2 Answers Global Computer, Honeywell,
How many time you can fill dataset in asp.net?