Hi,
I have a dataset with 2 tables in them. They are not related. They both however, have a foreign key referencing the same key in another table.
When I bind the dataset to the grid, only 1 table gets bound.
I cannot relate the 2 tables but want both of them to be displayed as separate bands in the grid.
Can I do that?
Thank You,
WinGrid is only capable of displaying related data, which shows as a hierarchy. It can only have one "root" level band.
If you're including the parent table in your grid, then both of these tables will be displayed as children of that parent table.
If you're not including the parent table, then you can only show one of these two tables at a time in a single WinGrid. To display both tables, you'll need two separate WinGrid controls.
You might also consider using UltraWinTree instead of UltraWinGrid. It lacks certain grid features like filtering and summaries. But it supports binding collections of nodes. So you could have two root nodes in your tree and show each table under a different node in the same tree.