提供了编程的基础技术教程

zl程序教程

您现在的位置是：首页 >  后端

当前栏目

ASP.NET中repeater控件用法实例

Net实例ASP 用法 控件 Repeater
2023-06-13 09:15:38 时间

本文实例讲述了ASP.NET中repeater控件用法。分享给大家供大家参考。具体实现方法如下：

repeater绑定数据：

复制代码代码如下:
protectedvoidPage_Load(objectsender,EventArgse)
{
       if(!IsPostBack)
           BindStudent();
}

privatevoidBindStudent()
{
       stringstr=ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString;
       using(SqlConnectionsqlCnn=newSqlConnection(str))
       {
           using(SqlDataAdapterda=newSqlDataAdapter("select*fromstudent",sqlCnn))
           {
               DataSetds=newDataSet();
               da.Fill(ds);
               this.Repeater1.DataSource=ds;
               this.Repeater1.DataBind();
           }
       }
}

删除数据：

复制代码代码如下:
protectedvoidRepeater1_ItemCommand(objectsource,RepeaterCommandEventArgse)
{
       if(e.CommandName=="Delete")
       {
           stringstr=ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString;
           using(SqlConnectionsqlCnn=newSqlConnection(str))
           {
               using(SqlCommandsqlCmm=sqlCnn.CreateCommand())
               {
                   sqlCnn.Open();
                   sqlCmm.CommandText="deletefromstudentwheresid="
                       +e.CommandArgument.ToString();
                   sqlCmm.ExecuteNonQuery();
               }
           }
           this.BindStudent();
       }
       elseif(e.CommandName=="Edit")
       {
           Server.Transfer("Edit.aspx?sid="+e.CommandArgument.ToString());
       }
}

前台：

复制代码代码如下:<%@PageLanguage="C#"AutoEventWireup="true"CodeFile="Default.aspx.cs"Inherits="_Default"%>

<!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
   <title></title>
</head>
<body>
   <formid="form1"runat="server">
   <%--<asp:RepeaterID="Repeater1"runat="server">
   <HeaderTemplate>
   <hr/>
   </HeaderTemplate>
   <ItemTemplate><div>
   <asp:LabelID="lblSid"runat="server"Text="<%#Eval("sid")%>"></asp:Label>
   <asp:LabelID="lblSname"runat="server"Text="<%#Eval("sname")%>"></asp:Label>
   <asp:ImageID="imgPhoto"runat="server"ImageUrl="<%#Eval("photo")%>"/></div>
   </ItemTemplate>
   <SeparatorTemplate>
   <hr/>
   </SeparatorTemplate>
   <AlternatingItemTemplate>
   <divstyle="
   <asp:LabelID="lblSid"runat="server"Text="<%#Eval("sid")%>"></asp:Label>
   <asp:LabelID="lblSname"runat="server"Text="<%#Eval("sname")%>"></asp:Label>
   <asp:ImageID="imgPhoto"runat="server"ImageUrl="<%#Eval("photo")%>"/></div>
   </AlternatingItemTemplate>
   <FooterTemplate><hr/></FooterTemplate>
   </asp:Repeater>--%>
   <div>

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

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

启用，禁用：

复制代码代码如下:protectedvoidRepeater1_ItemCommand(objectsource,RepeaterCommandEventArgse)
{
       //stringstatus=e.CommandName;
       if((e.CommandName=="true")||(e.CommandName=="false"))
       {
           stringstr=ConfigurationManager.ConnectionStrings["stucnn"].ConnectionString;
           using(SqlConnectionsqlCnn=newSqlConnection(str))
           {
               using(SqlCommandsqlCmm=sqlCnn.CreateCommand())
               {
                   sqlCnn.Open();
                   sqlCmm.CommandText="updatestudentsetstatus=@statuswheresid="
                       +e.CommandArgument.ToString();
                   sqlCmm.Parameters.AddWithValue("@status",e.CommandName);
                   sqlCmm.ExecuteNonQuery();
               }
           }
           this.BindStudent();
       }
}

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

<!DOCTYPEhtmlPUBLIC"-//W3C//DTDXHTML1.0Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
   <title></title>
</head>
<body>
   <formid="form1"runat="server">
   <div>
       <asp:RepeaterID="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:LinkButtonID="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>

希望本文所述对大家的asp.net程序设计有所帮助。

相关文章