Project Description
The SqlDataSource control does not support paging on the database server, instead it pulls all records from the database every time the Select method is executed (unless caching is enabled). Paging is implemented by the gridview and other data controls by filtering the in-memory dataset. This approach is not very efficient with large datasets.

This conrol inherits from the SqlDataSource control and adds a few properties to allow the paging to be handled by the database server so that only the records needed for the current page are pulled from the database server. An example of the SQL code for such a stored procedure can be found at http://aspnet.4guysfromrolla.com/articles/031506-1.aspx

Last edited Jul 23, 2008 at 3:51 PM by brooklyn, version 2