分页控件,帮忙看下那里出错了.显示的一直是第一页的数据

2008-12-11 10:47:41 230 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

C# Winform 分页控件实战：从零构建高效数据展示界面本文详细介绍了如何使用C# Winform开发高效的分页控件，解决大数据量展示时的性能瓶颈问题。通过分页算法、数据绑定优化和数据库分页查询等核心技术，实现快速加载和流畅的用户体验。文章还涵盖了事件处理、异步加载和性能优化等高级功能，帮助开发者构建专业级数据展示界面。阅读详情



 <webdiyer:aspnetpager id="AspNetPager1" runat="server" firstpagetext="首页" lastpagetext="尾页"

                 nextpagetext="后页" onpagechanging="AspNetPager1_PageChanging" prevpagetext="前页"

                 ShowPageIndexBox="Always" SubmitButtonText="Go" TextAfterPageIndexBox="页" 

                 TextBeforePageIndexBox="转到" CustomInfoHTML="第%CurrentPageIndex%页，共%PageCount%页，每页%PageSize%条" CustomInfoSectionWidth="30%" PageIndexBoxType="DropDownList" ShowCustomInfoSection="Left"> </webdiyer:aspnetpager>



 public DataSet ds;

    public int aid = Convert.ToInt16(SqlZr.DelSQLStr(HttpContext.Current.Request.QueryString["cid"].ToString()));

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!Page.IsPostBack)

        {

            DataTable ds1 = product.getproductsbyclass2id(aid).Tables[0];

            AspNetPager1.AlwaysShow = true;

            AspNetPager1.PageSize = 15;

            AspNetPager1.RecordCount = ds1.Rows.Count;

            bind();

            show();

        }

    }

    private void bind()

    {

        using (SqlDataReader sdr = product.GetSingleClass(aid))

            if (sdr.Read())

            {

                pname.Text = sdr["P_name"].ToString();

                pinfo.Text = sdr["P_ename"].ToString();

            }

    }

    private void show()

    {

        SqlConnection con = new SqlConnection(SqlHelper.CONNSTR);

        con.Open();

        SqlDataAdapter dr = new SqlDataAdapter("select * from products where P_class1="+aid+"  order by P_time desc", con);

        ds = new DataSet();

        dr.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "Employees");

        DataList1.DataSource = ds.Tables["Employees"];

        DataList1.DataBind();

        con.Close();

    }

    protected void AspNetPager1_PageChanging(object src, PageChangingEventArgs e)

    {

        AspNetPager1.CurrentPageIndex = e.NewPageIndex;

        bind();

    }