Asp.net中Griview中显示合计列的通用方法

1.今天写了一个Griview中添加合计列的通用方法记录一下,有用的可以参考下。

        /// <summary>
        /// 统计datatable中某一列的
        /// </summary>
        /// <param name="dt">数据集列</param>
        /// <param name="gvTheGrid">Griview</param>
        /// <param name="e">事件列</param>
        /// <param name="sumstr">要统计的列及显示到第几行字符串的格式如("1,Qty;2,Rowcout")</param>
        public static void GridviewSum(DataTable dt, GridView gvTheGrid, GridViewRowEventArgs e, string sumstr)
        {
            string[]  sumlist = sumstr.Split(';');//将传入的字符串进行分解
            if (e.Row.RowType == DataControlRowType.Footer) // 判断当前项是否为页脚
            {
                e.Row.Cells[0].Text = "总计";
                for (int i = 0; i < sumlist.Length; i++)
                {
                    int rowindex = Int32.Parse(sumlist[i].Split(',')[0]);
                    string rowvalue = sumlist[i].Split(',')[1];
                    e.Row.Cells[rowindex].Text = dt.Compute("sum(" + rowvalue + ")", "1=1").ToString();
                }
            }
        }

posted @ 2014-01-07 13:34  li新的自己  阅读(214)  评论(0)    收藏  举报