How to do sum of a column with LINQ?

c#, datatable, linq, linq-to-dataset

Solution

Your `TotalPrice` column contains decimal values, but you are trying to cast row field value to `string`. Cast to `decimal` directly instead:

var GrandTotal = dt.AsEnumerable()
                   .Sum(r => r.Field<decimal>("TotalPrice"));

Problem

``` var GrandTotal = dt.AsEnumerable().Sum(cols => Convert.ToDecimal(cols.Field<string>("TotalPrice"))); ``` is Giving Error: ``` Unable to cast object of type 'System.Decimal' to type 'System.String' ``` How can I Correct it?

Original source