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 / suresh reddy

returns -1, since you can't find the how many rows effected because of your stored procedure.

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql command in ado net?

497


Explain how do you connect to sql server database without using sqlclient?

476


Define table relations?

553


What are the Data providers in ADO.Net?

549


What is openquery?

527






What are the important features of ado.net 2.0?

590


What is Data view?

560


Which name space is used to get assembly details?

514


What is a control toolbox?

499


How can we add/remove row's in "datatable" object of "dataset"?

537


What is ambient transaction?

500


What is XML serialization

585


What are the key events of sqlconnection class?

607


What is difference between datagridview and datagrid control in winforms?

511


Explain the differences between oledb sql server, oledbdotnet provider?

550