asp.netÖÐ Ôõô±éÀúdataset ²¢°Ñ²éѯ³ö²ÅÖµÀÛ¼Ó

sqlÓï¾ä select  DPAvgPoint from cardp where DPAvgPoint >3
Êý¾Ý¿âÖÐÀàÐÍ DPAvgPoint Ϊ  decimal(18, 2)
  protected int customerTotal = 0;
  DataSet dsCustomer = Car_DPService.GetDPTotalData(1);
        DataTable dt = dsCustomer.Tables[0];
        foreach (DataRow dr in dt.Rows)
        {
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                customerTotal = int.Parse(dt.ToString());
            }
        }

ÏëÒª²éѯ Êý¾Ý±íÖÐ dpavgpoint ´óÓÚÈýµÄÖµ ²¢ÀÛ¼Ó ¸ø ±äÁ¿ customerTotal 
ÇëÎÊÔõôд лл£¡

---

?

---

ûÈËÂð£¿

---

Ö±½Ó¶Á³öÀ´´óÓÚÈýµÄÖµÔÙÀÛ¼Ó DataRowView view=ds.Tables[0].DefaultView

---

DataTable table = new DataTable();
....
            table.Compute("sum(dpavgpoint)", "dpavgpoint > 3");

---

foreach (DataRow dr in dt.Rows)
        {
         
                customerTotal +=dr["DPAvgPoint "]
         
        }

---

foreach (DataR