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 ado circle?

659


Explain executenonquery?

549


What do you mean by performing asynchronous operation using command object?

510


What are the key events of sqlconnection class?

608


How to check if a datareader is closed or opened? IsClosed()

578






Which control of the BindingNavigator returns the current position within the data source?

729


What are basic methods of dataadapter?

503


Define Execute Reader?

586


Which is faster datareader or dataadapter?

525


What are all the different methods under sqlcommand?

518


What is an ADO.Net?

564


What is the advantage of ado.net?

539


Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

527


How to create dynamic gridview?

588


What is an ado?

516