unable to implement sqldatareader to icollection

[Mentos]

I wanted to create a new query that should return only the specific range of records when we ask for, I have also decided to use a SqlDataReader instead of a DataSet this is because there is no need to update the data and SqlDataReader is purportedly much faster. Can any one please suggest me how to Implement paging in a DataGrid that has an SqlDataReader as source?

[Shell]

ICollection is an interface that provides the several methods of SqlDataReader which result in an ExecuteReader command to an SQL statement. By just setting the AllowPaging property to True and (optionally) setting the PageSize property, the DataGrid displays only the first PageSize number of rows from the DataSource.

[Adley]

DataSource of datagrid must use classes that were inheritance from interface ICollection. ICollection is an interface that provides the several methods that the DataGrid uses behind the scenes for paging. Interface ICollection has property Count. And SqlDataReader does not have this property. Google, obviously, is not the only Web site that breaks up large amounts of data into readable pages.

[X-Ray]

Along with the AllowPaging property, there is a PageSize property that specifies how many records to display per page. So do people who want to use a SqlDataReader first read results into a, say, ArrayList or DataTable in the code-behind This property has a default value of 10. Apparently, you CAN set a datagrid's DataSource to a DataReader--but you must set AllowCustomPaging to true.