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