Repeater控件绑定及分页

韩丽萍

于 2016-07-10 10:49:15 发布

阅读量1k

点赞数

分类专栏：【项目实践】 ---------牛腩新闻发布系统【 Web前端】 ---------XML 文章标签： asp-net

本文链接：https://blog.csdn.net/boniesunshine/article/details/51870511

版权

【项目实践】同时被 3 个专栏收录

31 篇文章 0 订阅

订阅专栏

【 Web前端】

16 篇文章 1 订阅

订阅专栏

---------牛腩新闻发布系统

4 篇文章 0 订阅

订阅专栏

前言

学习牛腩的时候接触到Repeater控件，感觉很神奇。Repeater控件，DataList,Datagrid控件都能绑定数据库动态显示数据库等的内容。

Html代码

<head runat="server">
    <title>无标题页</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <h1>分页显示</h1>
        <p>
            <asp:Label ID="Label1" runat="server" Text="当前页："></asp:Label>
            <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
            <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="上一页" />
            <asp:Button ID="Button2" runat="server" Text="下一页" OnClick="Button2_Click" /></p>
        <asp:Panel ID="Panel1" runat="server" Height="224px" Width="503px">
        <asp:Repeater ID="Repeater1" runat="server">
        <ItemTemplate>
        <tr>
            <td>
            <!--数据绑定 绑定容器的数据项 “”里的是具体绑定的数据项 后面还有一个{0：}，可以设置数据的格式}-->
            <%# DataBinder.Eval(Container.DataItem,"LastName") %>
            <%# DataBinder.Eval(Container.DataItem,"FirstName") %>
            </td>
        </tr>   
        </ItemTemplate>
        <AlternatingItemTemplate>

            <tr>
                <td><font color="blue">
                <%# DataBinder.Eval(Container.DataItem,"LastName") %>
                <%# DataBinder.Eval(Container.DataItem,"FirstName") %>
                </td>
            </tr>   
            </font>  
        </AlternatingItemTemplate>
        <HeaderTemplate>
            <h3>模板页眉</h3>
            <table border="1">
            <tr>
                <td>员工名字</td>
            </tr>
        </HeaderTemplate>
        <FooterTemplate>
            <h3>模板页脚</h3>
            </table>
        </FooterTemplate>

        </asp:Repeater>
        </asp:Panel>

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

后台代码

public partial class repeaterControl : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        //第一次登录
        if (!this.IsPostBack)
        {
            this.Label2.Text = "1";
            this.dataBindToRepeater();

        }
    }

    private void dataBindToRepeater()
    {
        int curPage = Convert.ToInt32(this.Label2.Text);
        SqlConnection con = DB.createCon();
        SqlDataAdapter sda = new SqlDataAdapter();
        sda.SelectCommand = new SqlCommand("select * from employees", con);
        DataSet ds = new DataSet();
        sda.Fill(ds, "emp");
        //分页用pageddatasource
        System.Web.UI.WebControls.PagedDataSource ps = new PagedDataSource();
        ps.DataSource = ds.Tables["emp"].DefaultView;
        ps.AllowPaging = true;
        ps.PageSize = 3;
        ps.CurrentPageIndex = curPage - 1;
        this.Button1.Enabled = true;
        this.Button2.Enabled = true;
        if (curPage == 1)
        {
            this.Button1.Enabled = false;
        }
        if (curPage == ps.PageCount)
        {
            this.Button2.Enabled = false;
        }
        this.Repeater1.DataSource = ps;
        this.Repeater1.DataBind();
    }
    //上一页按钮单击
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.Label2.Text = Convert.ToString((Convert.ToInt32(this.Label2.Text)) - 1);
        this.dataBindToRepeater();
    }
    //下一页按钮单击
    protected void Button2_Click(object sender, EventArgs e)
    {
        this.Label2.Text = Convert.ToString((Convert.ToInt32(this.Label2.Text)) + 1);
        this.dataBindToRepeater();
    }
}