Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
560
Hierarchical Grid to create a BOM like structure
posted

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:

Part

Description

 

I've seen I have to "flat" these structure to two tables within one dataset to build a hierarchical grid:

 

Table Root:

Part

ParentPart

Description

 

Table Child:

Part

ParentPart

Description

 

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!

Parents Reply Children
No Data