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 / suresh reddy
returns -1, since you can't find the how many rows effected because of your stored procedure.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What are dcl commands?
What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?
Explain About ado.net components/objects. Usage of data adapters and tell the steps to retrieve data.
What is acid in ado.net?
differences between ADO and ADO.NET
What is the maximum pool size in ado.net connection string?
If we are not returning any records from the database, which method is to be used?
Can datareader hold data from multiple tables?
What is bubbled event can you please explain?
List all the steps in order, to access a database through ado.net?
What is ado.net in mvc?
What is the difference between ado.net and oledb?
What are different layers of ADO.Net?
How do I delete a row from a DataTable?
I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?