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();
}
}
}

浙公网安备 33010602011771号