AspNetPager怎么用

不用存储过程方式

DataSet ds;    SqlDataAdapter dr;    SqlCommand com;    protected void Page_Load(object sender, EventArgs e)    {        if (!IsPostBack)        {                  SqlConnection con = new SqlConnection("server=.;uid=sa;database=数据库");             con.Open();            com = new SqlCommand();            com.Connection = con;            com.CommandText = "select count(*) from Employees";AspNetPager1.AlwaysShow=true;AspNetPager1.PageSize=15;            AspNetPager1.RecordCount = (int)com.ExecuteScalar();            con.Close();            DataListDataBind();        }    }    private void DataListDataBind()    {        SqlConnection con = new SqlConnection("server=.;uid=sa;database=数据库");           dr = new SqlDataAdapter("select * from Employees", con);        ds = new DataSet();        dr.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "Employees");         DataList1.DataSource = ds.Tables["Employees"];         DataList1.DataBind();       }    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)    {        AspNetPager1.CurrentPageIndex = e.NewPageIndex;        DataListDataBind();    }
//==============================
按钮样式网上收集
http://www.cnblogs.com/zengxiangzhan/archive/2010/03/03/1677460.html
http://hi.baidu.com/thinkingthigh/item/9f37a1a5641110df5bf19105
分页是Web应用程序中最常用到的功能之一，AspNetPager  简单实用，应用到项目后台中，棒极了！
 
自定义样式：
<style type="text/css">/*拍拍网风格*/.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}/*淘宝风格*/.paginator { font: 12px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}.paginator a {border:solid 1px #ccc;color:#0063dc;cursor:pointer;text-decoration:none;}.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}.paginator .cpb {border:1px solid #F50;font-weight:700;color:#F50;background-color:#ffeee5;}.paginator a:hover {border:solid 1px #F50;color:#f60;text-decoration:none;}.paginator a,.paginator a:visited,.paginator .cpb,.paginator a:hover  {float:left;height:16px;line-height:16px;min-width:10px;_width:10px;margin-right:5px;text-align:center; white-space:nowrap;font-size:12px;font-family:Arial,SimSun;padding:0 3px;} </style>
前台：
<table cellpadding="0" cellspacing="0" align="center" width="99%" class="border"><tr><td align="left" colspan="2"><webdiyer:AspNetPager ID="AspNetPager1" CssClass="paginator"   CurrentPageButtonClass="cpb" runat="server" AlwaysShow="True" FirstPageText="首页"  LastPageText="尾页" NextPageText="下一页"  PageSize="20" PrevPageText="上一页"  ShowCustomInfoSection="Left" ShowInputBox="Never" onpagechanged="AspNetPager1_PageChanged"  CustomInfoTextAlign="Left" LayoutType="Table"  ></webdiyer:AspNetPager></td></tr></table>
 
 
后台：
void bindData()   {
       .......绑定语句
       this.AspNetPager1.CustomInfoHTML = string.Format("当前第{0}/{1}页 共{2}条记录 每页{3}条", new object[] { this.AspNetPager1.CurrentPageIndex, this.AspNetPager1.PageCount, this.AspNetPager1.RecordCount, this.AspNetPager1.PageSize });   }   protected void AspNetPager1_PageChanged(object src, EventArgs e)   {       bindData();   }
------2-----
 
AspNetPager 样式
 
关键词：AspNetPager 样式的使用 AspNetPager 样式设置 AspNetPager 样式表 AspNetPager 主题 AspNetPager 外观
使用方法：
1.引入样式表。
将想要使用的样式表加入到本页面<style type="text/css"></style>标记中，或者新建一个css文件如：AspNetPager.css,将样式粘贴进去，并在页面添加<link href="AspNetPager.css" rel="stylesheet" type="text/css" />进行引用。
2.添加AspNetPager控件属性：CssClass="paginator" CurrentPageButtonClass="cpb"
举例说明：
首先，新建AspNetPager.css文件，将如下内容粘贴到里面，保存在和页面同级的目录下吧。
/*拍拍网风格*/
.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}
.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}
/*淘宝风格*/
.paginator { font: 12px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {border:solid 1px #ccc;color:#0063dc;cursor:pointer;text-decoration:none;}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {border:1px solid #F50;font-weight:700;color:#F50;background-color:#ffeee5;}
.paginator a:hover {border:solid 1px #F50;color:#f60;text-decoration:none;}
.paginator a,.paginator a:visited,.paginator .cpb,.paginator a:hover  
{float:left;height:16px;line-height:16px;min-width:10px;_width:10px;margin-right:5px;text-align:center;
 white-space:nowrap;font-size:12px;font-family:Arial,SimSun;padding:0 3px;}
 接着，在页面内添加<link href="AspNetPager.css" rel="stylesheet" type="text/css" />标记，引入样式表。
最后，找到页面内的AspNetPager控件，添加CssClass CurrentPageButtonClass属性。
<webdiyer:AspNetPager ID="AspNetPager1" runat="server" FirstPageText="首页" 
                    HorizontalAlign="Center" LastPageText="尾页" NextPageText="下一页" 
                    onpagechanged="AspNetPager1_PageChanged" PageIndexBoxType="TextBox" 
                    PageSize="7" PrevPageText="上一页" ShowPageIndexBox="Auto" SubmitButtonText="Go" 
                    TextAfterPageIndexBox="页" TextBeforePageIndexBox="转到" UrlPaging="True" CssClass="paginator" CurrentPageButtonClass="cpb" >
                </webdiyer:AspNetPager> 
切换到视图模式或者在浏览器中查看该网页，是不是样式已经添加成功啦？
另附其他风格的几种样式，将样式引入网页后，请根据类选择器的名称不同配置控件的CssClass CurrentPageButtonClass属性。
网易风格：
.anpager .cpb {background:#1F3A87 none repeat scroll 0 0;border:1px solid #CCCCCC;color:#FFFFFF;font-weight:bold;margin:5px 4px 0 0;padding:4px 5px 0;}
.anpager a {background:#FFFFFF none repeat scroll 0 0;border:1px solid #CCCCCC;color:#1F3A87;margin:5px 4px 0 0;padding:4px 5px 0;text-decoration:none}
.anpager a:hover{background:#1F3A87 none repeat scroll 0 0;border:1px solid #1F3A87;color:#FFFFFF;}
属性设置：CssClass="anpager" CurrentPageButtonClass="cpb"
 
拍拍风格：
.paginator { font: 11px Arial, Helvetica, sans-serif;padding:10px 20px 10px 0; margin: 0px;}
.paginator a {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;margin-right:2px}
.paginator a:visited {padding: 1px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.paginator .cpb {padding: 1px 6px;font-weight: bold; font-size: 13px;border:none}
.paginator a:hover {color: #fff; background: #ffa501;border-color:#ffa501;text-decoration: none;}
属性设置：CssClass="paginator" CurrentPageButtonClass="cpb"
 
迅雷风格：
.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;}
CssClass="pages" CurrentPageButtonClass="cpb"