O.k. - need a little help here - I'm a WinForms Developer trying to help out our Web Developer.
We have built a hierarchical data source. The best I can represent it is as follows (dt = data table)
- Parent (Location or Site) dt1 data
- - Child 1 (Local Device Master) dt2 data
- - Child 1 (Local Device Master)
- - - Child 2A (Remote Device Master) dt3 data
- - - - Child 3 (Remote Item - on remote master) dt5 data
- - - - Child 3 (Remote Item - on remote master)
- - - Child 2B (Item on Local Device Master) dt4 data
- - - Child 2B (Item on Local Device Master)
- Parent (Location or Site)
Data Set Relations (Parent <- Child):
dt1 <- dt2
dt2 <- dt3
dt2 <- dt4
dt3 <- dt5
Now - on to the problem. We are using the EXACT same code to build the data set & apply the data relations.
When I bind a Windows Forms Grid to the Datasource - it displays exactly as expected and shown above.
When he binds it to a WebGrid - we are not seeing any of the "Child 2B Data" for the Child 1 nodes.
And that's about as much as I am smart enough to relate so please feel free to ask questions for further explanation.
And thanks in advance for the help.
Vince,Thank you very much for your reply.I was guessing that this was in-fact the case based on some experimenting we did yesterday.We managed to work around this by performing a few SQL Query tricks and combining the 2 data tables into 1.
Thank you again for your help.
Stephen
The issue here is that you have a multiple inheritane situation. WebGrid cannot display multiple child tables for a single parent table.
n2dfire said:Data Set Relations (Parent <- Child): dt1 <- dt2 dt2 <- dt3 dt2 <- dt4 dt3 <- dt5
WinGrid, as you've found, has the ability to show multiple relations.