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 can we create custom controls in asp net?

0 Answers  


What are the various ways of securing a web site that could prevent from hacking etc ?

1 Answers  


33) You create English, French, and German versions of your ASP.NET application. You have separate resource files for each language version. You need to deploy the appropriate resource file based on the language settings of the server. What should you do? A . Create an installer and set the Installer.Context property for each version of your application. B . Create an installer that has a launch condition to verify the locale settings. C . Create an installer that has a custom action to install only location-specific files. D . Create an installer that has an MsiConfigureProduct function to install the appropriate version.

2 Answers   Friedkin, ISH, Syntax, Syntax Softtech,


What is enableviewstate in asp net?

0 Answers  


Is data can be edited in the Repeater control?

2 Answers  


How to use multiple scriptmanager controls in a web page?

0 Answers  


How to kill session?

18 Answers   Protech,


Difference between Dataset and DataReader ?

4 Answers   Accenture, BirlaSoft, Infosys, Microsoft, Techseol,


Does google crawl redirects?

0 Answers  


Are there any resources for drop-in replacements for the default css that comes with the ASP.NET Website template?

0 Answers   MCN Solutions,


Can two web application share a session and application variable ?

5 Answers   Satyam, V3 Engineers,


What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?

0 Answers  


Categories