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
12394 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 ado asp?

963

What is datatable in ado.net?

932

Which is faster dataset or datareader?

922

What is shadow copy?

939

What is DataRowCollection?

1054

How to add a check box or a dropdown list to a column in a datagrid?

942

What is command class in ado.net?

963

What is difference between executequery and executeupdate?

940

Which control of the BindingNavigator returns the current position within the data source?

1125

Which method in OLEDBAdapter is used to populate dataset with records?

972

What is dataset and datatable in ado.net?

944

What is basic use of data view?

953

Explain the difference between sqlcommand object and command behavior object?

1031

What is adodb dll?

958

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

925