Need to Compare Two datatable columns and remove the rows

[ppr (Peter Preuss)]

your case can be understood as a

• Join DataTable case - then postprocessing the JoinResult
• Match case

Match case:
Assign Activity
dtFiltered =

(From d in dt1.AsEnumerable
Let k = d("Column1").toString.Trim.ToUpper
Where Not dt2.AsEnumerable.Any(Function (d2) d2("Column1").toString.Trim.ToUpper.Equals(k))
Select r = d).CopyToDataTable

In case of an empty result is also to expect we can handle by:

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…