Hi, Could someone help me to get all different values from dt1 to dt2. I need to check if data in column “id” from dt1 isn’t in column “id” from dt2, and put these values in a datatable. There are a lot of rows, and that’s why I want to use linq. I am using vb. Thanks!

(From d1 In dt1.AsEnumerable Where Not dt2.AsEnumerable.Any(Function (x) x(“ID”).toString.Trim.Equals(d1(“ID”).toString.Trim)) Select r=d1).CopyToDataTable

Use linq to get different values between two tables

ppr (Peter Preuss) April 22, 2022, 8:16am 12

1 Like

Use linq to get different values between two tables