WebGrid has PagingExportMode property that specifies whether WebGrid should export only the current page view or the entire dataset. Unfortunately, this property only works when PagingMode is set to ClassicPaging.

As shown in here, it is possible to manipulate the export result in OnExport server-side event. The idea is, provide the entire dataset in OnExport event so that we’ll have all records as the export result. However, I still have no luck when try to implement your required scenario using this approach.

I’m afraid that this scenario is not supported yet in the current build version of WebGrid (WebGrid 7 build 800). Please give me more time to discuss this with the development team. I’ll keep you informed with the result.

Hi Yudi,

Thanks for your response.

As a workaroun we are ready to put some button in our page to export the required data, but is there any API to export the data.

That is; instead of getting data from the grid we want to provide the dataset/table to the export API, which the API should export it.

Unfortunately it is a scenario that is not supported by the current version of WebGrid.

I have submitted a feature request to WebGrid development team regarding this. The feature request is filed under Task #1097. Should I hear any news regarding Task #1097, I let you know at once.

Hi Yudi,

Can we have an option in WebGrid which allows me to load and display all records?

Thanks in advance

There are three modes of VirtualLoadMode: Default, LargeData, and Custom.

Using LargeData or Custom option in VirtualLoadMode property restricts the users to export ALL the data. Only a certain batch of data, which has been retrieved by users, will be exported to the medium. Therefore, in order to export ALL data, the VirtualLoadMode property needs to be configured to Default option temporarily and invokes the RebindDataSource() method.

Hope this helps.