·您现在的位置：云翼网络 >> 文章中心 >> 网站建设 >> 网站建设开发 >> ASP.NET网站开发 >> ASP.NET -- repeater控件的使用

ASP.NET -- repeater控件的使用

作者：佚名 ASP.NET网站开发编辑：admin 更新时间：2022-07-23

asp.net -- repeater控件的使用

转载自网络-原网址【http://blog.csdn.net/haitaodoit/article/details/7021214】

repeater绑定数据：

PRotected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) BindStudent(); }

private void BindStudent() { string str = ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString; using (SqlConnection sqlCnn = new SqlConnection(str)) { using (SqlDataAdapter da = new SqlDataAdapter("select * from student", sqlCnn)) { DataSet ds = new DataSet(); da.Fill(ds); this.Repeater1.DataSource = ds; this.Repeater1.DataBind(); } } }

删除数据：

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Delete") { string str = ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString; using (SqlConnection sqlCnn = new SqlConnection(str)) { using (SqlCommand sqlCmm = sqlCnn.CreateCommand()) { sqlCnn.Open(); sqlCmm.CommandText = "delete from student where sid=" + e.CommandArgument.ToString(); sqlCmm.ExecuteNonQuery(); } } this.BindStudent(); } else if (e.CommandName == "Edit") { Server.Transfer("Edit.aspx?sid=" + e.CommandArgument.ToString()); } }

前台：

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<asp:Repeater ID="Repeater1" runat="server" onitemcommand="Repeater1_ItemCommand"> <HeaderTemplate><table> <tr><td style="width:100px">编号</td><td style="width:100px">姓名</td> <td style="width:100px">图片</td><td> </td><td> </td></tr> </HeaderTemplate> <ItemTemplate> <tr> <td><%# Eval("sid") %></td><td><%# Eval("sname") %></td> <td><img width="60px" height="60px" src='<%# "images/" + Eval("photo") %>' /></td> <td><asp:LinkButton ID="btnDelete" runat="server" Text="删除" CommandName='Delete' CommandArgument='<%# Eval("sid") %>'></asp:LinkButton></td> <td><asp:LinkButton ID="btnEdit" runat="server" Text="编辑" CommandName='Edit' CommandArgument='<%# Eval("sid") %>'></asp:LinkButton></td> </tr> </ItemTemplate> <AlternatingItemTemplate> <tr style=" <td><%# Eval("sid") %></td><td><%# Eval("sname") %></td> <td><img width="60px" height="60px" src='<%# "images/" + Eval("photo") %>' /></td> <td><asp:LinkButton ID="btnDelete" runat="server" Text="删除" CommandName='Delete' CommandArgument='<%# Eval("sid") %>'></asp:LinkButton></td> <td><asp:LinkButton ID="btnEdit" runat="server" Text="编辑" CommandName='Edit' CommandArgument='<%# Eval("sid") %>'></asp:LinkButton></td> </tr> </AlternatingItemTemplate> <SeparatorTemplate> <tr><td colspan="5"><hr /></td></tr> </SeparatorTemplate> <FooterTemplate></table></FooterTemplate> </asp:Repeater>

</div> </form></body></html>

启用，禁用：

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e) { //string status = e.CommandName; if ((e.CommandName == "true")||(e.CommandName == "false")) { string str = ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString; using (SqlConnection sqlCnn = new SqlConnection(str)) { using (SqlCommand sqlCmm = sqlCnn.CreateCommand()) { sqlCnn.Open(); sqlCmm.CommandText = "update student setstatus=@statuswhere sid=" + e.CommandArgument.ToString(); sqlCmm.Parameters.AddWithValue("@status",e.CommandName); sqlCmm.ExecuteNonQuery(); } } this.BindStudent(); } }

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Debug="true" Inherits="Default2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title></title></head><body> <form id="form1" runat="server"> <div> <asp:Repeater ID="Repeater1" runat="server" onitemcommand="Repeater1_ItemCommand"> <HeaderTemplate><table><tr><th>编号</th><th>姓名</th><th>状态</th><th> </th></tr></HeaderTemplate> <ItemTemplate> <tr><td><%# Eval("SID") %></td> <td><%# Eval("sname") %></td> <td><%# Convert.ToBoolean(Eval("status"))?"启用":"禁用" %></td> <td><asp:LinkButton ID="btnSetStatus" runat="server" CommandArgument='Eval("sid")' Text='<%# Convert.ToBoolean(Eval("status"))?"禁用":"启用" %>' CommandName='<%# Convert.ToBoolean(Eval("status"))?"false":"true" %>'></asp:LinkButton></td></tr> </ItemTemplate> <FooterTemplate></table></FooterTemplate> </asp:Repeater> </div> </form></body></html>

上一篇文章：常见的iis日志代码！
下一篇文章： [三卷天书]记一个asp.net生成两个日期范围内生成随机时间的方法

ASP.NET -- repeater控件的使用

asp.net -- repeater控件的使用

网站建设问答

网站建设开发

网站需求分析