how can i call output parameters from ado.net

Question Posted / bachumalli

3 Answers
5717 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how can i call output parameters from ado.net..

Answer / vallabh naik

SqlParameter arParams = New SqlParameter("@FeedbackID",
SqlDbType.Int);
arParams.Direction = ParameterDirection.Output;

Is This Answer Correct ?

5 Yes

0 No

how can i call output parameters from ado.net..

Answer / vineet tiwari

u can call output parameters in ado.net through store
procedure.

Is This Answer Correct ?

1 Yes

1 No

how can i call output parameters from ado.net..

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.