I have datatable and a list of string (having years) need a select query to fetch those records from datatble that is containing the items from list

[supermanPunch (Arpan)]

@sheetal_Bora

I have datatable and a list of string (having years) need a select query

Hi @sheetal_Bora ,

Could you give an initial try with the below Linq :

FilterDT = DT.AsEnumerable.Where(Function(x)yourYearList.Any(Function(y)CDate(x("Event Date").ToString).Year.ToString.Equals(y))).CopyToDatatable

Here, FilterDT is a new Datatable, DT is your input Datatable, yourYearList is the list of years in String type. You could change the column name accordingly, assumed it is Event Date.

We also take note that a Direct CopyToDatatable gives an error if there are no filtered rows, hence we follow the post below :

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

Let us know if there are exceptions found and provide a Screenshot/Exception Message encountered.