repeater 分页

 

  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;
public   partial   class  _Default : System.Web.UI.Page 
... {
    SqlConnection conn = new SqlConnection("server=.;database=Ajax2005;uid=sa;pwd=");
    protected void Page_Load(object sender, EventArgs e)
    ...{
        if (!IsPostBack)
        ...{
            RepnewInfoDataBind();
        }
    }
    public void RepnewInfoDataBind()
    ...{
        SqlCommand comm = new SqlCommand();
        comm.CommandText = "select * from NewInfo";
        comm.Connection = conn;
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = comm;
        DataTable dt = new DataTable();
        //try
        //{
            da.Fill(dt);
            //创建分页类
            PagedDataSource pd = new PagedDataSource();
            //填充数据
            pd.DataSource = dt.DefaultView;
            //允许分页
            pd.AllowPaging = true;
            //设置每页显示条数
            pd.PageSize = 5;
            //定义变量用来保存但前索引
            int curPage;
            //判断页面是否有跳转的请求
            if (Request.QueryString["Page"] != null)
                curPage = Convert.ToInt32(Request.QueryString["Page"]);
            else
                curPage = 1;
            pd.CurrentPageIndex = curPage - 1;
            if (!pd.IsFirstPage)
            ...{/**/////定义"上一页"超级连接的URL为:当前执行页面的虚拟路径,并传递下一页面的索引植
                this.hplback.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage-1);
                //this.hplend.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + pd.PageCount.ToString();
            }
            this.hplfirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=1";
            this.hplend.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + pd.PageCount.ToString();
            if (!pd.IsLastPage)
            ...{
                this.hplnext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage + 1);
                //this.hplfirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + pd.FirstIndexInPage.ToString();

            }
            this.RepnewInfo.DataSource = pd;  

//这个地方赋值一定要用视图pagedatasource,我原来用的datatable就不行了
            this.RepnewInfo.DataBind();
        //}
        //catch { }
        //finally { Response.Write("<script>alert('对不起，数据不存在！')</script>");}
        
    }
  
}