Intersoft Community - WebGrid Enterprise - Exporting all records irrespective of the no. of records displayed

Exporting all records irrespective of the no. of records displayed

yudi — Wed, 28 Dec 2011 22:09:26 GMT

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.

Exporting all records irrespective of the no. of records displayed

Skgrid@intersoftpt.com — Wed, 28 Dec 2011 07:16:29 GMT

Hi Yudi,

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

Thanks in advance

Exporting all records irrespective of the no. of records displayed

yudi — Tue, 20 Dec 2011 03:12:50 GMT

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.

Exporting all records irrespective of the no. of records displayed

Skgrid@intersoftpt.com — Sun, 18 Dec 2011 23:09:07 GMT

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.

Exporting all records irrespective of the no. of records displayed

yudi — Sun, 18 Dec 2011 14:48:45 GMT

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.

Exporting all records irrespective of the no. of records displayed

Skgrid@intersoftpt.com — Fri, 16 Dec 2011 01:37:10 GMT

Hi Team,

I have hundreds of records, but the virtualpagesize is 50, i.e., at a time it will display only 50 records. But I want to export all records irrespective of the no. of items loaded in the grid.

We are having the below properties set for the webgrid:

allowexport="yes"

pagingmode="VirtualLoad" virtualloadmode="Custom"

virtualpagesize="50"

Your help is appreciated.