I don't know if this is possible, but here goes... I have a dataset containing three tables - one parent and two children. I have relationships set up between the parent and each of the child tables, but not between the child tables as they have no common fields. When I expand a row, I want both of the child tables to show in the same band. Can it be done?
The windows grid allows this functionality, so an existing UI is there for reference. But i agree it would make some pretty cool markup to create that for the web.
You can however as a workaround show a relationship selecter combo like suggested. There is a Band.ChildBandColumn property, which tells which child band to render.
Hope that helps.
Ahmad
Roger Bogh said: I mean, how would you display the contents of row one of talble one with row one of table two. Odd, very odd...
I mean, how would you display the contents of row one of talble one with row one of table two. Odd, very odd...
In the situation with 1 parent table and 2 child tables, you would expand row 1 of table 1 and the expanded row area would show 2 grids. All of the rows in table 2 that relate to row 1 of table 1 would be in one grid and all the rows in table 3 that relate to row 1 of table 1 would be in the other.
JebusJunkie,
Nice name, eh...
Even Microsoft Access doesn't display two child datatables in the same band. If it realizes that you have multiple tables connected via primary keys and foreign keys it asks you to select the child table you want to view. I think this is mostly a user interface issue - and not a data management or technical issue. I mean, how would you display the contents of row one of talble one with row one of table two. Odd, very odd...
But, how about prefilling a webcombo with the potential child tables that can then be used by the customer to select the child table he/she wants to view??? With some work, I think you could even place the webcombo inside a column in the parent table band. You would have to rebuild the dataset and relations on a change in the webcombo.
Once the relation is set you will have a parent/child webgrid that the customer has chosen.
Not perfect, but I see no other way to visually cue the customer
robifw6 said:this is crap
Life's a <bleep>, and then you die.
Kidding aside, this is one of the most commonly cited "I wish" features in all of WebGrid Land.
yep same problem here too, this is crap, i have found you can only use parent table - child table, not parent table, child table1, child table2..
Can someone from infragistics address this problem.