Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 Serialization in .NET? what are the types of Serialization?

1072


Is bulk insert faster than insert?

908


How to bind the controls(best practice) comboboxes to the data in the dataset?

1045


What is Data view?

1072


What is the use of connection object in ado.net?

1058


What is a string variable?

915


Explain how can we load multiple tables in to dataset?

941


What does executenonquery () method return?

933


What is difference between ado.net and asp net?

1038


What are the difference between readonly vs. Const?

1005


How to identify the controls which can be used for binding data?

993


What are the different row versions available in table?

967


How can we serialize the dataset object?

998


Which is faster ado.net or linq?

1017


Which is better entity framework or ado.net?

1043