create con as connection object,cmd as command object cmd.CommandType=Co

Call a stored procedure from ado.net and pass parameter to it ?

Question Posted / guest

7 Answers
24922 Views
Keane India Ltd, TCS, I also Faced
E-Mail Answers

Answer Posted / guest

create con as connection object,cmd as command object
cmd.CommandType=CommandType.Storedprocedure
cmd.CommandText="storedprecedurename"
cmd.ExecuteNonQuery()

Is This Answer Correct ?

16 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the data providers in ADO.NET framework?

1076

What are the usages of the command object in ado.net?

1072

What is the use of ADO.NET and XML web services?

1088

What does executequery return?

1030

What is ado.net in vb net?

965

What is a control toolbox?

1022

What is a data control clerk?

1099

What is disconnected architecture in ado.net?

1044

What is ambient transaction?

1005

How can we load multiple tables in to dataset?

1145

Explain the difference in record set and dataset?

997

Some important instruction regarding ADO.NET connection string ?

1046

What is microsoft ole db provider for sql server?

977

Explain how to call the sql commands asynchronously in ado.net version 2.0?

979

Do we use stored procedure in ADO.Net?

1057