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

Answers were Sorted based on User's Feedback



What is the best method to fill the GridView. using SqlDataReader or Dataset and why..

Answer / justgovi

Datareader is the best way to fill the grid view.
Datareader is faster and the main purpose of it is to be
used in read only scenarios.

Is This Answer Correct ?    15 Yes 1 No

What is the best method to fill the GridView. using SqlDataReader or Dataset and why..

Answer / shiva

Depending on the requirement either we can go for Dataset
or Datareader.If the information which we are trying to
access is less then best and fastest way is to go for
Datareader in all other scenarios Dataset can be used.

Is This Answer Correct ?    10 Yes 0 No

What is the best method to fill the GridView. using SqlDataReader or Dataset and why..

Answer / gowthami

filling the grid view is good by dataset is preferable
as it is used for connection less architecture..
and dataset is nothing but a inmemory database.

Is This Answer Correct ?    9 Yes 0 No

What is the best method to fill the GridView. using SqlDataReader or Dataset and why..

Answer / saurabh sharma

If u r presenting small amount of data, u can pick any option. It will take almost same time. But if u want to load heavy data, for example 50000 rows, use sql data paging and objectdatasource or xmldatasource to fill grid view. use paging option of objectdatasource or xmldatasource to switch between pages.

Is This Answer Correct ?    0 Yes 0 No

What is the best method to fill the GridView. using SqlDataReader or Dataset and why..

Answer / 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

More C Sharp Interview Questions

Define multicast delegate? How it be used?

0 Answers   Siebel,


Why do we use classes?

0 Answers  


Is arraylist type safe in c#?

0 Answers  


Which are the access modifiers available in c#?

0 Answers  


What is a protected class in c#?

0 Answers  


You are creating a custom usercontrol, some of the newly created properties are shown in the properties window. How you can hide a new property named theme from the properties window?

0 Answers  


Can we have two main methods in c#?

0 Answers  


What are actions in c#?

0 Answers  


What is Interface? Explain with an example.

8 Answers   TCS,


What is nullable types in c#?

0 Answers  


Can struct inherit from class c#?

0 Answers  


What is the difference between paramaterized constructor and copy constructor?

0 Answers   HCL,


Categories