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...

once data is fetched into dataset connection gets closed. but in datareader
connection is always maintained...then why datareader is fast and mainly
recommended ?

Answer Posted / abhishek

datareader is forwardonly thus is fast and is mostly used
while retrieving the data from the database.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is ole in excel?

897


What are the types of databinding?

928


What is ado.net full form?

935


What does datareader object do?

943


Which object holds only data and does not interact with data source?

908


What is dbcontext and dbset in entity framework?

867


Why is stored procedure used in ado.net?

1029


how we can fire event in databound coulm in datagfrid withot using button?

915


If a table contains 20000 records. In a page at each time 100 records to be displayed.

839


Difference between sqlcommand and sqlcommandbuilder?

1053


What are the advantages and drawbacks of using ado.net?

1042


How to add a check box or a dropdown list to a column in a datagrid?

921


How does ado.net work?

866


What is serialization and de-serialization in .net? How can we serialize the dataset object?

906


Explian About DataAdapters

969