how can i call output parameters from ado.net

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.

Is This Answer Correct ?    3 Yes 6 No

Post New Answer

More ASP.NET Interview Questions

How many types of sessions are there in asp net?

0 Answers  


How do you change the session time-out value?

0 Answers   TryTechnicals Pvt Ltd,


4. How do you plan to achieve these goals?

7 Answers   Burger King, Latest, Swatz Oils,


What is Stateless ASP or ASP.Net?

2 Answers   Accenture,


What are the Types of session management in ASP.NET

0 Answers   Microsoft,






Explain client-side scripting?

0 Answers  


Have u used webcontrols?Tell me something about these?

2 Answers   Microsoft,


what are the sitemap providers in Asp.net 2.0?

2 Answers  


True or False: To test a Web service you must create a windows application or Web application to consume this service?

1 Answers  


What are the various types of cookies in asp.net?

0 Answers  


What is redirectpermanent in asp.net?

0 Answers  


which is best possible way to add data source to data grid when the data is huge(10 lack recored)how to edit a perticular row

3 Answers   Airtel, Aviva,


Categories