I can't bind large number of records( around 20000 - 30000 records) to WebHierarchicalDataGrid . Please help me a solution for binding very large number of record using WebHierarchicalDataGrid without getting any issues and I also need to export the binded records to excel .
Hello,
This is an initial update to let you know that I have received your support request and will be looking into this matter for you. I will follow-up with you regarding my findings.
Best Regards,
You could add paging in order to optimize the performance.
Regards,
Please check attached demo source file. we still can't bind large number of records(25000 - 30000) after implementing paging(page size=50) . we also need to export these records to excel. please help me for a solution
Thanks for the sample. I will investigate it.
Look at this sample how to export to EXCEL - http://www.infragistics.com/samples/aspnet/excel-exporter/exporter-webhierarchicaldatagrid
I have tested WebHierarchicalDataGrid connected to MS SQL database. It has 30 000 row and it's working properly. You may use this approach instead generating the list in server side.
This post could be helpful - http://www.infragistics.com/community/forums/t/52059.aspx.
Here a topic on WebDataGrid Performance - http://download.infragistics.com/marketing/infragistics-aspnet-ajax-web-data-grid-performance-whitepaper.pdf