1:首先给gridview添加ShowFooter="true" 属性
2:在RowDataBound 实现数据合计
protected override void OnMainGridRowDataBound(object sender, GridViewRowEventArgs e) {
base.OnMainGridRowDataBound(sender, e);
if (e.Row.RowType == DataControlRowType.DataRow)
{
clickcount += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "PVCount"));
ipconut += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "IPCount"));
amoutcount += Convert.ToDecimal(DataBinder.Eval(e.Row.DataItem, "AmountQR"));
talkcount += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "talkCount"));
ordercount += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "CountQR"));
shouamount += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "AmountQS"));
shoucount += Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "CountQS"));
}
else if (e.Row.RowType == DataControlRowType.Footer)
{
e.Row.Cells[0].Text = "合计";
e.Row.Cells[4].Text = clickcount.ToString();
e.Row.Cells[5].Text = ipconut.ToString();
e.Row.Cells[6].Text = amoutcount.ToString("0.00");
e.Row.Cells[7].Text = talkcount.ToString();
e.Row.Cells[8].Text = ordercount.ToString();
e.Row.Cells[9].Text = shouamount.ToString();
e.Row.Cells[10].Text = shoucount.ToString();
e.Row.Font.Bold = true;
}
}