Remove data row if the value cannot be find in an array

[supermanPunch (Arpan)]

@RGT , Could you try the below Expression :

arrayRow = DT.AsEnumerable.Where(Function(x)Not(dateArray.Any(Function(y)CDate(y)=CDate(x("YourDateColumn").ToString)))).ToArray

here arrayRow is a variable of Type Array of DataRow, and DT is the Input Datatable, dateArray is a variable of Type Array of String.

Using arrayRow we can Check if it consists any rows and then convert it to Datatable.
Following Post Explains the conversion :

[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…