What is the best method to fill the GridView. using
SqlDataReader or Dataset and why
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
Can properties be overloaded in c#?
Is c# the same as d flat?
What are destructors in C#?
Is c# pass by value?
What is the function of .IsDescendent()?
What are fields in c#?
What is file extension of webservices?
Illustrate the process of code compilation in c#?
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?
What is the difference between returning iqueryable vs ienumerable?
What is a view? What is the use of it?
What are the differences between events and delegates in c#?
What is difference between class and interface in c#?
How do I port "synchronized" functions from visual j++ to c#?
What happens during the process of boxing?