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

What is asp.net? How is it different from asp?

0 Answers  


Which object wraps the state or data of a user?

0 Answers  


What is the role of global.asax?

10 Answers   Infosys,


What is the difference between a cookie and a pixel?

0 Answers  


How to implement caching?

2 Answers   Infosys, Microsoft,






what is synchronization and asynchronization. what are the difference between two?

1 Answers   TCS,


Do gac'ed assemblies have fulltrust?

0 Answers  


Can you set which type of comparison you want to perform by the comparevalidator control?

0 Answers  


how can u create the blog in asp.net with C#?what is the data type u will use to store in sql server?

0 Answers   IBM,


How to deploy the Asp.Net Project ?

3 Answers  


Write a standard lock() plus double check to create a critical section around a variable access?

1 Answers  


How to change the form layout in ASp.net 2.0 ?

1 Answers   Netsweeper,


Categories