Forums Ultimate UI for Windows Forms
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
Close
Dale
2430
Does the grid support link tables (aka a table that links 2 tables together)
posted

I I have 4 tables: RCM_OBJECT_TYPES (key = Object_Type), RCM_BOM_PRIME (key is Object_Type + BOM_Prime_Key), RCM_BOM_COMPONENT_LINK (key is Object_Type + BOM_Prime_Key + Component_Key => Links the prime with its components => aka multiple components per Prime object but also a given component can be linked to multiple Prime components), RCM_BOM_COMPONENT (BOM_Component_Key).

I don't really want to display the RCM_BOM_COMPONENT_LINK table (aka I want to hide the band but show the child band (Components)).

Is there a way of doing this?

  • 469350
    Offline posted

    Hi,

    The grid will display the data in the DataSource you assign it. There is no way to hide a band without hiding it's child bands in the grid. So the only way to do what you want here would be to modify your data source so that the middle band is not there and the root band is joined directly to the grandchild rows you want.

    I am pretty sure there are ways to do this with SQL, but it's been a long time since I did any serious SQL, so your best bet there would be Microsoft's documentation.

    Another option would be to not bind the grid directly to your data source, but build another data source or use some sort of intermediary like UltraDataSource.