DataView Relations

[Dave Prouten]

Hi all,

Can anyone help me with this.

I have 2 datagrids on a form, the parent datagrid has a DataView as it's
DataSource.

Can anyone help me with the syntex of how to create a relationship between
them.

I can do it with a DataTable but not a DataView and the way the parent
datagrid is filled requires it to have a DataView as it's DataSource.

Thanks in Advance



Dave

[Ken Tucker [MVP]]

Re: DataView Relations

Hi,

You will have to filter the records with the dataview.filter method.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbtskfilteringsortingdatausingdataview.asp

Use the currencymanager .positionchange d event to know the user moved to
another record.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwindowsformsbindingmanagerbaseclasspositionchangedtopic.asp

Ken
--------------------
"Dave Prouten" <DaveProuten@di scussions.micro soft.com> wrote in message
news:63FC8708-A59A-4FE3-8A01-547FF19F35BC@mi crosoft.com...
Hi all,

Can anyone help me with this.

I have 2 datagrids on a form, the parent datagrid has a DataView as it's
DataSource.

Can anyone help me with the syntex of how to create a relationship between
them.

I can do it with a DataTable but not a DataView and the way the parent
datagrid is filled requires it to have a DataView as it's DataSource.

Thanks in Advance



Dave

[Cor Ligthert]

Re: DataView Relations

Dave,

My expirience is the same as Ken that this dataview.rowfil ter method is much
flexibeler.

Cor