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

Which object is used to add relationship between two Datatables?

553


Is it possible to load multiple tables in a Dataset?

509


What is the meaning of executenonquery?

518


What are disadvantages of microsoft-provided data provider classes in ado.net?

483


What is the use of SqlCommandBuilder?

597






What is acid in ado.net?

511


Does dapper use ado.net?

579


What is aggregating data ?

494


What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

541


Which property is used to check whether a DataReader is closed or opened?

548


What is data control techniques?

481


What are the drawbacks of using ado.net?

529


What are the key events of sqlconnection class?

587


What is ado.net object model?

496


Define data adapter?

488