给一个Table添加合计行

来源:互联网 发布:淘宝买家信用积分等级 编辑:程序博客网 时间:2024/06/05 09:01
public static void AppendSumaryRow(DataTable table)
{
    if (table.Rows.Count > 0)
    {
        DataRow dr = table.NewRow();
        for (int i = 0; i < table.Columns.Count; i++)
        {
            DataColumn column = table.Columns[i];
            if (SumaryTypeList.Contains(column.DataType))
            {
                dr[i] = table.Compute(String.Format("Sum({0})", column.ColumnName), "");
            }
        }

        table.Rows.Add(dr);
    }
}


 
原创粉丝点击