what is Execute NOn Query?
Answer Posted / hanna mae
You can use ExecuteNonQuery to change the data in a database
without using a DataSet. Do this by executing UPDATE,
INSERT, or DELETE statements.
Although ExecuteNonQuery does not return any rows, output
parameters or return values that are mapped to parameters
are populated with data.
For UPDATE, INSERT, and DELETE statements, the return value
is the number of rows affected by the command. For all other
types of statements, and for rollbacks, the return value is -1.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Which keyword is used to accept variable number of parameters?
Is datareader faster than datatable?
What is the use of SqlCommandBuilder?
how you will deal result set? How do you sort a dataset?If a dataset contains 100 rows, how to fetch rows between 5 and 15 only?
What are the essential features of ado.net?
What is bubbled event?
differences between ADO and ADO.NET
Do we use stored procedure in ADO.Net?
What is datasource in ado.net?
What is an orm, and why would you use one instead of plain old ado.net?
What is the difference between the clone() and copy() methods of the dataset class?
What are the different methods available under the sqlcommand class to access the data?
What is ole access?
What is the difference between statement and preparedstatement interface?
Name which operations can you not perform on an ado.net dataset?