DataSet & DataTable Question?

[Guest]

I have two DataTables in a DataSet. I would like to create a third DataTable in the same DataSet that is a Join of the two original DataTables. The two tables are extracted from two different database on two seperate servers, so doing it at time of creation is not an option. How do you create a third DataTable in a DataSet that is a Join of the two Previous DataTables

Please reverse the email address when responding

 

[Miha Markic [MVP C#]]

Hi,

Check out these articles:
HOW TO: Implement a DataSet JOIN Helper Class in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;325688&Product=adonet
or
HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;326080&Product=adonet
and
HOW TO: Implement a Custom DataView Class in Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;325682&Product=vbNET

--
Miha Markic [MVP C#] - RightHand .NET consulting & software development
miha at rthand com
www.rthand.com

I have two DataTables in a DataSet. I would like to create a third

DataTable in the same DataSet that is a Join of the two original DataTables.
The two tables are extracted from two different database on two seperate
servers, so doing it at time of creation is not an option. How do you
create a third DataTable in a DataSet that is a Join of the two Previous
DataTables?