DataTable.Compute的用法

今天做一个电子商务,其中有一个bug,买了一种商品的3件,显示结果还是1件..

我看了下实现

  DataTable table2 = access.GreatDs("select DB_Car.carid,DB_Car.pronum,DB_Car.price,DB_Car.sumprice,DB_Car.contents,DB_Shoppro.typeid,DB_Shoppro.proname,DB_Shoppro.proprice1,DB_Shoppro.propic2,DB_Shoppro.proid  from DB_Car inner join DB_Shoppro on DB_Car.productid=DB_Shoppro.proid where DB_Car.flag=false and DB_Car.temp=" + re.ReadCookie("tempno") + "").Tables[0];
this.shop = table2.Rows.Count.ToString();

 

 

我想了一下,要微创的解决这个问题,得研究一下datatable.compute的用法了.

看一下MSDN.发现示例就很容易做到聚合函数的一些功能.

 this.shop =table2.Compute("sum(pronum)", "").ToString();