What is the best method to fill the GridView. using
SqlDataReader or Dataset and why
- 5 Answers
- 10911 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
What are methods in C#?
What is the difference between list and arraylist in c#?
What is concrete method in c#?
Why do we need private constructor in c#?
Which is the best language for desktop application?
What is hashset c#?
What is check/uncheck?
How does c# achieve polymorphism?
What is difference between class and abstract class in c#?
Can a abstract class have a constructor?
What is the difference between interface and functional interface?
What is serialization of data?
What are destructors in C#?
How is exception handling implemented in c#?
Give an example of a directcast.
