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

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

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.

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