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 cyclomatic complexity and why is it important?
Can you explain the basic use of dataview?
Difference Between GridView And DataList
Guys can anobody tell what is Conditional Bloating in asp.net ??
When should I use server transfer and response redirect?
Explain the difference between singleton and single call?
Explain weak typing and strong typing.
What is connection pooling and how to enable and disable connection pooling?
To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?
what is usercontrol how we can use acess the controls that are present in the usercontrol in the aspx page suppose we have 2 text boxes in a user control how u can acess the 2 textboxs in the aspx page
How to check the end of the record in Datareader?
Security types in ASP/ASP.NET? Different Authentication modes?
4 Answers QuadLabs Technologies,
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)