Datatable - can we join data

  • Thread starter Thread starter Krish
  • Start date Start date
K

Krish

I have 2 tables each having a date in column1 and value in column 2.
I would like to extract out the common date entries from the 2 tables.
Ideally I would do a join in SQL, how do I do something like that in
datatables/dataviews etc.

regards
 
I have 2 tables each having a date in column1 and value in column 2.
I would like to extract out the common date entries from the 2 tables.
Ideally I would do a join in SQL, how do I do something like that in
datatables/dataviews etc.
Click to expand...

No, you cannot join tables like you can in SQL. You will either have to get the required data from each table seperately, or you can create a DataRelation between the tables on the date columns, find the date you need in the parent table, and then call DataRow.GetChildRows.

hth

kh
 
Back
Top