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.

Can you prevent your class from being inherited and becoming a base class for some other classes?

3 Answers  

Explain the difference between Response.Write () and Response.Output.Write ().

0 Answers   Atos Origin,

What is a multi line comment?

0 Answers  

How many destructors can a class have?

0 Answers  

One start and stop button is there and one textbox is there.when you click start button ,it will display 1,2,3......up to infinite in textbox.when you click stop button it will stop.

1 Answers  

What is the difference between abstraction and encapsulation in c#?

0 Answers  

How do I open the console window?

0 Answers  

What is the syntax for calling an overloaded constructor within a constructor (this() and constructorname() does not compile)?

0 Answers  

What is difference between value and reference types?

5 Answers   Accenture,

Define Abstract Class in C#

0 Answers   HCL,

What is a dbml?

0 Answers  

Explain when should you call the garbage collector in .net?

0 Answers