Hi there
We are using the UltraWinGrid v13.2.20132.2023 in a VS 2010 .NET 4.0 C# WinForms application.
I have 2 large typed ADO.NET DataTables with each feeding there own UltraWinGrid.Each table is loaded with approx 4000 rows of data.There is NO Data Relationship between the 2 tables.The tables are fully loaded with a SqlDataAdapter, I require them to be fully loaded as I need to chart on the data in the grid.
The data in both the grids is readonly but does require some formatting i.e. font color, back color etc.
The time to load the datasets is acceptable but due to the requirement to format rows in the grid I am finding that the time taken to load the data into the grids to quite considerable and I would like to gain some improvements.
Given my requirements what alternatives/options/techiniques do you think I could use to improve performance in loading the grids?
Thanks in advance.
Regards
Geoff
Hello Geoff,
I am just checking about the progress of this issue. Let me know if our suggestions worked for you or if you need our further assistance.
Thank you for using Infragistics Components
Hi Milko
I managed to work around this by using the following technique
1/ Load my typed dataset with all rows, the performance of this is pretty good
2/ Bind my UltraWinGrid to a 2nd typed dataset of the same type as the one above that I loaded with data but this 2nd dataset is empty.
3/ Move (NOT copy) from the 1st dataset to the 2nd dataset in chunks of 200 records at a time using the grids AfterRowRegionScroll event. By moving the data rather than copying I decrease the size of the source dataset whilst growing the size of the target dataset.
Thanks
Hi,
Thank you for contacting Infragistics Developer Support.
I am glad that you have resolved your issue. Let me know if you have any additional questions.