濮阳杆衣贸易有限公司

主頁 > 知識庫 > asp.net中GridView編輯,更新,合計(jì)用法示例

asp.net中GridView編輯,更新,合計(jì)用法示例
熱門標(biāo)簽：外呼電話機(jī)器人成本 臨沂智能電話機(jī)器人加盟 400電話辦理怎么樣 網(wǎng)絡(luò)電話外呼系統(tǒng)上海 百應(yīng)電話機(jī)器人外呼系統(tǒng) 西寧呼叫中心外呼系統(tǒng)線路商 地圖標(biāo)注軟件免費(fèi)下載 聯(lián)通官網(wǎng)400電話辦理 蘇州如何辦理400電話

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

前臺代碼:

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)目編號" 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.keyCode48 || 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.keyCode48 || 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>

后臺代碼:

行綁定時的操作:

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)時,不然點(diǎn)擊編輯時會出錯,找不到控件
      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)時
      {
        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");
}

更多關(guān)于asp.net相關(guān)內(nèi)容感興趣的讀者可查看本站專題：《asp.net操作json技巧總結(jié)》、《asp.net字符串操作技巧匯總》、《asp.net操作XML技巧總結(jié)》、《asp.net文件操作技巧匯總》、《asp.net ajax技巧總結(jié)專題》及《asp.net緩存操作技巧總結(jié)》。

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

您可能感興趣的文章:
  • asp.net實(shí)現(xiàn)固定GridView標(biāo)題欄的方法(凍結(jié)列功能)
  • asp.net GridView控件中模板列CheckBox全選、反選、取消
  • asp.net下gridview 批量刪除的實(shí)現(xiàn)方法
  • Asp.net GridView使用大全(分頁實(shí)現(xiàn))
  • asp.net gridview代碼綁定
  • asp.net GridView 刪除時彈出確認(rèn)對話框(包括內(nèi)容提示)
  • asp.net Gridview里添加匯總行
  • asp.net中讓Repeater和GridView支持DataPager分頁
  • ASP.NET Gridview與checkbox全選、全不選實(shí)現(xiàn)代碼
  • asp.net GridView 中增加記錄的方法
  • asp.net GridView導(dǎo)出到Excel代碼
  • asp.net Checbox在GridView中的應(yīng)用實(shí)例分析

標(biāo)簽：海西 臨夏 慶陽 中衛(wèi) 清遠(yuǎn) 甘肅 聊城

巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《asp.net中GridView編輯,更新,合計(jì)用法示例》，本文關(guān)鍵詞  asp.net,中,GridView,編輯,更新,；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題，煩請?zhí)峁┫嚓P(guān)信息告之我們，我們將及時溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《asp.net中GridView編輯,更新,合計(jì)用法示例》相關(guān)的同類信息！
  • 本頁收集關(guān)于asp.net中GridView編輯,更新,合計(jì)用法示例的相關(guān)信息資訊供網(wǎng)民參考！
    • 推薦文章
    察哈| 永仁县| 三明市| 灵台县| 广西| 安塞县| 墨竹工卡县| 麦盖提县| 图木舒克市| 通辽市| 区。| 永修县| 九龙城区| 乐清市| 香格里拉县| 冷水江市| 常熟市| 景泰县| 永兴县| 永平县| 永丰县| 株洲县| 类乌齐县| 哈巴河县| 紫阳县| 临夏市| 汽车| 兰州市| 南投县| 屏东县| 纳雍县| 建始县| 闸北区| 广汉市| 响水县| 大英县| 承德市| 古丈县| 马龙县| 巴青县| 西贡区|