现在的位置: 首页 > 综合 > 正文

用PagedDataSource作为Repeater数据源的例子

2013年10月03日 ⁄ 综合 ⁄ 共 2866字 ⁄ 字号 评论关闭

用PagedDataSource作为Repeater数据源的例子  


后台:

 protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection conn = db.GetCon();
        string sql = "select * from tongz";
        SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        sda.Fill(ds);
        PagedDataSource pds = new PagedDataSource();
        pds.DataSource = ds.Tables[0].DefaultView;
        pds.AllowPaging = true;
        pds.PageSize = 15;
        int CurPage;
        if (Request.QueryString["Page"] != null)
            CurPage = Convert.ToInt32(Request.QueryString["Page"]);
        else
            CurPage = 1;
        pds.CurrentPageIndex = CurPage - 1;
        Label1.Text = CurPage.ToString();
        Label2.Text = pds.PageCount.ToString();
        Label3.Text = pds.DataSourceCount.ToString();
        HyperLink3.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
        HyperLink4.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(pds.PageCount);
        if (!pds.IsFirstPage)
            HyperLink1.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);//上一页
        if (!pds.IsLastPage)
            HyperLink2.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);//下一页
        Repeater1.DataSource = pds;
        Repeater1.DataBind();
    }
前台:
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<tr>
<td bordercolor="#C0C0C0" height="18">
<li class=li1>[2007-4-25]&nbsp;<a  href="Tarticle.aspx?ID=<%#Eval("ID") %>"><%#Eval("Title") %></a></td>
</tr>
</ItemTemplate>
</asp:Repeater>
分页代码:
                                                                    <div align="center">
                                                                        &nbsp;<asp:HyperLink ID="HyperLink3" runat="server">首页</asp:HyperLink>
                                                                        <asp:HyperLink ID="HyperLink1" runat="server">上一页</asp:HyperLink>&nbsp<a href="http://courseware.lzu.edu.cn/shownews.asp?page=2"
                                                                            target="_self"><asp:HyperLink ID="HyperLink2" runat="server">下一页</asp:HyperLink></a>
                                                                        <a href="http://courseware.lzu.edu.cn/shownews.asp?page=2" target="_self">
                                                                            <asp:HyperLink ID="HyperLink4" runat="server">尾页</asp:HyperLink></a> &nbsp;页次:<asp:Label
                                                                                ID="Label1" runat="server" Text="Label"></asp:Label>/<asp:Label ID="Label2" runat="server"
                                                                                    Text="Label"></asp:Label>
                                                                        共<asp:Label ID="Label3" runat="server" Text="Label"></asp:Label>条记录&nbsp;
                                                                    </div>

//转自http://livder.blog.163.com/blog/static/1747576482010102354828245/

抱歉!评论已关闭.