Hi Infragistics-Team,
I'm trying to figure out how to create a BOM-like structure within the UltraGrid:
Let's assume I have parts, parts can contain another parts and all have the same properties (fields). We have a table structure like this:
Table PartStructure:
Part
ParentPart (can be null to set the root level)
Table PartDetail:
Description
I've seen I have to "flat" these structure to two tables within one dataset to build a hierarchical grid:
Table Root:
ParentPart
Table Child:
These two tables are linked with 2 Relations:
ChildTableToRootTable (ParentPart -> Part)
ChildTableToChildTable (ParentPart -> Part)
This create multiple levels of Bands within my UltraGid:
Why is this? I simply want that every row looks the same.
Why does it create 7 Bands. Does this mean I can only go 7 levels deep?
The grid itsself is working, but I have problems to allow childs within childs (they also show up within the root):
Maybe my approach is wrong and maybe I need only one table referencing itsself. But then I must find a solution to hide the rows on the root-level when they have no ParentPart.
Thank you very much for your thoughts,
Frank!
Hi Frank,
These extra bands look like a bug in the grid designer that was recently fixed. Are you using the latest Service Release? If not, you should get it and that should clear it up.
Hi Mike,
okay, then I have two questions.
1. I'm forced to use NA 8.1. I downloaded the service release yesterday but I can't install it:
This means (in english): you can't install because the program you are trying to upgrade is maybe missing or because the upgrade would upgrade another version of the program.
I have NA 8.3 and 8.2 also installed on this machine and will try to deinstall them now and reinstall the patch.
2. Question: How can I realize this BOM relation correctly? This is the more important question.
Thank you very much,
Frank
I uninstalled all of the Infragistics and reinstalled 2008.1. But I'm still not able to install the Service Release. Can you supply me with another installer?
Thanks,
When applying a service release you have to make sure that patch installer you are using matches the name of the product you have installed. For example, if you installed the NetAdvantage for WinForms product then you would need the NetAdvantage for WinForms patch file.
Please double check the name of the installer you are using and download the matching service release from the My Keys and Downloads section of the Infragistics website.
I'm going to forward your post over to Developer Support team and they should be able to help you get the service release installed.
I think your data structure is correct. You just need to have a DataSet with a table and a relationship such that the table points back to itself to create a recursive data source.