DataReader Page Size

[AngryCoder]

With ado I know that you could set the page size on a Recordset. WITHOUT using a DataGrid I want to set the page size on a Recordset. Is there any built in function to do this? Thanks.

 

[Robby]

Recordset? Do you mean Dataset?

 

[AngryCoder]

Actually, I am using a SqlDataReader, but any other soultion would probably work as well.

 

[Robby]

Correct me if Im wrong, do you want to use paging feature of a datagrid but without a datagrid? How are you displaying the data?

 

[AngryCoder]

Ive created a custom Grid Control with javascript. I execute a Query Statement with a command object and return the data to a SqlDataReader. I loop through the SqlDataReader and create a XmlDocument which I return to the client and display the data in the Grid. I want to return only a certain amount of records per request and I was hoping that I could set properties on the SqlDataReader (or something similar).

Thanks!!!