.net分页功能实现

html代码

 <div id="policy">
                    <asp:Repeater ID="Repeater1" runat="server">
                        <ItemTemplate>
                            <ul id="tt" class="yb_list notice_policy_list">


                                <li class="notice_policy_item flex">
                                    <div id="dtime" class="date"><%#DateTime.Parse(Eval("XXData").ToString()).ToString("MM-dd")%></div>
                                    <a id="title" class="notice_policy_text" href="xinwenxiangqing/xinwenxq.aspx?id=<%#Eval("ID")%>"><%#Eval("Tatle")%></a>
                                </li>


                            </ul>

                        </ItemTemplate>
                    </asp:Repeater>

                    <div class="btns">
                        <a id="xia2" runat="server" href="javascript:down();">下一页</a>
                        <a id="shang2" runat="server" href="javascript:up();">上一页</a>

                    </div>
                </div>
            </div>
        </div>
        <asp:HiddenField ID="hfMemberID" runat="server" />
        <asp:HiddenField ID="bbb" runat="server" />
        <asp:HiddenField ID="aaa" runat="server" />

js代码

  <script>
           
            function up() {
                var pageindex = $('#aaa').val();


                pageindex = parseInt(pageindex) - 1;

                location.href = 'policy.aspx?cmd=' + pageindex;
            };
            function down() {
                var pageindex = $('#aaa').val();

                pageindex = parseInt(pageindex) + 1;


                location.href = 'policy.aspx?cmd=' + pageindex;
            }
        </script>

.cs代码

public partial class policy : System.Web.UI.Page
    {
        protected string XXData = "";
        protected string sql2 = "";
        protected string biaoti = "";
        
        protected DataTable dt = new DataTable();
        protected DataTable dt2 = new DataTable();
        public static int cmd = 0;
      
        public static int pageStart = 0;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                biaoti = this.Label1.Text;

               
                cmd =Convert.ToInt32( Request["cmd"]??"1");

                aaa.Value = cmd.ToString();
                policyList(cmd);
               


            }
        }

        public void policyList(int cmd)
        {
         
            sql2 = @"select * from t_FaBuXinXi where XXType='" + biaoti + "' and Tatle='" + biaoti + "'";
            dt2 = DbHelperSQL.QueryDT(sql2);


            int pageStart = cmd;
            int pageCont = 5; 
            int start = (pageStart - 1) * pageCont;
            if (start == 0)
            {
                shang2.Visible = false;
            }
                 
            int end = (pageStart * pageCont) - 1;
            if (cmd == 1)
            {
                end = 5;
            }
            string sql = @"select * from ( select ROW_NUMBER() over(order by XXData desc) as row,* from t_FaBuXinXi where XXType='" + biaoti + "' )r  where r.row between  " + start + " and " + end;

            dt = DbHelperSQL.QueryDT(sql);
            if (dt.Rows.Count < 5)
            {
                xia2.Visible = false;
            }
            if (dt.Rows.Count == 0)
            {
                Response.Write("<script language=javascript>history.go(-1);</script>");
                Response.Write("<script language=javascript>alert('已经是最后一页');</script>");
                Response.End();
            }
                  
            Repeater1.DataSource = dt;
            Repeater1.DataBind();
          
           
        }

每页显示5条。