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
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.
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
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
You might want to check out the WinGrid Performance Guide.
There are parts of the guide that specifically address applying appearances to cells and rows in the most efficient way.
I assume that fro formatting of your data you are using InitializeRow event of UltraGrid. Have you reuse your appearance objects or you create new one for each row ? Creating of new appearance object is more time consuming than assigning of appearance object, so this could introduce a little bit delay. Also what processing of the data you are performing in order to decide how this row must be colored ? Processing of the data might be your biggest time consummator, if so you could tank on improving of processing of your data.
I am waiting for your feedback.