MasterDetail Datagrid and Dataviews

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dfjhsqd - 11 Aug 2004 09:03 GMT

Hi all

I have a form with 2 datagrids (master-detail)
and a combobox to create a filter for the masterdatagrid.

The master-detail worked fine when i used a dataset like this :

drelRelation = New DataRelation _
("drelMasterDetail", dsMasterDetail.Tables("tblMaster").Columns("ID"), _
dsMasterDetail.Tables("tblDetail").Columns("MasterID"))
dsMasterDetail.Relations.Add(drelRelation)
dtgMaster.SetDataBinding(dsMasterDetail, "tblMaster")
dtgDetail.SetDataBinding(dsMasterDetail, "tblMaster.drelMasterDetail")

BUT now I wanna use the combobox for filtering, so I thought I could use the
DataView and the RowFilter-property

but then i can't get my master-detail part right?????
anyone any idea?
or is there a better way for this? I'm still a newbie

Thanx in Advance

Reply to this Message

Engineerik - 14 Oct 2004 16:13 GMT

dfjhsqd,

Did you find out how to do this? I had the same setup and ran into the
exact same problem.

Regards,
Erik

> Hi all
>
[quoted text clipped - 18 lines]
>
> Thanx in Advance

Reply to this Message

Scave - 22 Oct 2004 01:20 GMT

Attach a handler to the combobox SelectedValueChanged event.
In this handler, filter the CurrencyManager's DataView according your
criteria.
Which DataView is that?
This one:
DataView myView = (DataView)myCurrencyManager.List;

I haven't used this particular technique in my code but it should work
roughly like that. Let me know how it goes.

> > Hi all
> >
[quoted text clipped - 18 lines]
> >
> > Thanx in Advance

Reply to this Message

MasterDetail Datagrid and Dataviews

Free Magazines