在用datalist控件来绑定记录,如何实现上一篇、下一篇的链接,谢谢!

解决方案 »

  1.   

    链接时传递ID,在另一页面,将ID+1或-1,得到数据库中相应记录。
      

  2.   

    <asp:datalist id="datalist1" runat="server">
    ..................
    ..................
    ..................
    </asp:datalist><asp:HyperLink ID="lnPrevPage" runat="server">上一篇</asp:HyperLink>
    <asp:HyperLink ID="lnNextPage" runat="server">下一篇</asp:HyperLink>
    public PagedDataSource objpds;            conn.Open();
                SqlDataAdapter da = new SqlDataAdapter("......", conn);
                DataSet ds = new DataSet();
                da.Fill(ds, "...");
                conn.Close();            objpds = new PagedDataSource();
                objpds.DataSource = ds.Tables[0].DefaultView;
                objpds.AllowPaging = true;
                objpds.PageSize = 8;
                int curPage;
                if (Request.QueryString["Page"] != null)
                {
                    curPage = Int32.Parse(Request.QueryString["Page"]);
                }
                else
                {
                    curPage = 1;
                }            
              
                           if (!objpds.IsFirstPage)
                {
                    lnPrevPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage - 1);
                    lnPrevPage.Enabled = true;
                    lnPrevPage.ForeColor = System.Drawing.Color.CornflowerBlue;
                }
                else
                {
                    lnPrevPage.Enabled = false;
                }
                if (!objpds.IsLastPage)
                {
                    lnNextPage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(curPage + 1);
                    lnNextPage.Enabled = true;
                    lnNextPage.ForeColor = System.Drawing.Color.CornflowerBlue;
                }
                else
                {
                    lnNextPage.Enabled = false;
                }
                 datalist1.DataSource = objpds;
                datalist1.DataBind();
      

  3.   

    faint这叫人如何回答阿!