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


Please Help Members By Posting Answers For Below Questions

What is the difference between SqlCommand and SqlCommandBuilder?

772


What are the advantages of oledb compared with other classes?

2547


What is microsoft ado?

688


Explain the various objects in dataset.

696


Does ado.net use odbc?

684


How to creating a SqlCommand Object?

786


What is Data view?

764


Why edit is not possible in repeater?

688


What are the different ado.net namespaces are available in .net?

730


How to retrieve the user id which is provided while windows authentication?

797


If a table contains 20000 records. In a page at each time 100 records to be displayed.

686


How can we serialize the dataset object?

736


What are the important features of ado.net 2.0?

806


What is ado data control?

717


Explain all the classes those are used for database connections between sql server and asp.net?

732