I've been combing documentation, the API's and this forum, but I am coming up a little short for my situation.
I have a DataSet with 3 DataTables.
ParentDataTable
ChildOneDataTable
ChildTwoDataTable
Each ChildDataTable is tied back to the ParentDataTable with a relation.
I would like to specify to show the the data in a heirarchical view between the ParentDataTable and ChildTwoDataTable.
I am setting the WebGrid.DataSource property in the code behind and then calling the DataBind Method.
How do I specify to show two bands and bind to the appropriate datatables in the dataset?
The version I'm using is NetAdvantage 3.5.
Is ChildTwoDataTable directly related to ParentDataTable, or is the relationship indirect, with ChildTwoDataTable directly related to ChildOneDataTable which in turn is directly related to ParentDataTable?
If the relationship is direct, or if you are willing to show the intermediate table, you can do something like this:
http://forums.infragistics.com/forums/p/3298/17902.aspx#17902
If the relationship is indirect, and you need to not show the middle table, I would sugest that you combine the two ChildTables into one denormalized table in your datasource.
Both ChildOneDataTable and ChildTwoDataTable are directly related to the ParentDataTable.
Ideally, I would like to instruct the Grid to create a band for ParentDataTable and ChildTwoDataTable before the DataBind (There may be times in the future where I would like to Bind to ParentDataTable and ChildOneDataTable and not display ChildTwoDataTable).