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
Which object is used to add relationship between two Datatables?
Is it possible to load multiple tables in a Dataset?
What is the meaning of executenonquery?
What are disadvantages of microsoft-provided data provider classes in ado.net?
What is the use of SqlCommandBuilder?
What is acid in ado.net?
Does dapper use ado.net?
What is aggregating data ?
What is the procedure to call a Stored Procedure of Back End in ADO (ActiveX Data Object) and RDO (Remote Data Objects)?
Which property is used to check whether a DataReader is closed or opened?
What is data control techniques?
What are the drawbacks of using ado.net?
What are the key events of sqlconnection class?
What is ado.net object model?
Define data adapter?