你试过循环datatable计算某一列的合计值么,有没试过这种方法:
1
2
3
4
5
6
7
8
9
10
11
|
</span>private void ComputeBySalesSalesID(DataSet dataSet)
{
// Presumes a DataTable named "Orders" that has a column named "Total."
DataTable table;
table = dataSet.Tables["Orders"];
// Declare an object variable.
object sumObject;
sumObject = table.Compute("Sum(Total)", "EmpID = 5");
} |
查找一下帮助,你会有更多发现!