本文實(shí)例講述了asp.net中GridView編輯,更新,合計(jì)用法。分享給大家供大家參考，具體如下：

前臺(tái)代碼:

<asp:GridView ID="tabgv" runat="server" DataKeyNames="ysId" ShowFooter="True" OnRowDataBound="GridView1_RowDataBound"

  OnRowCreated="GridView1_RowCreated" AutoGenerateColumns="False" Width="99%" CssClass="gridview"

  EnableModelValidation="True" OnRowCancelingEdit="tabgv_RowCancelingEdit" OnRowEditing="tabgv_RowEditing"

  OnRowUpdating="tabgv_RowUpdating">

  <RowStyle BorderColor="Black" BorderStyle="None" />

  <Columns>

    <asp:BoundField DataField="gsHkrno" HeaderText="項(xiàng)目編號(hào)" ReadOnly="True">

      <ItemStyle Width="5%" HorizontalAlign="Center" />

      <FooterStyle BorderWidth="0px" />

    </asp:BoundField>

    <asp:TemplateField HeaderText="項(xiàng)目名稱">

      <ItemTemplate>

        <asp:HyperLink ID="Hyp_gsName" runat="server" ForeColor="Blue" Text='<%# Bind("gsName") %>'></asp:HyperLink>

      </ItemTemplate>

      <ItemStyle Width="25%" HorizontalAlign="left" />

      <FooterTemplate>

        <asp:Label ID="Label4" runat="server" Font-Bold="True" Text="合 計(jì)：" Width="61px"></asp:Label>

      </FooterTemplate>

      <FooterStyle BorderColor="Black" BorderWidth="0px" HorizontalAlign="Right" />

    </asp:TemplateField>

    <asp:TemplateField HeaderText="概算金額">

      <ItemTemplate>

        <asp:Label ID="labgsMoney" runat="server" Text='<%#Bind("gsMoney", "{0:N2}") %>'></asp:Label>

      </ItemTemplate>

      <ItemStyle Width="8%" HorizontalAlign="right" />

      <FooterTemplate>

        <asp:Label ID="labtotalgsMoney" runat="server" ForeColor="Red"></asp:Label>

      </FooterTemplate>

      <FooterStyle BorderColor="Black" HorizontalAlign="Right" />

    </asp:TemplateField>

    <asp:TemplateField HeaderText="開工至上年底\n累計(jì)完成概算">

      <ItemTemplate>

        <asp:Label ID="labkgzsndwcGsMoney" runat="server" Text='<%# Bind("footMoney", "{0:N2}") %>'></asp:Label>

        <asp:HiddenField ID="hdnysYear" runat="server" Value='<%# Eval("ysYear") %> ' />

        <asp:HiddenField ID="hdngsId" runat="server" Value='<%# Eval("gsId") %> ' />

        <asp:HiddenField ID="hdngsHkrno" runat="server" Value='<%# Eval("gsHkrno") %> ' />

        <asp:HiddenField ID="hdnChildFlag" runat="server" Value='<%# Eval("childFlag") %> ' />

      </ItemTemplate>

      <ItemStyle Width="8%" HorizontalAlign="right" />

      <FooterTemplate>

        <asp:Label ID="labtotalfootMoney" runat="server" ForeColor="Red"></asp:Label>

      </FooterTemplate>

      <FooterStyle BorderColor="Black" HorizontalAlign="Right" />

    </asp:TemplateField>

    <asp:TemplateField HeaderText="投資計(jì)劃金額">

      <ItemTemplate>

        <asp:Label ID="labtzqysMoney" runat="server" Text='<%# Bind("tzqysMoney", "{0:N2}") %>'></asp:Label>

      </ItemTemplate>

      <EditItemTemplate>

        <asp:TextBox ID="txttzqysMoney" runat="server" Text='<%# Eval("tzqysMoney") %> '

          Style="text-align: right" Width="100px"

          onKeyPress="if (event.keyCode!=46 && event.keyCode!=45 && (event.keyCode<48 || event.keyCode>57)) event.returnValue=false"></asp:TextBox>

      </EditItemTemplate>

      <ItemStyle Width="8%" HorizontalAlign="right" />

      <FooterTemplate>

        <asp:Label ID="labtotaltzqysMoney" runat="server" ForeColor="Red"></asp:Label>

      </FooterTemplate>

      <FooterStyle BorderColor="Black" HorizontalAlign="Right" />

    </asp:TemplateField>

    <asp:TemplateField>

      <ItemTemplate>

        <asp:Label ID="labtzhysMoney" runat="server" Text='<%# Bind("tzhysMoney", "{0:N2}") %>'></asp:Label>

      </ItemTemplate>

      <EditItemTemplate>

        <asp:TextBox ID="txttzhysMoney" runat="server" Text='<%# Eval("tzhysMoney") %> '

          Style="text-align: right" Width="100px"

           onKeyPress="if (event.keyCode!=46 && event.keyCode!=45 && (event.keyCode<48 || event.keyCode>57)) event.returnValue=false"></asp:TextBox>

      </EditItemTemplate>

      <ItemStyle Width="8%" HorizontalAlign="right" />

      <FooterTemplate>

        <asp:Label ID="labtotaltzhysMoney" runat="server" ForeColor="Red"></asp:Label>

      </FooterTemplate>

      <FooterStyle BorderColor="Black" HorizontalAlign="Right" />

    </asp:TemplateField>

    <asp:TemplateField HeaderText="備注">

      <ItemTemplate>

        <asp:Label ID="labtremark" runat="server" Text='<%# Eval("remark") %> '></asp:Label>

      </ItemTemplate>

      <EditItemTemplate>

        <asp:TextBox ID="txtremark" runat="server" Text='<%# Eval("remark") %> ' Width="100px"></asp:TextBox>

      </EditItemTemplate>

      <ItemStyle Width="10%" HorizontalAlign="Center" />

    </asp:TemplateField>

    <asp:TemplateField ShowHeader="False">

      <EditItemTemplate>

        <asp:LinkButton ID="LkBtnUpdate" runat="server" CausesValidation="True" CommandName="Update"

          Text="更新"></asp:LinkButton>

        <asp:LinkButton ID="LkBtnCtrl" runat="server" CausesValidation="False" CommandName="Cancel"

          Text="取消"></asp:LinkButton>

      </EditItemTemplate>

      <ItemTemplate>

        <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName='<%#Eval("childFlag").ToString()== "0" ? "":"Edit"%>'

          Text='<%#Eval("childFlag").ToString()== "0" ? "鎖定":"編輯"%>'></asp:LinkButton>

      </ItemTemplate>

      <ItemStyle Width="8%" HorizontalAlign="Center" />

    </asp:TemplateField>

  </Columns>

