分页控件的用法

private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("aspnetpager.mdb"));
   if(!Page.IsPostBack)
   {
    cmd=new OleDbCommand("select count(newsid) from wqnews",conn);
    conn.Open();
    pager.RecordCount=(int)cmd.ExecuteScalar();
    conn.Close();
    BindData();
   }
  }

  void BindData()
  {
   cmd=new OleDbCommand("select newsid,heading,source,addtime from wqnews order by addtime desc",conn);
   OleDbDataAdapter adapter=new OleDbDataAdapter(cmd);
   DataSet ds=new DataSet();
   adapter.Fill(ds,pager.PageSize*(pager.CurrentPageIndex-1),pager.PageSize,"news");
   Repeater1.DataSource=ds.Tables["news"];
   Repeater1.DataBind();

   //动态设置用户自定义文本内容
   pager.CustomInfoText="记录总数：<font color=/"blue/"><b>"+pager.RecordCount.ToString()+"</b></font>";
   pager.CustomInfoText+=" 总页数：<font color=/"blue/"><b>"+pager.PageCount.ToString()+"</b></font>";
   pager.CustomInfoText+=" 当前页：<font color=/"red/"><b>"+pager.CurrentPageIndex.ToString()+"</b></font>";
  }

  private void ChangePage(object src,PageChangedEventArgs e)
  {
   pager.CurrentPageIndex=e.NewPageIndex;
   BindData();
  }