How to compare two dataTables with different column names but with the same values?

[pravin_calvin (pravin kumar)]

Hi @Kakooza-Allan-Klaus

Check with the below thread for join using Linq!

Joins using Linq

Hi all, I’m trying to join 2 dataTables and then filter that joined dataTable using Linq query. [dt1] [dt2] So, for that I’ve used following query: (From DT1 In dt1.AsEnumerable() Join DT2 In dt2.AsEnumerable() On DT1(“ID”).ToString() Equals DT2(“SID”).ToString() Select DT2).ToArray().CopyToDatatable By this I’m able to get Data from one of the 2 DataTables, with ID’s —> 1, 2 and 3. Only which is right. But, now I want Data from both DataTables (As one joined DataTable with Columns —> I…

Regards