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

Is asp.net is a programming language?

944


How to disable validator control by client side JavaScript?

1063


What are html helpers in asp.net?

1088


How Session outproc in Sqlserver stored?

2756


What is a page life cycle?

1049


When cookie will expire?

994


State differences between MVC and WebAPI

1151


What is an assembly? Explain its parts.

1073


What are the different types of validation controls provided in ASP.NET?

1161


Explain the difference between or and orelse?

993


What is server infrastructure?

1121


Is session server side or client side?

958


What is comparevalidator?

970


What is rending process in ASP.NET?

1072


What is & in a url?

963