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?
- 6 Answers
- 10529 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sandyni
Execute nonquery effects only for DML like Update delete
and insert statements only,
for select statement we have to choose ExecuteScalar or
ExecuteReader methods. these methods can return datareader
and gives the result for your query.
| Is This Answer Correct ? | 18 Yes | 6 No |
Post New Answer View All Answers
What is ado full form?
What are different layers of ADO.Net?
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What are two types of transaction supported by ado.net?
What is the difference between ado.net and entity framework?
What is sqldatasource?
What are the types of databinding?
Where is adodb dll located?
What is ole in excel?
What is different between sqlcommand object and command behavior object?
How to creating a SqlCommand Object?
What is ole db and odbc?
What does executequery return?
What is executequery?
Describe connection object in ado.net
