DataTable具有很多Sql的强大功能
常规统计
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");
}
其中Compute()方法,不但可以统计,还可以根据其特性动态实现公式计算。
例如:
DataTable dt = new DataTable();
double result = dt.Compute("(88*0.2+90*0.2+((90*0.2+88*0.8)*0.6))", "");
效果等同于采用Sql计算的方法
select top 1 (88*0.2+90*0.2+((90*0.2+88*0.8)*0.6)) from Table