Multiple Relations

[Blake Weaver]

I've got kind of a Master/Detail question but its a little non-standard.
I've got 3 tables. One is the Master or Parent and two are more-or-less
Details or Children. I want to be able to select a row from the Master and
display columns from each of the children in a DataGrid. With one DataGrid,
its just DataTable.Relationship that you bind to the grid. How do you get
info from both children, or bind multiple relationships or whatever?

Thanks,
Blake

 

[Miha Markic]

Hi Blake,

Check it this article helps you:
HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;326080&Product=vcSnet

An another solution would be to add expression columns (to master table) and
let them retrieve child data.
See DataColumn.Expression .net help topic.