AspNetPager控件的使用方法

首先从网上一下AspNetpager.dll文件

1、  先把AspNetPager.dll脱到工具箱中

如图：多一个控件出来，把他拖到界面上

 

2、新建 一个存储过程

如：

create procedure [dbo].[cwg2000]

(@startIndex int,--当前页码

@endIndex int,--每页显示多少条

@docount int)---一个标置，判段是求记录总条数还是求记录

as

if(@docount=100)

select count(*) from Customers

else

begin

 with temptbl as (

 SELECT ROW_NUMBER() OVER (ORDER BY customerID desc)AS Row, * from Customers )

 SELECT * FROM temptbl where Row between (@startIndex-1)*@endIndex+1 and @endIndex*(@startIndex)

End

 

3.新建一个数据链接类

public static DataTable getData(string name,params SqlParameter[] par)

    {

        string connection = "server=.;database=E://DOWNCODE//ASPNETPAGER72SAMPLES//APP_DATA//NORTHWND.MDF;uid=sa;pwd=123;";

        SqlConnection conn=new SqlConnection(connection);

        SqlCommand comm=new SqlCommand();

        comm.Connection = conn;

        comm.CommandType = CommandType.StoredProcedure;

        comm.CommandText = name;

        if (par!=null)

        {            foreach (SqlParameter p in par)

            {

                comm.Parameters.Add(p);

            }

        }

        SqlDataAdapter ap = new SqlDataAdapter(comm);

        DataTable table = new DataTable();

        ap.Fill(table);

        return table;

       

    }

4.在面页的pageLoad事件中写

        if (!IsPostBack)

        {

            int countpage = Convert.ToInt32((DB.getData("cwg2000", new SqlParameter("@startIndex", 1), new SqlParameter("@endIndex", 10), new SqlParameter("@docount",100))).Rows[0][0]);

            AspNetPager1.RecordCount = countpage;

            databin();

        }

5.建一个读取数据的方法

  private void databin()

    {

        AspNetPager1.PageSize = 5;

        Repeater1.DataSource = DB.getData("cwg2000", new SqlParameter("@startIndex", AspNetPager1.CurrentPageIndex), new SqlParameter("@endIndex",AspNetPager1.PageSize), new SqlParameter("@docount",1));

        Repeater1.DataBind();

    }

6. AspNetPager1的PageChanging事件中写入

    protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e)

    {

        AspNetPager1.CurrentPageIndex = e.NewPageIndex;

        databin();

}

设定示是样式

（1）

 

Css代码：

.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"

（2）

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;}

 

属性设置：CssClass="paginator" CurrentPageButtonClass="cpb"

（3）

.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"