</asp:GridView>

注意:

1、通過設(shè)置 ReadOnly="True" 表示此列不可以編輯;

2、通過Text='<%# Bind("tzhysMoney", "{0:N2}") %>'進(jìn)行金額格式化;

3、重點(diǎn)的編輯\顯示\合計(jì)

<asp:TemplateField>

  <ItemTemplate>

    <asp:Label ID="labtzhysMoney" runat="server" Text='<%# Bind("tzhysMoney", "{0:N2}") %>'></asp:Label>

  </ItemTemplate>

  <EditItemTemplate>

    <asp:TextBox ID="txttzhysMoney" runat="server" Text='<%# Eval("tzhysMoney") %> '

      Style="text-align: right" Width="100px"

       ></asp:TextBox>

  </EditItemTemplate>

  <ItemStyle Width="8%" HorizontalAlign="right" />

  <FooterTemplate>

    <asp:Label ID="labtotaltzhysMoney" runat="server" ForeColor="Red"></asp:Label>

  </FooterTemplate>

  <FooterStyle BorderColor="Black" HorizontalAlign="Right" />

</asp:TemplateField>

后臺(tái)代碼:

行綁定時(shí)的操作:

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

    GridViewRow gr = e.Row;

    if (gr.RowType == DataControlRowType.DataRow)

    {

      HiddenField hdnysYear = (HiddenField)e.Row.FindControl("hdnysYear");

      HiddenField hdngsHkrno = (HiddenField)e.Row.FindControl("hdngsHkrno");

      HiddenField hdnChildFlag = (HiddenField)e.Row.FindControl("hdnChildFlag");

      HyperLink hy = (HyperLink)e.Row.FindControl("Hyp_gsName");

      if (hdnChildFlag.Value!="1")

      {

      //設(shè)置連接地址\參數(shù)

        hy.NavigateUrl = "ys_edit_right.aspx?gsHkrno=" + hdngsHkrno.Value + "&sysObjNo=" + sysObjNo + "&ysYear=" + hdnysYear.Value;

        hy.Font.Underline = true;

        hy.ForeColor = System.Drawing.Color.Blue;

        hy.Target = "mainFrame";

      }

      else

      {

        hy.ForeColor = System.Drawing.Color.Black;

      }

      //計(jì)算合計(jì)

      Label labgsMoney = (Label)(e.Row.FindControl("labgsMoney"));

      if (labgsMoney != null || labgsMoney.Text != "")

      {

        gsMoneytotal += Convert.ToDecimal(labgsMoney.Text);

      }

      Label labkgzsndwcGsMoney = (Label)(e.Row.FindControl("labkgzsndwcGsMoney"));

      if (labkgzsndwcGsMoney != null || labkgzsndwcGsMoney.Text != "")

      {

        footMoneytotal += Convert.ToDecimal(labkgzsndwcGsMoney.Text);

      }

      //編輯狀態(tài)時(shí),不然點(diǎn)擊編輯時(shí)會(huì)出錯(cuò),找不到控件

      if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)

      {

        TextBox txttzqysMoney = (TextBox)(e.Row.FindControl("txttzqysMoney"));

        if (txttzqysMoney != null || txttzqysMoney.Text != "")

        {

          tzqysMoneytotal += Convert.ToDecimal(txttzqysMoney.Text);

        }

        TextBox txttzhysMoney = (TextBox)(e.Row.FindControl("txttzhysMoney"));

        if (txttzhysMoney != null || txttzhysMoney.Text != "")

        {

          tzhysMoneytotal += Convert.ToDecimal(txttzhysMoney.Text);

        }

      }

      else //非編輯狀態(tài)時(shí)

      {

        Label labtzqysMoney = (Label)(e.Row.FindControl("labtzqysMoney"));

        if (labtzqysMoney != null || labtzqysMoney.Text != "")

        {

          tzqysMoneytotal += Convert.ToDecimal(labtzqysMoney.Text);

        }

        Label labtzhysMoney = (Label)(e.Row.FindControl("labtzhysMoney"));

        if (labtzhysMoney != null || labtzhysMoney.Text != "")

        {

          tzhysMoneytotal += Convert.ToDecimal(labtzhysMoney.Text);

        }

      }

    }

}

