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

Describe the .net base class library.

0 Answers  


Differentiate between a page theme and a global theme?

0 Answers  


How to call a child form method from the master page?

1 Answers  


Describe the role of inetinfo.exe, aspnet_isapi.dll and aspnet_wp.exe in the page loading process

1 Answers   HCL, Siebel Systems, Visual Soft,


Differentiate strong typing and weak typing

0 Answers  


How many web.config a application can have ?

6 Answers   Keane India Ltd, Manhattan, Vertex,


Features in ASP.NET?

2 Answers   Microsoft,


What is the maximum length of textbox

1 Answers  


How to set/get parent page values in child page in asp.net

3 Answers   Wipro,


Which method is used to force all the validation controls to run?

0 Answers  


how can we display records in single datagrid using two datasets in different place?

2 Answers   Global Computer, Honeywell,


How many time you can fill dataset in asp.net?

3 Answers   Syntel, Wipro,


Categories