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
Which database is the ado.net?
What does ado stand for?
If we are not returning any records from the database, which method is to be used?
What is ado.net and its features?
Define ado.net?
What is DataRowCollection?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What are the Data providers in ADO.Net?
What is row state?
How do you update a dataset in ado.net and how do you update database through dataset?
What is ado net stands for?
What are advantages of microsoft-provided data provider classes in ado.net?
Which control of the BindingNavigator returns the current position within the data source?
Which is faster datareader or dataadapter?
What is different between sqlcommand object and command behavior object?