DataGrid 生成合计行

以前总是为SQL来控制合计,今天专门写一个,方法很笨,但可行!

//页脚 DataGrid 合计 begin

            if(e.Item.ItemType==ListItemType.Footer)
            {

                for(int i = 0;i<e.Item.Cells.Count;i++)
                {
                    e.Item.Cells[i].CssClass="ttrout";

                    int intCount = 0;

                    //第一列
                    if( i == 0 ) 
                        e.Item.Cells[i].Text = "合计";
                    else if (i == (e.Item.Cells.Count-1)) //最后一列
                        e.Item.Cells[i].Text = "&nbsp;";
                    else
                    {
                        for (int j = 0;j< DataGrid1.Items.Count;j++)
                            intCount += Convert.ToInt32(DataGrid1.Items[j].Cells[i].Text);

                        e.Item.Cells[i].Text  = intCount.ToString();
                    }
                } // For end

            } //if end
            //DataGrid 合计 end