<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" AllowPaging="true" CellPadding="5" PageSize="5"
          OnPageIndexChanging="GridView1_PageIndexChanging" OnRowDeleting="GridView1_RowDeleting" OnRowEditing="GridView1_RowEditing"
          OnRowUpdating="GridView1_RowUpdating" OnRowCancelingEdit="GridView1_RowCancelingEdit" DataKeyNames="userid">

            <Columns>
           
              <asp:BoundField DataField="userid" HeaderText="ID" ReadOnly="True" />

              <asp:BoundField DataField="username" HeaderText="UserName" />
              <asp:BoundField DataField="realname" HeaderText="RealName" />
             
              <asp:CommandField HeaderText="选择" ShowSelectButton="True" />
              <asp:CommandField HeaderText="编辑" ShowEditButton="True" />
              <asp:CommandField HeaderText="删除" ShowDeleteButton="True" />
             
            </Columns>
            <pagersettings mode="Numeric" position="Bottom"  pagebuttoncount="10"/>
            <PagerStyle BackColor="#8080FF" ForeColor="Crimson" />
            <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" CssClass="Freezing"/>
        </asp:GridView>

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        BindGrid();
    }

    //删除
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {

        string sql = "delete from [user] where userid=" + GridView1.Rows[e.RowIndex].Cells[0].Text;
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb"));
        OleDbCommand cmd = new OleDbCommand(sql, conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();

        BindGrid();

    }

    //更新
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
       
        string sql = "update [user] set username='";
        sql += ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "',realname='";
        sql += ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "' where userid=";
        sql += GridView1.Rows[e.RowIndex].Cells[0].Text;
        //sql += GridView1.DataKeys[e.RowIndex].Values.ToString();
       
        OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + Server.MapPath("test.mdb"));
        OleDbCommand cmd = new OleDbCommand(sql, conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();

        GridView1.EditIndex = -1;
        BindGrid();
    }

    //取消
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        BindGrid();
    }

演示 下载