Export + PagingLoadMode="Custom"

yudi — Thu, 05 Nov 2009 22:33:33 GMT

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:

Set EnablePaging of the data sourcecontrol to True.
Provides a method for Select. This method requires three parameters: startRow, maximumRows, and sortExpression.
Provides a method for SelectCount.

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.

Export + PagingLoadMode="Custom"

pchanez — Mon, 02 Nov 2009 02:54:33 GMT

I have an issue to export data when being in PagingLoadMode="Custom". Even if I set the PagingExportMode = "ExportAllData", the grid only export the current page.

Is there a way to export all the data in this mode ?

Intersoft Community - WebGrid Enterprise - Export + PagingLoadMode="Custom"

Export + PagingLoadMode="Custom"

Export + PagingLoadMode="Custom"