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
- 5 Answers
- 11936 Views
- CA, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
What is datasource c#?
How jit (just in time) works?
what is full assembly reference
Can you inherit multiple classes in c#?
Explain how do you debug an asp.net web application?
What is virtual in c#?
What is private protected in c#?
What is parallel foreach in c#?
You have got 1 million parking slots. At a time a parking slot can be free or not. To get next slot easily which data structure to implement?
How will U encapsulate button trigger event into text_box event of Pressing Enter key?
What does the keyword virtual mean in the method definition?
3 Answers Ipog Software, Satyam, Visual Soft,
Difference between debug.write and trace.write?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
