GridView加入自动求和求平均值小计.doc

GridView加入自动求和求平均值小计 图：解决方案： private double sum 0;//取指定列的数据和，你要根据具体情况对待可能你要处理的是intprotected void GridView1_RowDataBound object sender, GridViewRowEventArgs e if e.Row.RowIndex 0 sum + Convert.ToDouble e.Row.Cells[6].Text ; else if e.Row.RowType DataControlRowType.Footer e.Row.Cells[5].Text 总薪水为：; e.Row.Cells[6].Text sum.ToString ; e.Row.Cells[3].Text 平均薪水为：; e.Row.Cells[4].Text int sum / GridView1.Rows.Count .ToString ; 后台全部代码：using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;using System.Drawing; public partial class Default7 : System.Web.UI.Page SqlConnection sqlcon; SqlCommand sqlcom; string strCon Data Source local ;Database 北风贸易;Uid sa;Pwd sa; protected void Page_Load object sender, EventArgs e if !IsPostBack bind ; protected void GridView1_RowEditing object sender, GridViewEditEventArgs e GridView1.EditIndex e.NewEditIndex; bind ; protected void GridView1_RowUpdating object sender, GridViewUpdateEventArgs e sqlcon new SqlConnection strCon ; string sqlstr update 飞狐工作室 set 姓名 + TextBox GridView1.Rows[e.RowIndex].Cells[1].Controls[0] .Text.ToString .Trim + ,家庭住址 + TextBox GridView1.Rows[e.RowIndex].Cells[3].Controls[0] .Text.ToString .Trim + where 身份证号码 + GridView1.DataKeys[e.RowIndex].Value.ToString + ; sqlcom new SqlCommand sqlstr, sqlcon ; sqlcon.Open ; sqlcom.ExecuteNonQuery ; sqlcon.Close ; GridView1.EditIndex -1; bind ; protected void GridView1_RowCancelingEdit object sender, GridViewCancelEditEventArgs e GridView1.EditIndex -1; bind ; public void bind string sqlstr select top 5 * from 飞狐工作室; sqlcon new SqlConnection strCon ; SqlDataAdapter myda new SqlDataAdapter sqlstr, sqlcon ; DataSet myds new DataSet ; sqlcon.Open ; myda.Fill myds, 飞狐工作室 ; GridView1.DataSource myd