This is a migrated thread and some comments may be shown as answers.

[Solved] System.OutofmemoryException with Export

2 Answers 170 Views
Grid
This is a migrated thread and some comments may be shown as answers.
newbie
Top achievements
Rank 1
newbie asked on 17 Jun 2008, 06:07 AM
I use the export to ecel functioanlity to export my grid to an excel file.

When I had large amount of data in the grid(I am not talking of millions of records, maybe around 5-10,000) and I clicked the export button nothing happens. On some debugging it appeared that its throwing a Syste.OutofMemoryException.

Is this a known Issue?
Do I need to set some properties that will handle this scenario?

Please help.

2 Answers, 1 is accepted

Sort by
0
Princy
Top achievements
Rank 2
answered on 17 Jun 2008, 06:28 AM
Hi Newbie,

Try setting the IgnorePaging property to false while exporting the Grid to Excel.

CS:
 protected void Button1_Click(object sender, EventArgs e)  
    {  
        RadGrid1.ExportSettings.IgnorePaging = false;  
        RadGrid1.MasterTableView.ExportToExcel();  
    } 


Princy.
0
newbie
Top achievements
Rank 1
answered on 17 Jun 2008, 04:51 PM
It works with IgnorePaging set to false but I want to export all the data in the grid.
IgnorePaging =  false only exports the current page.
Tags
Grid
Asked by
newbie
Top achievements
Rank 1
Answers by
Princy
Top achievements
Rank 2
newbie
Top achievements
Rank 1
Share this question
or