What is the best method to fill the GridView. using
SqlDataReader or Dataset and why
- 5 Answers
- 10284 Views
- CA, I also Faced
- E-Mail Answers
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
List down the different ide’s provided by microsoft for c# development.
Contrast System.String and System.Text.StringBuilder classes?
Is an interface a type c#?
What is sqlcommand in c#?
What is a copy constructor in c#?
How does dictionary work in c#?
List some of the classes used by system.data namespace?
How do I declare inout arguments in c#?
Value Type and Reference Type Data type in C#?
is it possible to access a remote web service Without UDDI?
What are the different ways of method can be overloaded?
What are the string functions in c#?
How does insertion sort work?
What does == mean in c sharp?
If a class derives from another class, will the derived class automatically contain all the public, protected, and internal members of the base class?
