Hi, i need to compare 2 dataTable and the specific column.
As you can see i have a cloumn named “Tutar”
i need to take rows which has different values in it as you can see in the pictures. And i want to do it with LINQ.
I used this one but didn’t work or couldn’t write properly.
dtFirst.AsEnumerable.Where(Function(row) dtSecond.AsEnumerable.Where(Function(row2) Convert.ToDouble(row.Field(of object)(“Tutar”)).Equals(Convert.ToDouble(row2.Field(of Object)(“Tutar”))) ).FirstOrDefault is Nothing).CopyToDataTable
could you help me on that?