DataTabe 使用技巧

1.求某一列的和

 dr["Price"] = DT.Compute(" Sum(Price)","true");

dr["Price"] = DT.Compute(" Sum(Price)","mark=1");

2.求平均值

 dr["Price"] = DT.Compute(" Aver(Price)","true");

3.求记录数

dr["Price"] = DT.Compute(" Count(*)","mark=1");

 

4.排序    对DataTable的查询结果进行排序

DataRow[] dt=DT.Select(" 1=1","SortIndex ASC");