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
12498 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 is sqldatasource?

913

Where is adodb dll located?

954

how we can fire event in databound coulm in datagfrid withot using button?

950

What are the data access namespaces in .NET?

1189

What is the functionality of data provider in ado.net?

918

How to retrieve the user id which is provided while windows authentication?

1081

What is the difference between executenonquery () and executescalar ()?

943

What are all the commands used with Data Adapter?

1025

What is openquery?

968

What are the main differences between classic ado and ado.net?

1011

What are the important features of ado.net 2.0?

1060

What is difference between Dataview and Datatable?

1051

What is different between sqlcommand object and command behavior object?

1038

What is XML serialization

1034

What is sqldatareader in ado.net?

902