asp.net中ListView与DataPager分页程序

作者:袖梨 2022-06-25

页面代码如下:


       
       
       
       
       
       
   
 

    PagedControlID="_simpleTableListView" PageSize="2"
    onprerender="DataPager2_PreRender">
   
                    ShowLastPageButton="True" />
   


 代码如下 复制代码

 
   
     
       
            
            
            
            
            
            
       
     
     
       
     

   

                 ID

                 StudentID

                 Name

                 Math

                 English

                 Chinese

 

 
   

           
       

           
       

           
       

           
       

           
       

           
       

后台代码:
   

 代码如下 复制代码
protected void DataPager2_PreRender(object sender, EventArgs e)
    {
        BindData();
    }
 private void BindData()
    {
  using (OleDbConnection conn = new OleDbConnection(OleDbHelper.ConnectionString))
  {
   string sql = "select * from studentscore";
   OleDbDataAdapter dp=new OleDbDataAdapter(sql,conn);
   DataTable dt = new DataTable();
   dp.Fill(dt);
   _simpleTableListView.DataSource = dt;
   _simpleTableListView.DataBind();
  }
    }

注意:使用本方法,不需要在页面的Page_Load事件中绑定数据到ListView控件,
否则分页会有问题。

第2种方法:

 代码如下 复制代码
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindData();
        }
    }
 protected void _simpleTableListView_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e)
    {
        DataPager2.SetPageProperties(e.StartRowIndex, e.MaximumRows, false);
        BindData();
    }

相关文章

精彩推荐