Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12339 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
Command objects uses, purposes and their methods.
differance between ADO vs ADO.Net?
What are the data providers used in ado.net
What is the difference between ADO and ADO.Net?
What is aggregating data ?
How do you update a dataset in ado.net and how do you update database through dataset?
Explain which name space is used to get assembly details?
How do you update database through dataset?
Define bubbled event?
What are the advantages and disadvantages of using datalist?
What is ado.net and its architecture?
Explain how to pass multiple tables in datasets simultaneously?
What is the difference between Data adaptor and Data set?
What is sqlconnection and sqlcommand?
What is ole db query?
