Custom paging is also known as load on demand technique. Custom paging can be implemented using ObjectDataSource or ISDataSource. In general, custom paging implementation requires three important steps:

The heart of the custom paging is to provide custom logic for retrieving rows according to the current view of the WebGrid. This done via custom codes in the Select method. For more detail information, please check on this page.

By default, the classic paging will use automatic data retrieval mode. In automatic mode, WebGrid determines the total datasource rows based on the given datasource and display the current page appropriately. When uses automatic data retrieval, by setting the value of “PagingExportMode” property to “ExportAllData” will cause WebGrid to export all data (not current page only).

When uses custom paging, it is the datasource control that determines the amount of rows that will be given to WebGrid, thus when exporting on the first load will only export first page.

Hope this help.

*Please try to move the last page after the grid loaded; and then try to export the rows. It will export all data, since the datasource control has provides entire rows to WebGrid.