getting parent and child tables from datagrid

[astro]

Can someone show my example syntax that gets pointers to both the parent and
child tables of a datagrid on a form showing a child table? The datasource
is a dataview, the datamember is the relationship name (e.g. 'OrderDetail')

i.e.....(air code following)

dim dtParent as dataTable
dim dtChild as dataTable

dtParent = mygrid.....
dtChild = mygrid

thank you.

[Bart Mermuys]

Hi,

"astro" <as***@mnrr.com> wrote in message
news:yW********************@tornado.rdc-kc.rr.com...

Can someone show my example syntax that gets pointers to both the parent
and child tables of a datagrid on a form showing a child table? The
datasource is a dataview, the datamember is the relationship name (e.g.
'OrderDetail')

i.e.....(air code following)

dim dtParent as dataTable
dim dtChild as dataTable

If you know DataSource is a DataView, then you can do:
dtParent = DirectCast(mygrid.DataSource, DataView).Table

And if you know that DataMember is a relation, then you can do:
dtChild = dtParent.ChildRelations(mygrid.DataMember).ChildTa ble

I'm not sure why you would want to do this, you will end up with the same
tables you filled with the DataAdapters.

hth,
greetings

thank you.

[astro]

thank you - that worked )

"Bart Mermuys" <bm*************@hotmail.com> wrote in message
news:eS**************@TK2MSFTNGP09.phx.gbl...

Hi,

"astro" <as***@mnrr.com> wrote in message
news:yW********************@tornado.rdc-kc.rr.com...

Can someone show my example syntax that gets pointers to both the parent
and child tables of a datagrid on a form showing a child table? The
datasource is a dataview, the datamember is the relationship name (e.g.
'OrderDetail')

i.e.....(air code following)

dim dtParent as dataTable
dim dtChild as dataTable

If you know DataSource is a DataView, then you can do:
dtParent = DirectCast(mygrid.DataSource, DataView).Table

And if you know that DataMember is a relation, then you can do:
dtChild = dtParent.ChildRelations(mygrid.DataMember).ChildTa ble

I'm not sure why you would want to do this, you will end up with the same
tables you filled with the DataAdapters.

hth,
greetings

thank you.