Do a vlookup using LINQ and assign the value to the specified column

[rahulsharma]

I believe, you need to find the common and uncommon rows on the basis of comparison of one column value in two datatable.

There are couple of ways to do that, below is the best and cleanest.

How to compare and find not matching item in two data tables?

have a look here as an introduction to the topic: also find some starter help here: Find_Common_NonCommon_By1Col.xaml (12.3 KB) another option is to work with the dataset operation