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
- 12608 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
Give an example that shows how to execute a stored procedure in ado.net?
Explain how to find the given query is optimised one or not?
What are the major challenges in accessing data from a database?
What is the use of SqlCommand object?
What is isolation?
What is data reader in ado.net?
What is read only and forward only in ado.net?
What is ado oledb and odbc?
What is ado object model?
What is linq and entity framework?
What you mean by filtering of data?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
What is connection string?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is ambient transaction?
