I don'nt have the right ans but i think the question was if i have lo

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 / suraj

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

Answer Posted / suraj

I don'nt have the right ans but i think the question was if
i have lot of delete stmnt, insert stmnt and update
statement...then what does execute nonquery returns in this
case? as for select we use execute reader...

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is ole used for?

905

What is ado recordset?

934

What is the difference between oledb sql server and oledbdotnet provider?

974

What providers does Ado.net uses?

968

What is difference between datareader and dataadapter?

1014

What is ado code?

921

Does ado.net use odbc?

912

What is linq and entity framework?

956

What is ole data type?

866

What is difference between executenonquery and executequery?

928

What are all components of ADO.Net data provider?

1028

What are the steps you will take to improve performance? Will you use dataset or datareader?

944

What does executereader return?

919

What is command class in ado.net?

965

What are the disadvantages of using datalist?

991