repeater 控件用法及样式

<webdiyer:aspnetpager id="AspNetPager1" runat="server" AlwaysShow="True"  OnPageChanging="AspNetPager1_PageChanging" CssClass="pages" CurrentPageButtonClass="cpb" OnPageChanged="AspNetPager1_PageChanged" FirstPageText="首页" LastPageText="尾页" NextPageText="下一页" PrevPageText="上一页" ></webdiyer:aspnetpager>

//调用样式

<style type="text/css">
.pages { color: #999; }
.pages a, .pages .cpb { text-decoration:none;float: left; padding: 0 5px; border: 1px solid #ddd;background: #ffff;margin:0 2px; font-size:11px; color:#000;}
.pages a:hover { background-color: #E61636; color:#fff;border:1px solid #E61636; text-decoration:none;}
.pages .cpb { font-weight: bold; color: #fff; background: #E61636; border:1px solid #E61636;}
</style>


            AspNetPager1.PageSize = 8;//每页显示8条
            AspNetPager1.RecordCount =SqlHelper.Execsql();//选出所有记录

            int pagesize = 8;//每页显示8条
            int nowpage = 1;//当前页码，默认为1
          
         //绑定repeater控件
            Repeater1.DataSource = SqlHelper.SelectAll(pagesize, nowpage);

//双击repeater控件
    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)
    {
        int pagesize =8;//每页显示8页
        int nowpage= e.NewPageIndex;//获取当前页码
        Repeater1.DataSource = SqlHelper.SelectAll(pagesize, nowpage);
        Repeater1.DataBind();

    }

//SQL语句
                openconn();
                dt= new DataTable();
                dt.Clear();
                string sql = "select top (@pagesize) * from [Users] where uid not in(select top (@pagesize*(@nowpage-1)) uid from [Users] )";
                SqlParameter[] paras = new SqlParameter[]{
                    new SqlParameter("@pagesize",pagesize),
                    new SqlParameter("@nowpage",nowpage)
               
                };
                cmd = new SqlCommand(sql, sqlconn);
                cmd.Parameters.AddRange(paras);
               using (sdr = cmd.ExecuteReader(CommandBehavior.CloseConnection))
                {
                  dt.Load(sdr);
                }
            Repeater1.DataBind();