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"