GridView中列中数据的汇总

        

 在部分项目中我们用到GridView控件会涉及到列中数据统计，下面针对GridView中列的汇总做以说明；

1.       开始我们以northwind数据库为例从数据库中读取数据到页面

   String connString = "server=.;user=sa;pwd=;database=northwind";

    //汇总价格

   double totalPrice = 0;

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {

            using (SqlConnection sqlCon = new SqlConnection(connString))

            {

                String sql = "select top 10 productid,productname,unitprice from products";

                using (SqlCommand cmd = new SqlCommand(sql, sqlCon))

                {

                    sqlCon.Open();

                    SqlDataReader rs = cmd.ExecuteReader();

                    gvProducts.DataSource = rs;

                    gvProducts.DataBind();

                }

            }

        }

}

 

2.       接下来书写OnRowDataBound 事件（在对行进行了数据绑定后激发）

        if (e.Row.RowType == DataControlRowType.DataRow)

        {

            double price = double.Parse(e.Row.Cells[e.Row.Cells.Count - 1].Text);

            totalPrice += price;

        }

3.       DataBound事件(控件被数据绑定后事件)

gvProducts.FooterRow.Cells[gvProducts.FooterRow.Cells.Count - 1].Text = totalPrice.ToString();