Intersoft Community - WebGrid Enterprise - Child tables with different columns

Child tables with different columns

yudi — Wed, 16 Mar 2011 03:25:28 GMT

Glad to hear the good news.

Should you need further assistance or run into any technical problems regarding our controls, feel free to post it into our forum. We would be happy to assist you again.

Child tables with different columns

RobertPehrson — Tue, 15 Mar 2011 05:43:53 GMT

Thanks, Yudi, I see it now - the ChildTables property of the root table is a WebGridTableCollection that can contain more than one child table. The children of each parent row can then be from any of these child tables (and you can even take a row's children from multiple tables!) I've adapted the tutorial to show this and it's looking good.

Child tables with different columns

yudi — Tue, 15 Mar 2011 00:27:42 GMT

In the bound mode of hierarchical WebGrid, the parent table and the child table need to have a data relation. Suppose there are two tables, Products and Categories. Products and Categories are related where a Category item may has many Product items. This relation indicated by the existence of [CategoryID] column inside Products table.

When Products table and Categories table are bind to hierarchical WebGrid. The Categories will be the parent table and the Products will be the child table.

Unlike the bound one, the Hierarchical_Unbound_Programmatic tutorial file shows that WebGrid supports pure unbound mode through server-side object model. In the tutorial, the main Grid object; the RootTable and its columns; and the ChildTable are programmatically created in code behind. The root rows and the child rows are added to the Grid programmatically as well.

Note that when the grid is operating in unbound mode, all data-bound operations – such as sorting, grouping, etc – should not be enabled.

Please let us know your response

Child tables with different columns

RobertPehrson — Mon, 14 Mar 2011 11:49:37 GMT

It seems that in the WebGrid all child tables have to have the same columns. I can't see how to implement child tables where the child table for each row in the root table has it's own set of columns. Maybe it's not possible - for example the Hierarchical_Unbound_Programmatic example shows data being loaded dynamically into child tables, but the schema of the child table is fixed.

There may be another solution, since the child tables do all have the same rows - they are "inverted" from the database structure, the rows becoming columns and the columns becoming rows. However, as far as I can tell WebGrid does not do inversion either.

Any ideas, anyone?