in

SDT Community Server

SDT Forums, Blogs, Photos server.

Floating Heart

No description is bad.

DataTable.Compute Method

你试过循环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");
}

查找一下帮助,你会有更多发现!

 

Published Nov 27 2008, 10:23 PM by wicky
Filed under:

Comments

No Comments
Copyright SDT, 2006-2009. All rights reserved.