DataGrid脚眉显示合计

 

创建一个全局变量  

Public double Sumdb;

 

private void DataGrid1_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

         {            

              ListItemType lit=e.Item.ItemType;

              if(lit==ListItemType.Footer)

              {

             

                   TableCell tc1=e.Item.Cells[3];

                   TableCell tc2=e.Item.Cells[4];

                   TableCell tc3=e.Item.Cells[5];

                   TableCell tc4=e.Item.Cells[6];

             

                   Label L_xj=new Label();

                   L_xj.ID="lb_xj";

                   L_xj.Width=30;

                   L_xj.Text="合计";

                   tc1.Controls.Add(L_xj);

 

                   Label L_SumData=new Label();

                   L_SumData.ID="L_SumData";

                   L_SumData.Width=30;

                   L_SumData.Text=SumData();

                   tc2.Controls.Add(L_SumData);

                  

Label L_zj=new Label();

                   L_zj.ID="lb_zj";

                   L_zj.Width=30;

                   L_zj.Text="总合计";

                   tc1.Controls.Add(L_zj);

 

                   Label L_SumPage = new Label();

                   L_SumPage.ID=”l_sumPage”;

                   L_SumPage.Width=30;

                   L_SumPage.Text = Sumdb.ToString();

                   tc4.Controls.Add(L_SumPage);

              }

         }

private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)

         {

              if(e.Item.ItemType==ListItemType.AlternatingItem || e.Item.ItemType==ListItemType.Item)

              {

                   if( Convert.ToString( ((DataRowView)e.Item.DataItem)["M_sum"]) != string.Empty)

                   {

                       dataSum += Convert.ToDouble(((DataRowView)e.Item.DataItem)["M_sum"]);

                   }

              }

         }

//M_sum   为合计的字段名，绑定在DataGrid 的！