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 / surya narayana panda

ExecuteReader-It is readonly forward only.It executes the
command and return the reader objectl.It executes only
select command.

ExecuteNonQuery-It executes command and return's no
value.It returns only how many row effected.It returns
value when the commandType is stroedProcedure with output
parameter.

ExecuteScalar-It executes the command and return a single
value.That is 1st column and 1st row.

Is This Answer Correct ?    24 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

They mostly asked difference between versions of technologies

1322


Explain the asp.net mvc request life cycle? : asp.net mvc

942


What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?

1061


What parameters can you pass in the url of the api?

1058


Difference between web user control and web custom control?

881


What is a nested masterpage in asp.net 2.0? Can there be a master page inside a masterpage?

849


What are the benefits of view state?

898


What are the two Layouts supported by a Web form in ASP.NET?

1021


What is windows active directory authentication?

1001


Where code pages are used?

1141


What are the server control tags in asp.net.?

1016


What is intrinsic objects in asp.net?

1170


How to implement role based security in asp.net mvc? : Asp.Net MVC

978


How would you enable impersonation in the web.config file?

949


How many types of cookies are there in asp.net?

910