Many-to-many (two parent) databinding

microsoft.public.dotnet.framework.adonet

30 Oct 2006 2:57 AM

Earl

Done a lot of reading on this issue, including the post by Bill Ryan, and
was wondering if this is as good as it gets.

I have quite a few many-to-many relationships in an app I'm currently
working on, but I'll just discuss one as an example. I have the main product
information in a parent table, the various costs in a parent table, with a
3rd table for the junction.

Obviously I can bind a parent table to a datagridview using a bindingsource.
Where the whole concept gets tricky is how to display the cost data in a
manner in which it can also be updated.

Frankly, I find the typical Microsoft examples of using a second datagrid
for parent-child/master-detail to be numbingly stupid-looking and apparently
just a kludge for not having the controls that can handle that scenario.

But I digress. In this case, we're talking about displaying 2 parent tables
(while hiding the junction table). One solution I've used is to bind the
product parent table to the datagridview and the cost parent table to
textboxes and combos. Is this as good as it gets?