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?
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 are the benefits of using ado.net?
What are the benefits of ADO.NET?
What are the advantages of oledb compared with other classes?
Which is faster ado.net or linq?
Explain what are the steps to connect to a database?
How is it possible to get 2 tables of data at a time by using data reader?
What is a control toolbox?
What is ole db query?
What is datasource in ado.net?
If a table contains 20000 records. In a page at each time 100 records to be displayed.
Does sqlclient and oledb class share the same functionality?
What are the types of databinding?
Describe ado.net object model in detail.
What is ado connection?
What we do with the object of ado.net dataset after using it?