Is there a way to simulate bands with the wingrid.I have a datatable with a recursive relationship. The problem is that the WinGrid can only display up to 100 bands and the data table may have more levels than this.Do you have any suggestions for handling this issue?
Thank you,Seradex
Hi Seradex,
The grid limits the data to 100 bands because of the MaxBandDepth property. So if you need to show more data than that, you can simply set MaxBandDepth to a higher number (although there is always a limit - there's no way to have infinite bands).
However, please note that this will not work very well in many cases. In my experience, the BindingManager in DotNet can't handle anywhere close to 100 bands. In fact, you will probably start experiencing severe performance problems at between 5 and 8 levels of hierarchy, depending on your data source.
In reality, no human user could possibly work effectively with much more depth than that, anyway.
If you don't need filtering, summaries, or exporting, you might consider using the UltraWinTree instead of the UltraWinGrid. The tree loads the data more efficiently on-demand. So it doesn't create all of the BindingManagers up front like the grid does. You will probably still run into performance problems using the tree, but they won't happen until the user actually drills down into the data.
Does the UltraWinTree support multiple columns of information? I didn't think it did.
The purpose of the tool that is being written is to track shipped inventory data back to their source through many changes including producing items from other items (many to one scenario).
Going that number of levels may not happen often, but I would like to try to eliminate this as a potential problem. My DataSource is a single datatable with approximately 5 columns of data. It is unlikely that this datatable will have thousands of rows of data. Most likely 2 to 200 rows at the most. Note that as I mentioned previously that this is a datatable with a recursive relationship. Also, the grid's top band would only display the items that have no "parents".
Note that I have tried setting the MaxBandDepth to greater than 100 at design time and it keeps telling me that this is not a valid value.
I appreciate your help with this.