Execute nonquery returns no. of afected rows.So if my stored
procedure hav lot of select stmnt, delete stmnt, insert
stmnt..then what does execute nonquery returns in this case?

Answer Posted / pankaj shinde

Total number of rows effected.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between connected and disconnected architecture in ado.net?

589


What is ole2 format?

509


What is ado object model?

519


What is ado rdo dao in visual basic?

669


How do you update a dataset in ado.net and how do you update database through dataset?

489






What is dbcontext and dbset in entity framework?

490


What is data reader in ado.net?

501


What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

540


What is commandbuilder in ado.net?

526


What is the usage of the dataset object in ado.net?

491


How do I delete a row from a DataTable?

597


How do you merge 2 datasets into the third dataset in a simple manner?

540


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

563


Can we connect two dataadapters to same data source using single connection at same time?

535


Can we load multiple tables in a dataset?

546