DataGrid脚眉显示合计-ASP教程,数据库相关

创建一个全局变量  

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 的！