Compare tables based on more than one column using LINQ?

[J0ska]

There are several topics related to DT join operation using LINQ.

How to left join two tables using Linq Query with all data in left table? Please Help

How to left join two tables using Linq Query with all data in left table? Please Help I need to left join two datatables “DT1” & “DT2” on Column “ID” and the result to be stored in FinalDT. [image] Query Used: (From a In DT1 Join b In DT2 On a(“ID”).ToString Equals b(“ID”).ToString Select FinalDT.LoadDataRow (New Object() { a.Field(Of String)(“ID”), a.Field(Of String)(“Name”), a.Field(Of String)(“Designation”) b.Field(Of String)(“Grade”) },False)).CopyToDataTable() I need to solve th…

Inner Join does not do as expected

Hi friends, I have two data tables: 1 - collectedFilteredDT 2 - allEntriesIDDT All Entries DT Collected Filtered: [image] When I perform an inner join, I become 0 rows in the joinEntIDDT: [image] What am I doing wrong? Thanks, Robert

Search the forum.

Cheers