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

What I need to create and run an asp.net application?

967


How many types of state management are there in asp net?

1024


What is postback request?

974


How many types of sessions in asp.net?

1104


Explain the difference between globalization and localization techniques

995


What is the used of "ispostback" property?

1114


What is repository pattern in mvc.net? : asp.net mvc

992


Explain method to handle error using HttpError in Web API?

1046


What is variable and constant in .net programming language?

805


How do I know asp.net mvc version? : Asp.Net MVC

1026


Difference between application events and session events

1023


Explain what is an abstract class?

1014


Define what is razor? : asp.net mvc

995


Explain exception handling in .net.

1064


Can a master page have more than one contentplaceholder?

962