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();