I want to compare 2 DT using linq, DT2 compare to DT1, when the column WSID is match, value from Nominal will write from DT2 to column KWW in DT1 and when Nominal is null or empty, the value is set to " "
Where DT1 is
Give a try on
(From d1 In dt1.AsEnumerable
Join d2 In dt2.AsEnumerable
On d1(“WSID”).toString.trim Equals d2(“WSID”).toString.trim
Select d1).CopyToDatatable