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
and DT2
Now I using for each row inside a for each row, but the process is take a long time. Thanks for the reply and have a nice day!