asp.net中GridView编辑,更新,合计用法示例

本文实例讲述了asp.net中GridView编辑,更新,合计用法。，具体如下：

前台代码:

<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="项目编号" ReadOnly="True">      <ItemStyle Width="5%" HorizontalAlign="Center" />      <FooterStyle BorderWidth="0px" />    </asp:BoundField>    <asp:TemplateField HeaderText="项目名称">      <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="合 计：" 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累计完成概算">      <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="投资计划金额">      <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>