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 are basic methods of dataadapter?

510


What is the use of SqlCommandBuilder?

620


What is ado.net code?

523


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

506


What is difference in record set and dataset?

536






What are the core objects of ADO.NET?

588


Define Execute Scalar?

553


What is the difference between the clone() and copy() methods of the dataset class?

546


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

560


What is the purpose of using adodb?

509


Define connection string?

586


Why do we serialize data?

497


What are the major challenges in accessing data from a database?

536


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

582


What is difference between executenonquery and executequery?

472