repeater的编辑,更新,删除

来源：互联网发布：航道大数据分析方案编辑：程序博客网时间：2024/05/01 21:07

前台：

<asp:Repeater id="Repeater1" runat="server"OnItemDataBound="Repeater1_ItemDataBound"OnItemCommand="Repeater1_ItemCommand">
<ItemTemplate>
<asp:Panel ID="plItem"runat="server">
<tr>
<td><%#DataBinder.eval_r(Container.DataItem,"userid")%></td>
<td><%#DataBinder.eval_r(Container.DataItem,"username")%></td>
<td>
<asp:LinkButton runat="server"ID="lbtEdit" CommandArgument='<%#DataBinder.eval_r(Container.DataItem,"userid")%>'
CommandName="Edit"Text="编辑"></asp:LinkButton>   
<asp:LinkButton runat="server"ID="lbtDelete" CommandArgument='<%#DataBinder.eval_r(Container.DataItem,"userid")%>'
CommandName="Delete"Text="删除"></asp:LinkButton>
</td>
</tr>
</asp:Panel>
<asp:Panel ID="plEdit"runat="server">
<tr>
<td><%#DataBinder.eval_r(Container.DataItem,"userid")%></td>
<td><asp:TextBoxID="UserName" Text='<%#DataBinder.eval_r(Container.DataItem,"username") %>'runat="server"></asp:TextBox></td>
<td>
<asp:LinkButton runat="server"ID="lbtUpdate" CommandArgument='<%#DataBinder.eval_r(Container.DataItem,"userid")%>'
CommandName="Update"Text="更新"></asp:LinkButton>   
<asp:LinkButton runat="server"ID="lbtCancel" CommandArgument='<%#DataBinder.eval_r(Container.DataItem,"userid")%>'
CommandName="Cancel"Text="取消"></asp:LinkButton>
</td>
</tr>
</asp:Panel>
</ItemTemplate>
</asp:Repeater>

后台：

public int id = 0;
protected void Page_Load(object sender,EventArgs e)
{
if(!IsPostBack)
{
BindGrid();
}
}
private void BindGrid()
{
string sql= "select top 5 * from [user] order by userid desc";
OleDbConnection conn = newOleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +Server.MapPath("test.mdb"));
OleDbDataAdapter da = new OleDbDataAdapter(sql, conn);
DataSet ds= new DataSet();
da.Fill(ds, "temp");
Repeater1.DataSource = ds.Tables["temp"];
Repeater1.DataBind();
}
protected void Repeater1_ItemDataBound(objectsender, System.Web.UI.WebControls.RepeaterItemEventArgse)
{
if(e.Item.ItemType == ListItemType.Item || e.Item.ItemType ==ListItemType.AlternatingItem)
{
DataRowView rowv =(DataRowView)e.Item.DataItem;
string userid =rowv["userid"].ToString();
if (userid !=id.ToString())
{
((Panel)e.Item.FindControl("plItem")).Visible =true;
((Panel)e.Item.FindControl("plEdit")).Visible =false;
}
else
{
((Panel)e.Item.FindControl("plItem")).Visible =false;
((Panel)e.Item.FindControl("plEdit")).Visible =true;
}
}
}
protected void Repeater1_ItemCommand(objectsource, RepeaterCommandEventArgs e)
{
if(e.CommandName == "Edit")
{
id =int.Parse(e.CommandArgument.ToString());
}
else if(e.CommandName == "Cancel")
{
id = -1;
}
else if(e.CommandName == "Update")
{
//Update.
string username =((TextBox)this.Repeater1.Items[e.Item.ItemIndex].FindControl("UserName")).Text.Trim();
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(),"key", "alert('更新ID：" + e.CommandArgument + "；页面值：姓名=" + username +"');", true);
}
else if(e.CommandName == "Delete")
{
//Delete.
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(),"key", "alert('删除ID：" + e.CommandArgument + "');",true);
}
BindGrid();
}

0 0