Using select function inside assign

[JCEY]

Hi,

How do I filter out certain keys in the data table to be used as variables

Thank you

[Yoichi]

Hi,

I recommend to use LINQ instead of DataTable.Select method.

dt = dt.AsEnumerable.Where(Function(r) not r("ColumnName").ToString="KeyForDelete").CopyToDataTable()

[HowTo] LINQ - First Start # Where Operator

This HowTo introduces how to use the Where operator. Introduction The Where operator is used for filtering. For the filtering, a condition is provided. All items matching this condition will pass the filter and will be part of the returned result. The condition has mandatory to return a boolean outcome. In other words: The result of the condition has to be True or False. Example IPO Samples Comment Values: 20,3,17,22,10,25,5 A collection of Numbers Filter Condition: x > 15 x is …

Regards,