How to sum DataTable column?

Hi ILkin East,

There are many ways. You can use the LINQ, it will be less code and fast execution.

If you want to sum all the rows then 
// Presumes a DataTable named "Orders" that has a column named "Total."
    DataTable myTable;
    myTable = myDataSet.Tables["Orders"];
    // Declare an object variable.
    object objSum;
    objSum = myTable.Compute("Sum(Total)");


If you want to sum based on the condition then 
// Presumes a DataTable named "Orders" that has a column named "Total."
    DataTable myTable;
    myTable = myDataSet.Tables["Orders"];
    // Declare an object variable.
    object objSum;
    objSum = myTable.Compute("Sum(Total)", "EmpID = 5");


If you want to iterate the DataTable by every row then


     DataTable dt = new DataTable();
            int sum = 0;
            foreach (DataRow dr in dt.Rows)
            {
                foreach (DataColumn dc in dt.Columns)
                {
                    sum += (int)dr[dc];
                }
            } 


If you want to do by LINQ then


If untyped (replace int with the correct data type):


 var sum = table.AsEnumerable().Sum(x=>x.Field(3));


or:


 var sum = table.AsEnumerable().Sum(x=>x.Field("SomeProperty"));


If typed:


 var sum = table.Sum(x=>x.SomeProperty);