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
Hello,I am still following your case. Have you been able to resolve the issue?If you have any concerns or questions, please feel free to contact me, I will be glad to help you.Thank you for choosing Infragistics components!
This is Arunjith P.S. My Account has expired . This is my new Account
Thanks for the sample Source file . Currently our Application is using WebHierarchicalDataGrid grid not WebDataGrid. We have implemented the same logic (using WebHierarchicalDataSource and SQL Data Source) in WebHierarchicalDataGrid overall the performance is better than old one. But We don't get any data through Store Procedures . We successfully get data through DML Queries . The store procedure name and its parameters are set in code behind like below.
ReportWritterSqlDataSource.SelectCommand="usp_getData";
ReportWritterSqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
ReportWritterSqlDataSource.SelectParameters.Add("@dtmStartDate", DbType.DateTime, str_dtmStartDate);
ReportWritterSqlDataSource.SelectParameters.Add("@dtmEndDate", DbType.DateTime, str_dtmEndDate);
ReportWritterSqlDataSource.SelectParameters.Add("@alphaFilter", DbType.String, str_alphaFilter);
My suggestion is to create DataSet from store procedure and bind it to grid.
I am attaching samples for WebDataGrid. I believe they will help you to find right approach.
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