ASPNETPager分页控件简单示例

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

namespace WebTry
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        string ConnectionString = "uid=sa;pwd=123;database=mydata;server=.";

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                SqlConnection conn = new SqlConnection(ConnectionString);
                conn.Open();

                SqlCommand cmd = new SqlCommand("select count(*) from [User]", conn);
                cmd.Connection = conn;
                AspNetPager1.RecordCount = (int)cmd.ExecuteScalar();     //获取表中记录的数量
                conn.Close();

                BindData();
            }
        }
        /// <summary>
        /// AspNetPager1分页
        /// </summary>
        /// PageChanging事件
        /// <param name="src"></param>
        /// <param name="e"></param>
        protected void AspNetPager1_PageChanging(object src, WebControls.PageChangingEventArgs e)
        {

        }

        /// <summary>
        /// 自定义分页方法AspNetPager1
        /// </summary>
        public void BindData()
        {
            SqlConnection conn = new SqlConnection(ConnectionString);
            conn.Open();

            SqlDataAdapter da = new SqlDataAdapter("select * from [User]", conn);
            DataSet ds = new DataSet();
            da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "UserTable");
            //AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), 设置起始记录
            //AspNetPager1.PageSize  检索的最大值,即每页显示的记录数

            AspNetPager1.AlwaysShow = true; //总是显示分页
            AspNetPager1.PageSize = 5;      //每页显示的数量,设置aspNetPager的pagesize属性,默认10

            GridView1.DataSource = ds;
            GridView1.DataBind();
        }

        protected void AspNetPager1_PageChanging1(object src, WebControls.PageChangingEventArgs e)
        {
            AspNetPager1.CurrentPageIndex = e.NewPageIndex;
            datalistBind();
        }

    }
}

 

转载于:https://www.cnblogs.com/leochu2008/archive/2008/03/29/1128564.html