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
12786 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 difference between connected and disconnected architecture in ado.net?

1209

Explain the overview of ado.net architecture?

1124

What is aggregating data ?

1027

What is the usage of the dataset object in ado.net?

1010

What is microsoft ado.net?

1227

What is difference between ado and other data object?

970

What is Data Provider?

1096

Which is faster datareader or dataadapter?

1047

What is disconnected scenario in entity framework?

1172

How do you connect to sql server database without using sqlclient?

1176

What are dcl commands?

1051

What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

1034

What is ambient transaction?

1005

What is executenonquery ado.net?

976

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1086