protected void bntQry_Click(object sender, System.EventArgs e)
{
        ........
                ........       
                 //数据显示绑定
resultGrid.DataSource = ds.Tables[0];
                                resultGrid.DataBind();
  
            }
finally{ condition = null; if(ds != null) ds.Dispose();}

private void resultGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
              {
  try
             {
            double moneys = 0, rMoneys = 0, hospitalredeem = 0, fundredeem = 0, secondredeem = 0, mzredeem = 0, cashmoneys = 0, kouchumoney = 0, jsmoney = 0;
                    
        if(e.Item.ItemType == ListItemType.AlternatingItem||e.Item.ItemType == ListItemType.Item)
                { //计算总额
                  
DataTable dt = null;
                    if (resultGrid.DataSource.GetType().Name.ToUpper() == "DATATABLE")
                        dt = (DataTable)(resultGrid.DataSource);
                    else if (resultGrid.DataSource.GetType().Name.ToUpper() == "DATAVIEW")
                        dt = ((DataView)(resultGrid.DataSource)).Table;

                    for (int i = 0; i < dt.Rows.Count; i++)
{
                        moneys += double.Parse(dt.Rows[i]["a"].ToString());
                        rMoneys += double.Parse(dt.Rows[i]["aa"].ToString());
                        hospitalredeem += double.Parse(dt.Rows[i]["aaa"].ToString());
                        fundredeem += double.Parse(dt.Rows[i]["x"].ToString());
                        secondredeem += double.Parse(dt.Rows[i]["xx"].ToString());
                        mzredeem += double.Parse(dt.Rows[i]["xxx"].ToString());
                        cashmoneys += double.Parse(dt.Rows[i]["r"].ToString());
                        kouchumoney += double.Parse(dt.Rows[i]["rr"].ToString());
                        jsmoney += double.Parse(dt.Rows[i]["rrr"].ToString());
                        
}
                }
               else if (e.Item.ItemType == ListItemType.Footer)
{
e.Item.Cells[2].Text = "合计";
e.Item.Cells[3].Text = moneys.ToString("#,##0.00");
e.Item.Cells[4].Text = rMoneys.ToString("#,##0.00");
                    e.Item.Cells[5].Text = hospitalredeem.ToString("#,##0.00");
                    e.Item.Cells[6].Text = fundredeem.ToString("#,##0.00");
                    e.Item.Cells[7].Text = secondredeem.ToString("#,##0.00");
                    e.Item.Cells[8].Text = mzredeem.ToString("#,##0.00");
                    e.Item.Cells[9].Text = cashmoneys.ToString("#,##0.00");
                    e.Item.Cells[10].Text = kouchumoney.ToString("#,##0.00");
                    e.Item.Cells[11].Text = jsmoney.ToString("#,##0.00");
}
}