Hi Xu Guochun,

To export all records in WebGrid, just simply set the property PagingExportMode="ExportAllData". I've tried to make a sample based on your sample, but I couldn't replicate your issue. Could you give me a simple runable sample so that I could check it on my end?

Regards,

Lili Khiung

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.

Hi,

     I set the property like this, but the issue is still exist.

     <LayoutSettings PagingMode="ClassicPaging" PagingLoadMode="Custom" PagingSize="20" PagingDataRetrievalMode="ReturnPartialRows" AllowExport="Yes" PagingExportMode="ExportAllData">
            </LayoutSettings>

     The attchments is Code and Database.

Help me please!

Thanks!

In custom paging scenario, it is the datasource control, in this case is ISDataSource, that determines the amount of rows that will be given to WebGrid. In a simple word, if page 1 is opened, ISDataSource will provide row #1 – row #20; and if last page is opened, ISDataSource will provide all rows.

In order to get a clearer picture, please try to open first page and export the data. Next, open page #2 and export the data. Note that when page #2 is opened, the exported result will show rows from page #1 till page #2. Last, open last page and export the data.

This is the default behavior of the custom paging scenario.

Hi,

     I click the "next page" to goto page #2, then export the data, but the excel file only contain #21-#40, 20 records.

     How can I Export all data in this scenaio?

      Thanks!