LINQ query instead of Foreach

[renshatfar (sigon)]

I would like to use LINQ query instead of foreach. But the syntax is not correct.

This works:
For Each Row in Data Table
Do:
row(“ColomnName”) = double.parse(row(“ColomnName”).ToString.Replace(“,”,“.”)).ToString
End

But not this one:

dt.AsEnumerable.Where(Function(r) double.parse(r(“ColomnName”).ToString.Replace(“,”,“.”)).ToString).CopyToDatatable()

Getting this error:
If Option Strict On is used, conversion from ‘String’ to ‘Boolean’ cannot be performed.

Any suggestions.

Thanks

[ppr (Peter)]

the reason why the booelan is mandatory needed for the where lambda is explained here:

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

Options for updating a data column value are discussed here:

How to Update Data Column Values of a Data Table | Community Blog

[renshatfar (sigon)]

Thanks for your response.

I will find a solution.