要计算DataTable中列的总和,请使用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();



