解决方案 »

  1.   

    http://www.webdiyer.com/Controls/AspNetPager这个分页控件不错,不是微软自带的
      

  2.   

    AspNetPager,使用的时候只要设置pagesize之类的就可以了
      

  3.   

    http://www.webdiyer.com/AspNetPagerDemo/default.aspx这里是作者的写的例子
      

  4.   

    Demo
    分页控件例子<asp:GridView ID="GridView1" runat="server" EnableViewState="false">
        </asp:GridView>
        <webdiyer:AspNetPager ID="AspNetPager1" runat="server" PageSize="10" OnPageChanging="AspNetPager1_PageChanging">
        </webdiyer:AspNetPager>using System;
    using System.Data;
    using Wuqi.Webdiyer;
    using ZhongCong.WebForm;public partial class MySql : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                DisplayData(AspNetPager1.PageSize, 1);
            }
        }    private void DisplayData(int pageSize, int pageIndex)
        {
            string sqlStr = "select count(*) from 测试";
            MySqlData md = new MySqlData();
            AspNetPager1.RecordCount = Convert.ToInt32(md.ExecuteScalar(sqlStr));
            sqlStr = String.Format("select * from 测试 limit {0},{1}", ((pageIndex - 1) * pageSize).ToString(), pageSize.ToString());
            md.SetCommandText(sqlStr);
            DataTable dt = md.FillDataTable();
            md.Close();
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }    protected void AspNetPager1_PageChanging(object src, PageChangingEventArgs e)
        {
            AspNetPager1.CurrentPageIndex = e.NewPageIndex;
            DisplayData(AspNetPager1.PageSize, AspNetPager1.CurrentPageIndex);
        }
    }
    参考
      

  5.   

    这个很多哎!我一般就是用aspnetpager做的!
      

  6.   

    http://topic.csdn.net/u/20110505/17/de37853b-588d-42a6-a388-d98ec2e38361.html简介在线演示这个感觉挺简单的,不需要存储过程,速度也很快。
    分页速度体验
      

  7.   

    UP!好多哦,我现在就用PDS类
    后台:
       public void datalistbind() 
            {
                //数据源
                BLL.NewsBLL ne = new BLL.NewsBLL();
                DataTable dt = ne.NewsDatalist();            //设置当前页
                int curpage = Convert.ToInt32(Label_pageNow.Text.Trim());            //分页设置
                PagedDataSource pds = new PagedDataSource();
                pds.DataSource = dt.DefaultView;
                pds.AllowPaging = true;
                pds.PageSize = 10;
                pds.CurrentPageIndex = curpage - 1;//当前的索引,当前页
                Label_TotalPages.Text = pds.PageCount.ToString();//共有的页数            //分页了
                LinkButton_Finlly.Enabled = true;
                LinkButton_First.Enabled = true;
                LinkButton_Next.Enabled = true;
                LinkButton_Up.Enabled = true;            if (curpage == 1) 
                {
                    LinkButton_Up.Enabled = false;
                    LinkButton_First.Enabled = false;
                }
                if(curpage == pds.PageCount)
                {
                    LinkButton_Next.Enabled = false;
                    LinkButton_Finlly.Enabled = false;
                }
                DataList1.DataSource = pds;
                DataList1.DataBind();
            }        protected void LinkButton_Finlly_Click(object sender, EventArgs e)
            {
                Label_pageNow.Text = Label_TotalPages.Text;
                this.datalistbind();
            }        protected void LinkButton_Up_Click(object sender, EventArgs e)
            {
                Label_pageNow.Text = Convert.ToString(Convert.ToInt32(Label_pageNow.Text)-1);
                this.datalistbind();
            }        protected void LinkButton_Next_Click(object sender, EventArgs e)
            {
                Label_pageNow.Text = Convert.ToString(Convert.ToInt32(Label_pageNow.Text)+1);
                this.datalistbind();
            }        protected void LinkButton_First_Click(object sender, EventArgs e)
            {
                Label_pageNow.Text = "1";
                this.datalistbind();
            }