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.......
1 Answer, 1 is accepted
Unfortunately I could not reproduce this issue. I created a test project in my attempt to recreate the abnormality explained so far. I used the latest official build of RadControls. In the test project I create dynamically RadGrid and assign to it the same properties for export like you. I create and other page with declarative added grid with the same exported settings. I found that the time to export around 10000 rows on my local PC is little more than 1 minute.
If the problem persists, I suggest you to open regular support thread and to send us a working project that implements your logic.
Regards,
Georgi Krustev
the Telerik team
Check out Telerik Trainer, the state of the art learning tool for Telerik products.