【转】AspNetPager分页控件使用方法例子

来源：互联网发布：足球数据分析网站编辑：程序博客网时间：2024/04/30 23:58

一、前台显示界面代码Default.aspx（注意,代码运行环境是VS.2005）

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default4" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<title>用AspNetPager.dll控件的分页方法操作方法</title>

</head>

<body>

<div>

<asp:Repeater ID="Repeater1" runat="server">

<tr>

</tr>

</ItemTemplate>

</asp:Repeater>

</table>

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" Width="100%" NumericButtonCount="6" UrlPaging="true" NumericButtonTextFormatString="[{0}]" CustomInfoHTML="第 <font color='red'><b>%CurrentPageIndex%</b></font> 页共 %PageCount% 页显示 %StartRecordIndex%-%EndRecordIndex% 条" ShowCustomInfoSection="left"

FirstPageText="首页" LastPageText="末页" NextPageText="下页" PrevPageText="上页" Font-Names="Arial" BackColor="#F8B500" AlwaysShow="true" ShowInputBox="Always" SubmitButtonText="跳转" SubmitButtonStyle="botton" OnPageChanged="AspNetPager1_PageChanged" >

</webdiyer:AspNetPager>

<%--<webdiyer:AspNetPager ID="AspNetPager1" runat="server" PageSize="15" style="font-size:14px;" HorizontalAlign="Right" NumericButtonCount="6" NumericButtonTextFormatString="[{0}]" CustomInfoHTML="第 <font color='red'><b>%CurrentPageIndex%</b></font> 页共 %PageCount% 页显示 %StartRecordIndex%-%EndRecordIndex% 条" InputBoxStyle="width:24px; height:14px;" ShowInputBox="Always" SubmitButtonText=" GO " FirstPageText="[首页]" PrevPageText="[上页]" NextPageText="[下页]" LastPageText="[末页]" TextBeforeInputBox="转到第" TextAfterInputBox="页 " PagingButtonSpacing="10px" width="100%" ShowCustomInfoSection="Left" UrlPaging="true"></webdiyer:AspNetPager>

--%>

</div>

</form>

</body>

</html>

二、Default.aspx.cs页面的代码

DBAccess db = new DBAccess();

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{ BindGrid(); }

}

protected void AspNetPager1_PageChanged(object sender, EventArgs e)

{ BindGrid();

}

public void BindGrid()

{

this.AspNetPager1.RecordCount = Int32.Parse(db.GetAllCount().ToString());

int pageIndex = this.AspNetPager1.CurrentPageIndex - 1;

int pageSize = this.AspNetPager1.PageSize = 20;

Repeater1.DataSource = db.GetCurrentPage(pageIndex, pageSize);

Repeater1.DataBind();

}

三、DBAccess.cs页面的代码

using System.Data.SqlClient;

public class DBAccess

{

private SqlConnection con;

private string DBName = "tongjinet";

//创建连接对象并打开

public void Open()

{

if (con == null)

con = new SqlConnection("server=(local);uid=sa;pwd=sql;database=" + DBName);

if (con.State == ConnectionState.Closed)

con.Open();

}

//创建一个命令对象并返回该对象

public SqlCommand CreateCommand(string sqlStr)

{

Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = sqlStr;

cmd.Connection = con;

return cmd;

}

//生成一个对象并返回该结果集第一行第一列

public object GetScalar(string sqlStr)

{

SqlCommand cmd = CreateCommand(sqlStr);

object obj = cmd.ExecuteScalar();

//CommadnBehavior.CloseConnection是将于DataReader的数据库链接关联起来

//当关闭DataReader对象时候也自动关闭链接

return obj;

}

//执行数据库查询并返回一个数据集 [当前页码,每页记录条数]

public DataSet GetCurrentPage(int pageIndex, int pageSize)

{

//设置导入的起始地址

int firstPage = pageIndex * pageSize;

string sqlStr = "select * from outputsell order by osid desc";

SqlCommand cmd = CreateCommand(sqlStr);

DataSet dataset = new DataSet();

SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);

dataAdapter.Fill(dataset, firstPage, pageSize, "outputsell");

cmd.Dispose();

Close();

dataAdapter.Dispose();

return dataset;

}

