MasterDetail Datagrid and Dataviews

  • Thread starter Thread starter dfjhsqd
  • Start date Start date
D

dfjhsqd

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
 
dfjhsqd,

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

Regards,
Erik
 
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.
 
Back
Top