protected void Page_Load(object sender, EventArgs e) { OleDbConnection con = DB.createCon (); OleDbDataAdapter da = new OleDbDataAdapter("select id,img,pro_name from product ", con); DataSet ds = new DataSet(); try { con.Open(); //填充数据 da.Fill(ds, "type"); // 创建分页类 PagedDataSource objPage = new PagedDataSource(); objPage.DataSource = ds.Tables["type"].DefaultView; //设置总的查询结果 lbCount.Text = "总共有" + ds.Tables["type"].Rows.Count.ToString() + "条记录"; //设置可以分页以及每页的行数 objPage.AllowPaging = true; objPage.PageSize = 4; //总页数 lbTotalPage.Text = "总页数:" + objPage.PageCount.ToString() + "页"; //定义变量来保存当前页 int CurPage; //判断是否具有页面跳转的请求 if (Request.QueryString["Page"] != null) { CurPage = Convert.ToInt32(Request.QueryString["Page"]); } else { CurPage = 1; } //设置当前页的索引 objPage.CurrentPageIndex = CurPage - 1; lbCurPage.Text = "第" + CurPage.ToString() + "页"; //如果不是首页 if (!objPage.IsFirstPage) { //定义上一页超链接的url为: 当前执行页面的虚拟路径,并传递下一页面的索引值 hlnkHead.PostBackUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1); hlnkPrev.PostBackUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1); } //如果不是最后一页 if (!objPage.IsLastPage) { //定义“下一页”超链接url为:当前执行页面的虚拟路径,并传递下一页面的索引值 hlnkNext.PostBackUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1); hlnkEnd.PostBackUrl = Request.CurrentExecutionFilePath + "?Page=" + objPage.PageCount.ToString(); } DataList1.DataSource = objPage; DataList1.DataBind(); con.Close(); } catch (Exception error) { Response.Write(error.ToString()); } } 首页 上一页尾页 下一页