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

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?

Question Posted / suresh reddy

6 Answers
12328 Views
Wipro, I also Faced
E-Mail Answers

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 are two important objects of ADO.Net?

967

What are the Features of a dataset

1181

What are the different execute methods of Ado.Net?

971

What are the usages of the command object in ado.net?

966

What is ado code?

905

What is command class in ado.net?

936

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

956

What are the several execute methods of ado.net?

866

Why is stored procedure used in ado.net?

1029

What is full form of ado?

984

What are the advantages and drawbacks of using ado.net?

1041

What is data relation?

850

Define the executescalar method?

876

Define executenonquery?

864

Which is faster sqldataadapter and sqldatareader?

870