I'm using the windows.forms.datagrid to display 2 related tables from a
dataset. I've related the 2 tables using a dataset relation object and
bound the grid initially to the parent table. As far as the grid display
goes, everything works as expected - you can drill into the parents and link
to each parent's child rows.
However, I also have some text boxes on the form bound to the same dataset
tables (for editing parents or children). When parent rows are selected in
the datagrid, although the CurrencyManager's position for the parent table
is changed (and therefore the values in the parent's textboxes follow),
having linked to a parent's children, selecting a child row does not cause
the child table's currency manager to be re-positioned, resulting in the
children's bound textboxes not being populated (if I manually change the
position of the children's currency manager, they are).
Is this a bug or by design, and is there a workaround to get the most out of
this datagrid parent-child feature?
An obvious approach would be to re-position the child records' data manager
manually in the datagrid's navigate event, but there doesn't seem to be a
way to relate the 2 rows (and I've done that in the dataset's relation
I'd appreciate it if someone could point me in the right direction with this
one or at least confirm it's a known bug....I can stop pulling my hair out