How to sum DataTable column?

Question

Hi, How to sum DataTable column? Thanks

Senthilkumar · Answer

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);

Ifour Hiren · Answer

DataTable table; table = dataSet.Tables["YourTableName"]; // Declare an object variable. object sumObject; sumObject = table.Compute("Sum(Amount)", ""); above code helps you to make it working.

Rajesh Kumawat · Answer

Hello, table.Columns.Add("Total", typeof (decimal)); foreach ( DataRow row in table.Rows) { decimal rowSum = 0; foreach ( DataColumn col in table.Columns) { if(!row.IsNull(col)) { string stringValue = row[col].ToString(); decimal d; if (decimal.TryParse(stringValue, out d)) rowSum += d; } } row .SetField("Total", rowSum); }

vivek godse · Answer

sethil kumar thanks for your info "thalaiva ur great".

Satyapriya Nayak · Answer

Hi Ilkin, con.Open(); string str = "select sum(amount)from order"; SqlCommand com = new SqlCommand(str, con); txtamount.Text =com.ExecuteScalar().ToString (); con.Close(); Thanks

Satyapriya Nayak · Answer

Hi Ilkin, DataTable table; table = dataSet.Tables["YourTableName"]; // Declare an object variable. object sumObject; sumObject = table.Compute("Sum(Amount)", ""); Display the result in your Total Amount Label lblTotalAmount.Text = sumObject.ToString(); Thanks

How to sum DataTable column?

Answers (6)