要计算数据表中一列的总和,请使用DataTable.Compute方法.
链接的MSDN文章中的用法示例:
DataTable table = dataSet.Tables["YourTableName"];
// Declare an object variable.
object sumObject;
sumObject = table.Compute("Sum(Amount)", string.Empty);
在总额标签中显示结果,如下所示:
lblTotalAmount.Text = sumObject.ToString();