• 设为首页
  • 点击收藏
  • 手机版
    手机扫一扫访问
    迪恩网络手机版
  • 关注官方公众号
    微信扫一扫关注
    公众号

ASP.NET中repeater控件用法实例

原作者: [db:作者] 来自: [db:来源] 收藏 邀请

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

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">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <%--<asp:Repeater ID="Repeater1" runat="server">
    <HeaderTemplate>
    <hr />
    </HeaderTemplate>
    <ItemTemplate><div>
    <asp:Label ID="lblSid" runat="server" Text='<%# Eval("sid") %>'></asp:Label>
    <asp:Label ID="lblSname" runat='server' Text='<%# Eval("sname") %>'></asp:Label>
    <asp:Image ID="imgPhoto" runat="server" ImageUrl='<%# Eval("photo") %>' /></div>
    </ItemTemplate>
    <SeparatorTemplate>
    <hr />
    </SeparatorTemplate>
    <AlternatingItemTemplate>
    <div style="
    <asp:Label ID="lblSid" runat="server" Text='<%# Eval("sid") %>'></asp:Label>
    <asp:Label ID="lblSname" runat='server' Text='<%# Eval("sname") %>'></asp:Label>
    <asp:Image ID="imgPhoto" runat="server" ImageUrl='<%# Eval("photo") %>' /></div>
    </AlternatingItemTemplate>
    <FooterTemplate><hr /></FooterTemplate>
    </asp:Repeater>--%>
    <div>

        <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>&nbsp;</td><td>&nbsp;</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 set status=@status where 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>&nbsp;</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>

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


鲜花

握手

雷人

路过

鸡蛋
该文章已有0人参与评论

请发表评论

全部评论

专题导读
上一篇:
.Net遍历窗体上控件的方法发布时间:2022-02-05
下一篇:
asp.net 错误:0x8007000B 异常的解决方法发布时间:2022-02-05
热门推荐
热门话题
阅读排行榜

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服(服务时间 9:00~18:00)

在线QQ客服
地址:深圳市南山区西丽大学城创智工业园
电邮:jeky_zhao#qq.com
移动电话:139-2527-9053

Powered by 互联科技 X3.4© 2001-2213 极客世界.|Sitemap