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 csdl entity framework?

626


What are the various methods provided by the DataSet object to generate XML?

691


What is the return type of executescalar?

569


What is ado.net tutorial?

591


What is partial class?

621






What are the disadvantages of using datalist?

588


What does ado stand for in ado.net?

531


How to copy the contents from one table to another table and how to delete the source table in ado.net?

617


Which is faster datareader or dataadapter?

625


What is ole db and odbc?

589


Explain ado.net features?

642


What is the DataTableCollection?

666


Explain the difference between data reader and data set?

569


What is dataset and datatable in ado.net?

597


What does executequery return?

597