Joining DataTables ?

[meinhunna]

Is there anyway of Joining two or more DataTable with similar structure?

I have three DataTables with following structures

Data, AmountB/F, Repayments, InterestCharged and AmountC/F

i want to join these tables on the basis of Date. I don't want three rows for each date, i want the values to be added for similar dates.

thanx

 

[eblattner]

How about something like this...

SELECT Date, AmountB/F, Repayments, InterestCharged, AmountC/F
FROM table1
INNER JOIN table2 ON table1.Date = table2.Date
INNER JOIN table3 ON table2.Date = table3.Date

Not sure what your table names were, so I used table1, table2 and table3

 

[meinhunna]

Well I am talking in terms of DataTable object in .NET Framework, not Database tables.

 

[ca8spo]

You can use the DataRelation class.

Something like this-

'Create a new DataRelation
Dim rel As New DataRelation(strRelationName, dsDataSet.Tables("Table1")).Columns("Primary Key"), dsDataSet.Tables("Table2").Columns("Foreign Key"), False)

'Add the Relation to the DataSet
dsDataSet.Relations.Add(rel)