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
How to find the given query is optimised one or not?
What is the difference between typed and untyped dataset?
What is a column variable?
Can you explain how to enable and disable connection pooling?
Can datareader hold data from multiple tables?
Where is adodb dll located?
What is method to get XML and schema from Dataset? getXML() and get Schema ()
Define connection string?
What does sqldatareader return?
Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.
What is dataset and datatable in ado.net?
Explian About DataAdapters
Explain how to call the sql commands asynchronously in ado.net version 2.0?
Describe the disconnected architecture of ADO.NET’s data access model.
What does ado stand for in ado.net?