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 the difference between ExecuteReader,ExecuteNonQuery
and ExecuteScalar.

Answer Posted / ashish kumar gupta

Execute Reader: Use for accessing data. It provides a
forward-only, read-only (Select), connected record set.

Execute Non Reader: Use for data manipulation, such as
Insert, Update, and Delete.

Execute Scalar: Use for Retrieving 1 row 1 col. Value. I.e.
single value. E.g. for retrieving aggregate function. It is
faster than other ways of retrieving a single value from
database.

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is viewstategenerator?

1262


What are the various types of cookies in asp.net?

1070


Is sql backend or frontend?

1051


What are navigation controls? How many navigation controls are there in ASP.NET 4.0?

995


What are demand-paging and pre-paging?

1043


List down the sequence of methods called during the page load.

974


What are the security types in asp.net?

1109


How can we prevent browser from caching an aspx page?

938


What is the good practice to implement validations in aspx page?

1165


Explain how can we access static variable?

1209


What are standard controls?

1010


Why session is necessary in web application?

1010


Give 2 examples for scenarios when routing is not applied?

1100


how to transfer the file from client to server using asp.net

1158


What is the procedure to create the environment for asp.net? : asp.net mvc

1111