sum of a column in datatable c#

Filed in Uncategorized Leave a comment

DataTable table;
table = ds.Tables["Ordertable"]
Double dblTotalCost = Convert.ToDouble(table.Compute(“SUM(SalesPriceMoney)”, “”));
if (dblTotalCost > 0)
lblTotalCost.Text = dblTotalCost.ToString(“C”);
else
lblTotalCost.Text = “$0.00″;

TOP