萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> ASP.NET 程式設計

ASP.NET Repeater 實作編輯、更新、刪除完整範例

Repeater 本身不支援內建編輯模板,但透過 ItemTemplate 切換顯示/編輯面板、ItemCommand 處理指令、ItemDataBound 控制可見性,即可實現類 GridView 的列內編輯功能。

資料綁定與編輯狀態控制

private int editId = -1; // 儲存正在編輯的 UserId

protected void Page_Load(object sender, EventArgs e)
{
    if (!IsPostBack) BindGrid();
}

private void BindGrid()
{
    string sql = "SELECT UserId, Name, Email, QQ, RegTime FROM [User]";
    using (var conn = new OleDbConnection(GetConnStr()))
    using (var cmd = new OleDbCommand(sql, conn))
    {
        conn.Open();
        rptUser.DataSource = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        rptUser.DataBind();
    }
}

protected void rptUser_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
    {
        var row = (System.Data.Common.DbDataRecord)e.Item.DataItem;
        int uid = Convert.ToInt32(row["UserId"]);

        var plView = (Panel)e.Item.FindControl("plView");
        var plEdit = (Panel)e.Item.FindControl("plEdit");

        bool isEditing = (uid == editId);
        plView.Visible = !isEditing;
        plEdit.Visible = isEditing;

        if (isEditing)
        {
            ((TextBox)plEdit.FindControl("txtName")).Text = row["Name"].ToString();
            ((TextBox)plEdit.FindControl("txtEmail")).Text = row["Email"].ToString();
            ((TextBox)plEdit.FindControl("txtQQ")).Text = row["QQ"].ToString();
        }
    }
}

命令處理

protected void rptUser_ItemCommand(object source, RepeaterCommandEventArgs e)
{
    int uid = Convert.ToInt32(e.CommandArgument);

    switch (e.CommandName)
    {
        case "Edit":
            editId = uid;
            break;
        case "Cancel":
            editId = -1;
            break;
        case "Update":
            var item = rptUser.Items[e.Item.ItemIndex];
            string name = ((TextBox)item.FindControl("txtName")).Text.Trim();
            string email = ((TextBox)item.FindControl("txtEmail")).Text.Trim();
            string qq = ((TextBox)item.FindControl("txtQQ")).Text.Trim();

            ExecuteNonQuery(
                "UPDATE [User] SET Name=?, Email=?, QQ=? WHERE UserId=?",
                name, email, qq, uid);
            editId = -1;
            break;
        case "Delete":
            ExecuteNonQuery("DELETE FROM [User] WHERE UserId=?", uid);
            break;
    }
    BindGrid();
}

private void ExecuteNonQuery(string sql, params object[] pars)
{
    using (var conn = new OleDbConnection(GetConnStr()))
    using (var cmd = new OleDbCommand(sql, conn))
    {
        for (int i = 0; i < pars.Length; i++)
            cmd.Parameters.AddWithValue($"p{i}", pars[i]);
        conn.Open();
        cmd.ExecuteNonQuery();
    }
}

前端模板 (重點:CommandName + CommandArgument)

<asp:Repeater ID="rptUser" runat="server" 
    OnItemCommand="rptUser_ItemCommand" OnItemDataBound="rptUser_ItemDataBound">
    <HeaderTemplate>
        <table class="grid"><thead><tr>
            <th>ID</th><th>姓名</th><th>Email</th><th>QQ</th><th>註冊時間</th><th>操作</th>
        </tr></thead><tbody>
    </HeaderTemplate>
    <ItemTemplate>
        <tr>
            <td><%# Eval("UserId") %></td>
            <td><%# Eval("Name") %></td>
            <td><%# Eval("Email") %></td>
            <td><%# Eval("QQ") %></td>
            <td><%# Eval("RegTime") %></td>
            <td>
                <asp:Panel ID="plView" runat="server">
                    <asp:LinkButton CommandName="Edit" CommandArgument='<%# Eval("UserId") %>' Text="編輯" /> |
                    <asp:LinkButton CommandName="Delete" CommandArgument='<%# Eval("UserId") %>' 
                        Text="刪除" OnClientClick="return confirm('確定刪除?')" />
                </asp:Panel>
                <asp:Panel ID="plEdit" runat="server" Visible="false">
                    <asp:TextBox ID="txtName" runat="server" Width="80" />
                    <asp:TextBox ID="txtEmail" runat="server" Width="120" />
                    <asp:TextBox ID="txtQQ" runat="server" Width="80" />
                    <asp:LinkButton CommandName="Update" CommandArgument='<%# Eval("UserId") %>' Text="更新" /> |
                    <asp:LinkButton CommandName="Cancel" Text="取消" />
                </asp:Panel>
            </td>
        </tr>
    </ItemTemplate>
    <FooterTemplate></tbody></table></FooterTemplate>
</asp:Repeater>

優化建議

  • 將 editId 存入 ViewState 而非欄位,確保跨 PostBack 保持。
  • 使用 ObjectDataSource 或 EntityDataSource 簡化資料存取程式碼。
  • 大量資料時建議改用 GridView 或 ListView (內建編輯模板、分頁、排序)。
copyright © 萬盛學電腦網 all rights reserved