How to bind gridview to datareader in asp.net 2?

Question

How to bind gridview to datareader in asp.net 2?

Answer 1

You really wouldn't want to use a datareader at all for grid binding, since it is the wrong kind of connection - you don't want a record-at-a-time real time reader for a rendered control. Use a DataTable (fill it with a SqlDataAdapter or an OleDbDataAdapter.)

Then attach it by declaring the DataTable the .DataSource of the gridview and calling Page.DataBind()