<form id="hz9zz"></form>
    • <form id="hz9zz"></form>
    

      

      <nobr id="hz9zz"></nobr>
      <form id="hz9zz"></form>
      3.   
          
      明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！
                   
        
                           
        
                        		  
        
                 
              
                
      datagrid編輯、更改、刪除、翻頁例子
                
                  發表時間：2024-02-02             來源：明輝站整理相關軟件相關文章人氣：          
              
      [摘要]現在數據庫中建立test表，字段分別為ID、Code、Name；數據庫的鏈接這里就不具體寫了，數據庫的鏈接和操作請求我寫在了AreaInfo.cs中，代碼中會用到，這里聲明一下<%@ Page language="c#" Codebehind="Update.a...
       現在數據庫中建立test表，字段分別為ID、Code、Name；
      數據庫的鏈接這里就不具體寫了，數據庫的鏈接和操作請求我寫在了AreaInfo.cs中，代碼中會用到，這里聲明一下
      <%@ Page language="c#" Codebehind="Update.aspx.cs" AutoEventWireup="false" Inherits="Client.Page.AreaInfo.Update" %>
      <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
      <HTML>
       <HEAD>
        <title>test</title>
        <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
        <meta name="CODE_LANGUAGE" Content="C#">
        <meta name="vs_defaultClientScript" content="JavaScript">
        <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
       </HEAD>
       <body MS_POSITIONING="GridLayout" bgcolor="ivory">
        <font face="arial" size="3"></font><FONT style="BACKGROUND-COLOR: #ffffff" face="Arial">
        </FONT>
        <br>
        <form runat="server" ID="Form1">
         <TABLE id="Table1" cellSpacing="0" bgcolor="#6699cc" cellPadding="1" width="300" border="1">
          <TR>
           <TD><b>test</b>
           </TD>
          </TR>
           <TD>
            <asp:DataGrid id="DG1" runat="server" BorderColor="green" Width="640" PageSize="5" AllowPaging="true"
             OnPageIndexChanged="Page_Grid" BorderWidth="1" CellPadding="3" AutoGenerateColumns="false"
             ShowHeader="true" Visible="true" OnEditCommand="People_Edit" OnCancelCommand="People_Cancel"
             OnUpdateCommand="People_Update" OnDeleteCommand="People_Delete">
             <HeaderStyle BorderColor="White" BackColor="black" ForeColor="White" Font-Bold="True" Font-Name="Arial"
              Font-Size="9" HorizontalAlign="Center" />
             <ItemStyle BorderColor="" BackColor="#FFFFF0" ForeColor="Black" Font-Name="Arial" Font-Size="8"
              Font-Bold="False" HorizontalAlign="Center" />
             <EditItemStyle BorderColor="" BackColor="#FFFFF0" ForeColor="Black" Font-Name="Arial" Font-Size="7"
              Font-Bold="False" HorizontalAlign="Center" />
             <PagerStyle Mode="NumericPages" Font-Size="8" />
             <Columns>
              <asp:BoundColumn HeaderText="ID" ReadOnly="true" DataField="ID" />
              <asp:TemplateColumn>
               <HeaderTemplate>
                <b>代碼</b>
               </HeaderTemplate>
               <ItemTemplate>
                <asp:Label Text='<%# DataBinder.Eval(Container.DataItem, "Code").ToString().Trim() %>' runat="server" ID="Label1" NAME="Label1"/>
               </ItemTemplate>
               <EditItemTemplate>
                <asp:TextBox id="Code" Text='<%# DataBinder.Eval(Container.DataItem, "Code").ToString().Trim() %>' runat="server" Width="100%"/>
               </EditItemTemplate>
              </asp:TemplateColumn>
              <asp:TemplateColumn>
               <HeaderTemplate>
                <b>名稱</b>
               </HeaderTemplate>
               <ItemTemplate>
                <asp:Label Width="200" Text='<%# DataBinder.Eval(Container.DataItem, "Name").ToString().Trim() %>' runat="server" ID="Label2" NAME="Label2"/>
               </ItemTemplate>
               <EditItemTemplate>
                <asp:TextBox id="Name" Text='<%# DataBinder.Eval(Container.DataItem, "Name").ToString().Trim() %>' runat="server"/>
               </EditItemTemplate>
              </asp:TemplateColumn>
              <asp:EditCommandColumn ButtonType="PushButton" CancelText="取消" EditText="修改" UpdateText="更新" />
              <asp:ButtonColumn Text="刪除" CommandName="Delete" ButtonType="PushButton"></asp:ButtonColumn>
             </Columns>
            </asp:DataGrid></TD>
          </TR>
         </TABLE>
        </form>
       </body>
      </HTML>
      Update.aspx.cs
      using System;
      using System.Collections;
      using System.ComponentModel;
      using System.Data;
      using System.Drawing;
      using System.Web;
      using System.Web.SessionState;
      using System.Web.UI;
      using System.Web.UI.WebControls;
      using System.Web.UI.HtmlControls;
      namespace Client.Page.AreaInfo
      {
       /// <summary>
       /// Update 的摘要說明。
       /// </summary>
       public class Update : System.Web.UI.Page
       {
        protected System.Web.UI.WebControls.DataGrid DG1;
        protected Classes.AreaInfo myClass=new Client.Classes.AreaInfo();
        private void Page_Load(object sender, System.EventArgs e)
        {
         if(!this.IsPostBack)
         {
          this.DG1.DataSource=myClass.bindGrid();
          this.DG1.DataBind();
         }
         // 在此處放置用戶代碼以初始化頁面
        }
        public void Page_Grid(Object sender, DataGridPageChangedEventArgs e) 
        {
         DG1.CurrentPageIndex = e.NewPageIndex;
         DG1.DataSource =myClass.bindGrid();
         DG1.DataBind();
        }
        public void DG1_Edit(Object sender, DataGridCommandEventArgs e) 
        {
         DG1.EditItemIndex = e.Item.ItemIndex;
         DG1.DataSource =myClass.bindGrid();
         DG1.DataBind();
        }
        public void DG1_Cancel(Object sender, DataGridCommandEventArgs e) 
        {   
         DG1.EditItemIndex = -1;
         DG1.DataSource = myClass.bindGrid();
         DG1.DataBind();
        }
        public void DG1_Update(Object sender, DataGridCommandEventArgs e) 
        {
         string code = ((TextBox)e.Item.Cells[1].Controls[1]).Text;
         string name = ((TextBox)e.Item.Cells[2].Controls[1]).Text;
         int id=int.Parse(e.Item.Cells[0].Text);
         myClass.upDateArea(id,code,name);
         DG1.EditItemIndex = -1;
         DG1.DataSource = myClass.bindGrid();
         DG1.DataBind();
         
        }
        public void DG1_Delete(Object sender, DataGridCommandEventArgs e) 
        {
         int id=int.Parse(e.Item.Cells[0].Text);
         myClass.deleteArea(id);
         this.DG1.DataSource=myClass.bindGrid();
         this.DG1.DataBind();
        }

        #region Web 窗體設計器生成的代碼
        override protected void OnInit(EventArgs e)
        {
         //
         // CODEGEN: 該調用是 ASP.NET Web 窗體設計器所必需的。
         //
         InitializeComponent();
         base.OnInit(e);
        }
        
        /// <summary>
        /// 設計器支持所需的方法 - 不要使用代碼編輯器修改
        /// 此方法的內容。
        /// </summary>
        private void InitializeComponent()
        {    
         this.Load += new System.EventHandler(this.Page_Load);
        }
        #endregion
       }
      }




              
              
                 
              
                                            
                              		       
                          
                           		  
        
                            
      
日韩精品一区二区三区高清