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.

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.

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.

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.

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.

What is tryparse c#?

0 Answers  

Is typeof c#?

0 Answers  

Difference between Value type & reference types ? and give the example in .Net?

0 Answers  

What is the main method?

0 Answers  

What is append in c#?

0 Answers  

How do partial classes work in c#?

0 Answers  

Can a class be private in c#?

0 Answers  

How to make sure custom class supports deterministic finalization?

1 Answers   IBM,

Asha buys 16 Chocolates for rs 12 and 24 chocolates for rs 20, if she sold them 30 chocolates for rs 30 then what is the Gain/Loss percentage? Gain(700/19 %) Loss(700/19 %) Gain(500/19 %) Loss(500/19 %) If one person ate 100 grapes in 5 days and 6 more each day from starting, what was the no of grapes he ate on first day? 6 8 10 7 If seven men P, Q, R, S, T, U, V parked his car, P and Q something like that. 6 student J, K, L, M, N, O went for picnic in 2 batches, K and L have to go together, M and O do't go together, if O and L go in one batch then which of these combination will be wrong. Jmnp Jklo klop JKLO a boat can go upstream and down stream, if it goes 5/2 times of downstream at the speed of 6 kmph then what will be the speed of upstream? 15 KMPH 12 KMPH 10 KMPH 11 KMPH A, B, C, D, E sitting on a table, A sits 2 seat left from B and C sits 2 seat right from B then what will not be the combination ACDE

0 Answers   Symphony,

What is an event in c#?

0 Answers  

What is getenumerator?

0 Answers  

C Sharp

1 Answers   Wipro,