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

Which object is used to add relationship between two Datatables?

582


What is a serialized object?

544


What is the default timeout specified for "sqlcommand.commandtimeout" property?

551


What is an example of ordinal data?

500


How can we perform transactions in .net?

552






What is ado.net components?

515


How to add a javaScript function in a datagrid?

575


What are the data providers used in ado.net

548


What is ole2 format?

511


Do we use stored procedure in ADO.Net?

579


What is namespace in ado.net?

502


What is untyped dataset?

548


What is data relation?

511


Explain how to pass multiple tables in datasets simultaneously?

501


What is difference in record set and dataset?

544