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

How to identify the updated rows in a dataset?

521


What is commandbuilder in ado.net?

526


How is entity framework different from ado.net?

488


Define isolation?

537


What is data view and variable view?

487






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

587


What is the difference between an ADO.NET Dataset and an ADO Recordset?

550


What is the advantage of ado.net?

549


What is difference between sqldatareader and sqldataadapter?

488


What are the different execute methods of Ado.Net?

553


If a table contains 20000 records. In a page at each time 100 records to be displayed.

522


What are the uses of Stored Procedure?

557


What are the benefits of using of ADO.NET in .NET 4.0?

539


can we create synonymn in ms access,sql server,my sql if so explain me with example

1583


What is data control techniques?

509