I generated a grid dynamically and then wht i studied
When i export for 100 records it works fine with a good speed
but when i export it with 30441 records and 10 columns it got too slow it took more than 10 minutes on my local pc .....and at last i got frustrated and stop the application .. to at the end of 1010 minutes too it was not able to export 30441 records .....
is there any thing i m missing in my code i my code.
RadGrid1.ExportSettings.FileName =
"Report1"
RadGrid1.ExportSettings.ExportOnlyData =
True
RadGrid1.ExportSettings.IgnorePaging =
True
RadGrid1.ExportSettings.Excel.FileExtension =
".xls"
RadGrid1.ExportSettings.Excel.Format = GridExcelExportFormat.ExcelML
RadGrid1.ExportSettings.ExportOnlyData =
True
RadGrid1.MasterTableView.ExportToExcel()
The same query when i fired on a grid which is designed and bind it wht sqldatasource it took less than 1 minute .....
so i m sure i m doing some thing wrong in the grid which i generated dynamically..... so can any one suggest me about wht i need to do......
In my dynamically generated grid wht i m doing is
adding the columns to the grid at page_load() event
then setting its datasource at need datasource event
so plz guide me wht is remaining in it.......