Retrive data of the parent relation in datagrid

[Jimmy Lu]

Hi all,

I display the data of two tables by a relation in the DataGrid control. I
do not know how to retrive the data of the parent table, When I am browsing
the child table. Any idea will be appreciated?

Jimmy

 

[Cor Ligthert [MVP]]

Jimmy,

It depends very much what is the source of your datatable. However you can
foever find the datarow that you are using.

If you than use a datarelation to create your child tables, than you can
find in the datarow this method. However it is not needed for the parent
child approach that you use a datarelation. So let us start with assuming
that you do.

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

I hope this helps,

Cor

 

[W.G. Ryan - MVP]

Like Cor mentions, you can use GetParentRows if what you need is simply the
values of the Parent row in their original state. You can use Compute
though if what you need . If you check the Parent/Child Relation
Referencing section on this page
(http://msdn.microsoft.com/library/d...fsystemdatadatacolumnclassexpressiontopic.asp)
it may be what you're looking for.