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
What is Serialization in .NET? what are the types of Serialization?
Is bulk insert faster than insert?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What is Data view?
What is the use of connection object in ado.net?
What is a string variable?
Explain how can we load multiple tables in to dataset?
What does executenonquery () method return?
What is difference between ado.net and asp net?
What are the difference between readonly vs. Const?
How to identify the controls which can be used for binding data?
What are the different row versions available in table?
How can we serialize the dataset object?
Which is faster ado.net or linq?
Which is better entity framework or ado.net?