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,
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
Another sample.
currently we are using binding the data using dataset. but In the case of large record binding get performance issue.
We will analyse the sample code reply back soon.
Thankss. We analysed the data binding using dataset and ObjectDataSource and implemented this logic in Sample source file , its working fine . Successfully bind 60000 records with paging. will update you if any other issues occur.
In WebHierarchicalDataGrid , could not export to filtered/ sorted datas to excel . we need to export all filtered/ sorted pages in the grid (WebHierarchicalDataGrid )
please help me a solution for exporting filtered and sorted list from WebHierarchicalgrid to excel