//取消編輯

protected void tabgv_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

{

    tabgv.EditIndex = -1;

    string strysYear = (Convert.ToInt32(ysYear) - 1).ToString();

    GvDataBind(gsHkrno, "0002", ysYear, "1900-01-01 00:00:00", strysYear + "-12-25 00:00:00");

}

//編輯

protected void tabgv_RowEditing(object sender, GridViewEditEventArgs e)

{

      tabgv.EditIndex = e.NewEditIndex;

      string strysYear = (Convert.ToInt32(ysYear) - 1).ToString();

      GvDataBind(gsHkrno, "0002", ysYear, "1900-01-01 00:00:00", strysYear + "-12-25 00:00:00");

}

//更新

protected void tabgv_RowUpdating(object sender, GridViewUpdateEventArgs e)

{

    string sqlstr = "update ys_ysitem_list set tzqysMoney=@tzqysMoney,tzhysMoney=@tzhysMoney,remark=@remark where ysId=@ysId";

    SqlParameter[] para ={new SqlParameter("@tzqysMoney",SqlDbType.VarChar),

    new SqlParameter("@tzhysMoney",SqlDbType.VarChar),

    new SqlParameter("@remark",SqlDbType.VarChar),

    new SqlParameter("@ysId",SqlDbType.VarChar)

    };

    para[0].Value = ((TextBox)(tabgv.Rows[e.RowIndex].FindControl("txttzqysMoney"))).Text.ToString().Trim();

    para[1].Value = ((TextBox)(tabgv.Rows[e.RowIndex].FindControl("txttzhysMoney"))).Text.ToString().Trim();

    para[2].Value = ((TextBox)(tabgv.Rows[e.RowIndex].FindControl("txtremark"))).Text.ToString().Trim();

    para[3].Value = tabgv.DataKeys[e.RowIndex].Value.ToString();

    pms.SqlHelper.ExecuteNonQuery(CommandType.Text, sqlstr, para);

    tabgv.EditIndex = -1;

    string strysYear = (Convert.ToInt32(ysYear) - 1).ToString();

    GvDataBind(gsHkrno, "0002", ysYear, "1900-01-01 00:00:00", strysYear + "-12-25 00:00:00");

}

希望本文所述對(duì)大家asp.net程序設(shè)計(jì)有所幫助。