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 best method to fill the GridView. using
SqlDataReader or Dataset and why

Answer Posted / vasanth

Dataset is the better option then datareader. Since dataset is disconnected, once data can be fetched and stored in dataset and then disconnect the connection and then you can bind to gridview.
In Datareader you are fetching each row and you are binding. So in middle if connection goes off, then half of the data is binded to gridview.
So dataset is better then datareader.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does the parsefloat function do?

878


What is an array? Give the syntax for a single and multi-dimensional array?

865


what are windows services?

949


How are methods overloaded?

958


What is xml serialization in c#?

836


What is difference between property and variable in c#?

843


Is a games console a computer?

885


Can you inherit from multiple classes in c#?

845


What is different between Boxing and Unboxing?

963


How we convert private assembly into public assembly?

912


Are structs faster than classes?

887


Can we change static value in c#?

1007


Is Facebook a desktop application?

879


What is difference between class and abstract class in c#?

872


Is hashset ordered c#?

915