Repeter实现分页显示,嵌套
Repeter实现分页显示,嵌套
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
publicpartialclass _Default : System.Web.UI.Page
{
    protectedvoid Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
             Repeater1.DataSource = pds();
             Repeater1.DataBind();
         }
         ds.Relations.Add("mydb", ds.Tables["name"].Columns["au_id"], ds.Tables["title"].Columns["au_id"]);
     }
    public PagedDataSource pds()
    {
        string connstring = ConfigurationManager.ConnectionStrings["pubconn"].ConnectionString;
         SqlConnection con =new SqlConnection(connstring);
         SqlDataAdapter sda =new SqlDataAdapter("select * from authors", con);
         DataSet ds =new DataSet();
         sda.Fill(ds, "name");
         SqlDataAdapter sda2 =new SqlDataAdapter("select * from titleauthor", con);
         sda2.Fill(ds, "title");
         ds.Relations.Add("mydb", ds.Tables["name"].Columns["au_id"], ds.Tables["title"].Columns["au_id"]);
         PagedDataSource pds =new PagedDataSource();
         pds.DataSource =ds.Tables["name"].DefaultView;
         pds.AllowPaging =true;
         pds.CurrentPageIndex = Convert.ToInt32(Request.QueryString["page"]);
         pds.PageSize =5;
        return pds;
     }
    protectedvoid Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Footer)
        {
            int n = pds().PageCount;
            int i = pds().CurrentPageIndex;
             Label gjy = (Label)e.Item.FindControl("gjy");
             gjy.Text = n.ToString();
             Label djy = (Label)e.Item.FindControl("djy");
             djy.Text = Convert.ToString(pds().CurrentPageIndex+1);
             HyperLink first = (HyperLink)e.Item.FindControl("first");
             first.NavigateUrl ="?page=0";
             HyperLink end = (HyperLink)e.Item.FindControl("end");
             end.NavigateUrl ="?page="+ Convert.ToInt32(n -1);
             HyperLink p = (HyperLink)e.Item.FindControl("p");
             HyperLink next = (HyperLink)e.Item.FindControl("next");
            if (i <=0)
            {
                 first.Enabled =false;
                 p.Enabled =false;
                 next.Enabled =true;
             }
            else
            {
                 p.NavigateUrl ="?page="+ Convert.ToInt32(i -1);
             }
            if (i > n -2)
            {
                 end.Enabled =false;
                 next.Enabled =false;
                 p.Enabled =true;
             }
            else
            {
                 next.NavigateUrl ="?page="+ Convert.ToInt32(i +1);
             }
         }
     }
}
 
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
publicpartialclass _Default : System.Web.UI.Page
{
    protectedvoid Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
             Repeater1.DataSource = pds();
             Repeater1.DataBind();
         }
         ds.Relations.Add("mydb", ds.Tables["name"].Columns["au_id"], ds.Tables["title"].Columns["au_id"]);
     }
    public PagedDataSource pds()
    {
        string connstring = ConfigurationManager.ConnectionStrings["pubconn"].ConnectionString;
         SqlConnection con =new SqlConnection(connstring);
         SqlDataAdapter sda =new SqlDataAdapter("select * from authors", con);
         DataSet ds =new DataSet();
         sda.Fill(ds, "name");
         SqlDataAdapter sda2 =new SqlDataAdapter("select * from titleauthor", con);
         sda2.Fill(ds, "title");
         ds.Relations.Add("mydb", ds.Tables["name"].Columns["au_id"], ds.Tables["title"].Columns["au_id"]);
         PagedDataSource pds =new PagedDataSource();
         pds.DataSource =ds.Tables["name"].DefaultView;
         pds.AllowPaging =true;
         pds.CurrentPageIndex = Convert.ToInt32(Request.QueryString["page"]);
         pds.PageSize =5;
        return pds;
     }
    protectedvoid Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        if (e.Item.ItemType == ListItemType.Footer)
        {
            int n = pds().PageCount;
            int i = pds().CurrentPageIndex;
             Label gjy = (Label)e.Item.FindControl("gjy");
             gjy.Text = n.ToString();
             Label djy = (Label)e.Item.FindControl("djy");
             djy.Text = Convert.ToString(pds().CurrentPageIndex+1);
             HyperLink first = (HyperLink)e.Item.FindControl("first");
             first.NavigateUrl ="?page=0";
             HyperLink end = (HyperLink)e.Item.FindControl("end");
             end.NavigateUrl ="?page="+ Convert.ToInt32(n -1);
             HyperLink p = (HyperLink)e.Item.FindControl("p");
             HyperLink next = (HyperLink)e.Item.FindControl("next");
            if (i <=0)
            {
                 first.Enabled =false;
                 p.Enabled =false;
                 next.Enabled =true;
             }
            else
            {
                 p.NavigateUrl ="?page="+ Convert.ToInt32(i -1);
             }
            if (i > n -2)
            {
                 end.Enabled =false;
                 next.Enabled =false;
                 p.Enabled =true;
             }
            else
            {
                 next.NavigateUrl ="?page="+ Convert.ToInt32(i +1);
             }
         }
     }
}

    东莞龙光网络
提供各种平台的解决方案
 网站建设与网站改版
 百度SEO(自然排名优化,年付)
 中国商机发布引擎(软件)
 SEO顾问咨询(门户站)
 网络推广外包(月付
http://www.xieguang133.com/
posted on 2009-08-14 10:06 xieguang133 阅读(181) 评论(0) 收藏 举报
                    
                

    
                
            
        
浙公网安备 33010602011771号