How to sum all values in a column of data Table and how to change String to Boolean

[ppr (Peter Preuss)]

DataTable.Compute(… will return a result of DataType: Object
One of several object is to convert it into a Double as you had done

The Compute method is short and powerfull, but also very sensitive, when the values are not within the expectations (blanks, other formarts)

So a more control we can achieve e.g. with LINQ

[HowTo] LINQ - First Start # Min | Max | Sum | Average Operator

This HowTo gives an introductory overview of the aggregation Operators: Min, Max, Sum, Average Introduction The aggregation operators are used to retrieve from a collection a particular result by setting the contained items into a relationship. Overview I – Input P – Processing O – Output {2,12,-8,6,14,5} get the lowest value -8 {2,12,-8,6,14,5} get the highest value 14 {2,12,-8,6,14,5} sum up all values 31 {2,12,-8,6,14,5} get the average of all values 5.17 Constraints P…

Convert.ToBoolean, CX methods. But more important which String value should be converted?