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
- 11651 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / jaya tiwari
Execute non query executes a query that is associated with
sqlCommand object . sqlCommand object having a property
sqlCommandobj.CommandText in which we pass the query. so
ExecuteNonQuery will return the no of rows affected by that
command whose sqlCommand obj invokes this method .
and it can't be use for select as its return type is int
that is no of rows affected in execution of that query
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Which object is used to add relationship between two Datatables?
What does adodb stand for?
Why is it important to close an ado.net application?
How to work with disconnected data - the dataset and sqldataadapter?
Which method in OLEDBAdapter is used to populate dataset with records?
What is disconnected scenario in entity framework?
How to identify the controls which can be used for binding data?
How does ado.net work?
What is shadow copy?
How to find the given query is optimised one or not?
Do we use stored procedure in ADO.Net?
Explain how can we load multiple tables in to dataset?
What are the Features of a dataset
How to pass values into a datatable?
What is executenonquery ado.net?
