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 / divya sharma

Execute Non Query- its for manipulation
(insert,delete,update),returns number of rows affected.

Execute Reader- accesses data in read only,forward only way
(perform commands such as select).

Execute scalar- returns only one value i.e. 1st row,1st
column, after execution of query.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain page output caching?

984


What is the use of response redirect in asp.net?

1049


What are the differences between application object and session object?

995


To display data in the combo box, prior to setting the Data Source, what kind of property on a Combo Box do you set with a column name?

1051


I am trying to implement sorting facility from client side code in GridView Control. So how can I fill up an Array inside client side code (using JavaScript), i want to assign my DataSet object declared and filled up on Server side(in code behind) to the array (on client side)

1985


Differentiate between globalization and localization.

971


Which method do you use to enforce garbage collection in .net?

958


Is viewstate secure?

956


How can we update records in gridview?Is there any appropriate code for it?

2158


Where are session variables stored?

955


Who creates jsessionid?

1025


Explain the difference between response.redirect vs server.transfer

1133


How can you handle errors in Web API?

1131


What is the difference between exe and dll?

1130


Is viewstate enabled by default?

969