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 / jerry joseph

ExecuteReader - This method returns a DataReader which is
filled with the data that is retrieved using the command
object.

ExecuteNonQuery - This method returns no data at all. It is
used majorly with Inserts and Updates of tables.

ExecuteScalar - Returns only one value after execution of
the query. It returns the first field in the first row.

This would be excellent for receiving a count of records
(Select Count(*)) in an sql statement, or for any query
where only one specific field in one column is required.

Is This Answer Correct ?    35 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to fetch a data from one table to another table in asp.net ?

1007


Where are session variables stored?

917


Explain server control extensibility with reference to asp.net 2.0 ?

943


Explain client-side scripting?

944


What is the difference between sealed vs static class?

1039


Explain the namespace classes used in asp.net mvc? : asp.net mvc

954


What are html helpers in asp.net?

1027


Can you explain architecture of your project ?

1059


What is the use of asp.net web api?

1039


Explain the overview of asp.net?

984


What is .net remoting?

1000


What are session and cookies?

928


What is _dopostback in asp net?

924


What are the benefits of view state?

902


If we remove web.config or machine.config from the application then, is this application will works?

969