DataView Relations

[Guest]

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]]

Hi,

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

http://msdn.microsoft.com/library/d...ml/vbtskfilteringsortingdatausingdataview.asp

Use the currencymanager.positionchanged event to know the user moved to
another record.

http://msdn.microsoft.com/library/d...ndingmanagerbaseclasspositionchangedtopic.asp


Ken
--------------------
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]

Dave,

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

Cor