AspNetPager控件的使用

//测试pagechange的用法

private void Page_Load(object sender, System.EventArgs e)
  {

   if(!Page.IsPostBack) //不回送
   {
    renyuan_bind();
   }
  }

 
  private void renyuan_bind()
  {
   string oracle_sql="select p.perscode,p.pchinesename from pers_baseinfo p";

   oracle_sql=oracle_sql+" where depacode ='1206' order by perscode";
   OracleConnection conn=new OracleConnection(connstr);
   conn.Open();

//这也是一种取总数的方法
//   string count_num="select count(*) from pers_baseinfo p where depacode ='1206' order by perscode";
//   OracleCommand cmd = new OracleCommand(count_num,conn);
//   int i=int.Parse(cmd.ExecuteScalar().ToString());
//   pagertop.RecordCount = i;
  
   OracleDataAdapter oracle_da=new OracleDataAdapter(oracle_sql,conn);
   DataSet oracle_myds=new DataSet();

   //取总数,对分页控件记录总数附值
   oracle_da.Fill(oracle_myds,"ds");
   pagertop.RecordCount=oracle_myds.Tables["ds"].Rows.Count;
   oracle_myds.Tables.Remove("ds");

   //对dateset进行分页
   oracle_da.Fill(oracle_myds,pagertop.PageSize * (pagertop.CurrentPageIndex - 1), pagertop.PageSize,

"ds");
  
   this.dgd_renyuan.DataSource=oracle_myds.Tables["ds"];
   this.dgd_renyuan.DataBind();
   conn.Close();

   //自定义分页控件的文本
   pagertop.CustomInfoText="记录总数：<font color=/"blue/"><b>"+pagertop.RecordCount.ToString()

+"</b></font>";
   pagertop.CustomInfoText+="共<font color=/"blue/"><b>"+pagertop.PageCount.ToString()+"页</b></font>";
   pagertop.CustomInfoText+=" 第<font color=/"red/"><b>"+pagertop.CurrentPageIndex.ToString()+"页

</b></font>";
  }

// 定义分页事件
  private void pagertop_PageChanged(object src, Sun.ChangePage.PageChangedEventArgs e)
  {
   pagertop.CurrentPageIndex=e.NewPageIndex;
   renyuan_bind();
  }

// 自定义控件的PageSize,即每页显示的个数
  private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
  {
   pagertop.PageSize=int.Parse(this.DropDownList1.SelectedValue);
   renyuan_bind();
  }