Call a stored procedure from ado.net and pass parameter to it ?
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
What are the steps to connect to a database?
Can you explain how to enable and disable connection pooling?
How to work with disconnected data - the dataset and sqldataadapter?
What is ado and rdo?
What does ado stand for in ado.net?
What is ado.net and its features?
What are the major difference between classic ADO and ADO.NET?
Which ado.net object is very fast in getting data from the database?
What are the benefits of ADO.NET?
How do we use stored procedure in ADO.NET and how do we provide parameters to the stored procedures?
What is data control techniques?
Which object is used to add relationship between two Datatables?
What are the different row versions available in table?
Define executenonquery?
What are the advantage of ado.net?