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


Please Help Members By Posting Answers For Below Questions

How to find the given query is optimised one or not?

504


What is the difference between typed and untyped dataset?

508


What is a column variable?

499


Can you explain how to enable and disable connection pooling?

504


Can datareader hold data from multiple tables?

675






Where is adodb dll located?

525


What is method to get XML and schema from Dataset? getXML() and get Schema ()

541


Define connection string?

580


What does sqldatareader return?

500


Explain the DataAdapter.Update() and DataSetAcceptChanges() methods.

526


What is dataset and datatable in ado.net?

501


Explian About DataAdapters

584


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

502


Describe the disconnected architecture of ADO.NET’s data access model.

538


What does ado stand for in ado.net?

454