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

how to store the value in textbox using delegates if we have two user control. the value will be called from one user control to another user control. Loading and unloading will be done through delegates.

1 Answers  


public void A() { int x; x = 8; x *= 4 + 8 / 2; } Given the above code, what is the value of "x"?

8 Answers  


Difference between multi-level and multiple inheritance?

17 Answers   Microsoft,


What is data adapter in c#?

0 Answers  


What is inheritance c#?

0 Answers  


How to use delegates with events?

0 Answers  


How do I create a multilanguage, single-file assembly?

0 Answers  


Give some examples of commonly used i/o classes?

0 Answers  


What is desktop example?

0 Answers  


What is the purpose of the integer parse method the decimal parse method?

0 Answers  


Is string a primitive data type in c#?

0 Answers  


Explain the advantage of using system.text.stringbuilder over system.string?

0 Answers  


Categories