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();
}
}
<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 (內建編輯模板、分頁、排序)。