• Gridview中加入求和和求平均值


    前台代码:

    View Code
    1 <asp:GridView ID="GridView1" ShowFooter="true" runat="server" AutoGenerateColumns ="false"
    2 style="border:solid 1px black" onrowdatabound="GridView1_RowDataBound">
    3 <Columns>
    4 <asp:BoundField DataField="编号" HeaderText ="编号" />
    5 <asp:BoundField DataField ="姓名" HeaderText ="姓名" />
    6 <asp:BoundField DataField ="邮政编码" HeaderText ="邮政编码" />
    7 <asp:BoundField DataField ="家庭住址" HeaderText ="家庭住址" />
    8 <asp:TemplateField HeaderText ="出生年月">
    9 <ItemTemplate>
    10 <%#Eval("出生年月","{0:yyyy-MM-dd}")%>
    11 </ItemTemplate>
    12 </asp:TemplateField>
    13 <asp:BoundField DataField ="起薪" HeaderText ="起薪" />
    14 </Columns>
    15 </asp:GridView>

    后台代码:

    View Code
    1 protected void Page_Load(object sender, EventArgs e)
    2 {
    3 if (!IsPostBack)
    4 {
    5 databind();
    6 }
    7
    8 }
    9 public void databind()
    10 {
    11 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Conn"].ToString());
    12 SqlCommand cmd = new SqlCommand();
    13 cmd.Connection = con;
    14 cmd.CommandText = "select * from T_Message";
    15 SqlDataAdapter da = new SqlDataAdapter(cmd);
    16 DataSet ds = new DataSet();
    17 da.Fill(ds);
    18 this.GridView1.DataSource = ds.Tables[0];
    19 this.GridView1.DataBind();
    20 }
    21 double sum = 0;
    22 protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    23 {
    24 foreach (TableCell item in e.Row.Cells)
    25 {
    26 item.Attributes.Add("style", "border-color:black");
    27 }
    28
    29 if (e.Row.RowType == DataControlRowType.DataRow)
    30 {
    31 sum = sum + Convert.ToInt32(e.Row.Cells[5].Text);
    32 }
    33 if (e.Row.RowType == DataControlRowType.Footer)
    34 {
    35 e.Row.Cells[4].Text = "每月支出薪水";
    36 e.Row.Cells[2].Text = "平均薪水";
    37 e.Row.Cells[3].Text = (sum / GridView1.Rows.Count).ToString();
    38 e.Row.Cells[5].Text = sum.ToString();
    39 }
    40 }
    怀揣着一点点梦想的年轻人
    相信技术和创新的力量
    喜欢快速反应的工作节奏
  • 相关阅读:
    读取Config文件工具类 PropertiesConfig.java
    MD5编码工具类 MD5Code.java
    文件上传工具类 UploadUtil.java
    删除文件夹工具类 DeleteFolder.java
    目录处理工具类 DealWithDir.java
    文件/目录部分处理工具类 DealDir.java
    目录操作工具类 CopyDir.java
    功能更强大的格式化工具类 FormatUtils.java
    日期转换工具类 CommUtil.java
    MVC学习笔记1-MVC家族间的区别
  • 原文地址:https://www.cnblogs.com/hfliyi/p/1982751.html
Copyright © 2020-2023  润新知