Hi,
I've been looking for a simple way to let a client know that the data is being delivered; I've seen examples for using the RadAjaxLoadingPanel with a RadGrid. I think generically this probably works, but in my case it doesn't. I end up getting OutOfMemoryException errors.
If I disable the RadAjaxLoadingPanel, the export to Excel works fine -- and fairly quickly.
Admittedly there is a lot of data to export -- over 72K rows. Still, I'm not asking the RadAjaxLoadingPanel to do anything special except display while the grid changes.
If I do a paging operation, the control works fine. It's just on the export that it gives up.
Here's the gist of the code:
Is there something I'm missing?
Thanks,
Glen
I've been looking for a simple way to let a client know that the data is being delivered; I've seen examples for using the RadAjaxLoadingPanel with a RadGrid. I think generically this probably works, but in my case it doesn't. I end up getting OutOfMemoryException errors.
If I disable the RadAjaxLoadingPanel, the export to Excel works fine -- and fairly quickly.
Admittedly there is a lot of data to export -- over 72K rows. Still, I'm not asking the RadAjaxLoadingPanel to do anything special except display while the grid changes.
If I do a paging operation, the control works fine. It's just on the export that it gives up.
Here's the gist of the code:
<tk:RadAjaxManager ID="ramGridWait" runat="server"> <AjaxSettings> <tk:AjaxSetting AjaxControlID="rgGlobalInventorySummary"> <UpdatedControls> <tk:AjaxUpdatedControl ControlID="rgGlobalInventorySummary" LoadingPanelID="ralpGridWait" /> </UpdatedControls> </tk:AjaxSetting> <tk:AjaxSetting AjaxControlID="rbExport"> <UpdatedControls> <tk:AjaxUpdatedControl ControlID="rgGlobalInventorySummary" LoadingPanelID="ralpGridWait" /> </UpdatedControls> </tk:AjaxSetting> </AjaxSettings> </tk:RadAjaxManager> <tk:RadAjaxLoadingPanel runat="server" ID="ralpGridWait" InitialDelayTime="3000" Skin="WebBlue" /> <tk:RadAjaxPanel ID="RadAjaxPanel1" LoadingPanelID="ralpGridWait" runat="server"> <tk:RadGrid ID="rgGlobalInventorySummary" runat="server" OnNeedDataSource="rgGlobalInventorySummary_NeedDataSource" AllowFilteringByColumn="true" EnableEmbeddedSkins="true" BorderStyle="Solid" Skin="WebBlue" Width="100%" AllowPaging="true" PageSize="20" ShowFooter="true" PagerStyle-Position="TopAndBottom"> <ExportSettings ExportOnlyData="true" HideStructureColumns="true" IgnorePaging="true" /> <ClientSettings Selecting-AllowRowSelect="true"> <Resizing AllowColumnResize="true" EnableRealTimeResize="true" /> </ClientSettings> <MasterTableView AutoGenerateColumns="false" Caption="" ShowHeader="true" CommandItemDisplay="TopAndBottom"> <CommandItemSettings ShowAddNewRecordButton="false" ShowExportToExcelButton="true" ShowExportToPdfButton="false" ShowExportToWordButton="false" /> <Columns> <tk:GridBoundColumn DataField="Status" HeaderText="Status" HeaderStyle-HorizontalAlign="Center" HeaderStyle-Width="85px" ItemStyle-HorizontalAlign="Left" AllowFiltering="true" FilterControlWidth="60%" /> </Columns> </MasterTableView> </tk:RadGrid> </tk:RadAjaxPanel>Is there something I'm missing?
Thanks,
Glen