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 |
What is asp.net? How is it different from asp?
Which object wraps the state or data of a user?
What is the role of global.asax?
What is the difference between a cookie and a pixel?
How to implement caching?
what is synchronization and asynchronization. what are the difference between two?
Do gac'ed assemblies have fulltrust?
Can you set which type of comparison you want to perform by the comparevalidator control?
how can u create the blog in asp.net with C#?what is the data type u will use to store in sql server?
How to deploy the Asp.Net Project ?
Write a standard lock() plus double check to create a critical section around a variable access?
How to change the form layout in ASp.net 2.0 ?