Paging problem with datareader and datagrid

alyeng2000 · February 1st, 2004, 03:14 AM

i attach the datasource for the grid to a datareader and it works well , but when allow paging in the datagrid an error raised .

Ahmed Ali
Software Developer

stu9820 · February 1st, 2004, 04:35 PM

What's the error?

alyeng2000 · February 6th, 2004, 09:08 AM

thx Stu,
the error is datasource doesnot support icollection , so i attach the grid to a dataset source and it works fine,

Any have a comment

Ahmed Ali
Software Developer

saileshsuvarna · September 9th, 2004, 02:14 AM

Paging requires that you bind either a DataTable or DataSet object to the DataGrid; that is, [u]YOU CAN'T USE A DATAREADER.</u> This is because the DataGrid needs to be able to determine how many records are in the DataSource to be able to determine how many total pages of data exist.

http://msdn.microsoft.com/library/de...lesortable.asp

Cheers,

Sailesh Suvarna

saileshsuvarna · September 9th, 2004, 02:31 AM

Never tried with ADO.NET 2.0, but according to the foll. article
http://www.extremeexperts.com/Net/Ar...wFeatures.aspx

there is a new API "ExecutePageReader" which can be fiddled around with for Paging

Cheers,
Sailesh