How to check data table contains array of string

[EMREUYSAL]

I was using this code to filter it but sometimes there is none of string contains my dt and process stop. How can edit the code to use as a condition?

dt = dt.AsEnumerable.Where(function(r) in_ContractNo_Array.Contains(r(“Contract No Column”).ToString)).CopyToDataTable

[monsieurrahul (Rahul)]

Hi @EMREUYSAL

Check the rows in your DT using an if condition like DT.Rows.Count > 0 and inside the then part, use this condition.

[EMREUYSAL]

It is not possible in my process because without filtering there is always many row inside my dt. But already I found my solution from different topic page in forum
This is the solution I am using
hasContains = dt.AsEnumerable.Any(function(r) yourStringArray.Contains(r(“ColumnName”).ToString()))

Thanks for interesting

[monsieurrahul (Rahul)]

That’s awesome @EMREUYSAL Thanks for sharing your solution here!