//获得查询数据的总条数

public object GetAllCount()

{

string sqlStr = "select count(*) from outputsell";

object obj = GetScalar(sqlStr);

return obj;

}

//关闭数据库

public void Close()

{

if (con != null)

{

con.Close();

}

//释放资源

public void Dispose()

{

if (con != null)

{

con.Dispose();

con = null;

}

AspNetPager分页控件使用方法（不使用DBAccess.cs文件）（二）

AspNetPager分页控件使用方法（不使用DBAccess.cs文件）

一、前台显示界面代码Default.aspx（注意,代码运行环境是VS.2005）

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="Default4" %>

<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<title>用AspNetPager.dll控件的分页方法操作方法</title>

</head>

<body>

<div>

<asp:Repeater ID="Repeater1" runat="server">

<tr>

</tr>

</ItemTemplate>

</asp:Repeater>

</table>

</webdiyer:AspNetPager>

// NumericButtonCount="6" 显示页码的个数

// NumericButtonTextFormatString="[{0}]" 页码显示的格式

// ShowCustomInfoSection="left" 显示左边的（第几页、共几页、显示几条）

// TextBeforeInputBox="转到第" InputBox前面显示的字

// TextAfterInputBox="页" InputBox后面显示的字

// PagingButtonSpacing="10px" 字与字间的距离

</div>

</form>

</body>

</html>

二、Default.aspx.cs页面的代码

using System.Data.SqlClient;

public partial class Default : System.Web.UI.Page

{

//SqlConnection con = connsql.ZYJCreateConnection();

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

BindGrid();

}

private SqlConnection con;

//private string DBName = "tongjinet";

//创建连接对象并打开

public void Open()

{

if (con == null)

//con = new SqlConnection("server=(local);uid=sa;pwd=sql;database=" + DBName);

con = connsql.ZYJCreateConnection();

if (con.State == ConnectionState.Closed)

con.Open();

}

//创建一个命令对象并返回该对象

public SqlCommand CreateCommand(string sqlStr)

{

Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandType = CommandType.Text;

cmd.CommandText = sqlStr;

cmd.Connection = con;

return cmd;

}

//生成一个对象并返回该结果集第一行第一列

public object GetScalar(string sqlStr)

{

SqlCommand cmd = CreateCommand(sqlStr);

object obj = cmd.ExecuteScalar();

//CommadnBehavior.CloseConnection是将于DataReader的数据库链接关联起来

//当关闭DataReader对象时候也自动关闭链接

return obj;

}

//执行数据库查询并返回一个数据集 [当前页码,每页记录条数]

public DataSet GetCurrentPage(int pageIndex, int pageSize)

{

//设置导入的起始地址

int firstPage = pageIndex * pageSize;

string sqlStr = "select * from city order by city_id desc";

SqlCommand cmd = CreateCommand(sqlStr);

DataSet dataset = new DataSet();

SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);

dataAdapter.Fill(dataset, firstPage, pageSize, "city");

cmd.Dispose();

Close();

dataAdapter.Dispose();

return dataset;

}

//获得查询数据的总条数

public object GetAllCount()

{

string sqlStr = "select count(*) from city";

object obj = GetScalar(sqlStr);

return obj;

}

//关闭数据库

public void Close()

{

if (con != null)

{

con.Close();

}

//释放资源

public void Dispose()

{

if (con != null)

{

con.Dispose();

con = null;

}

protected void AspNetPager1_PageChanged(object sender, EventArgs e)

{

BindGrid();

}

public void BindGrid()

{

this.AspNetPager1.RecordCount = Int32.Parse(GetAllCount().ToString());

int pageIndex = this.AspNetPager1.CurrentPageIndex - 1;

int pageSize = this.AspNetPager1.PageSize = 5;

Repeater1.DataSource = GetCurrentPage(pageIndex, pageSize);

Repeater1.DataBind();

}