会员
周边
众包
新闻
博问
闪存
所有博客
当前博客
我的博客
我的园子
账号设置
简洁模式
...
退出登录
注册
登录
刺猬博客
::
首页
::
新随笔
::
联系
::
订阅
::
管理
公告
AspNETPager的用法
<
html
xmlns
="http://www.w3.org/1999/xhtml"
>
<
head
runat
="server"
>
<
title
>
无标题页
</
title
>
</
head
>
<
body
>
<
form
id
="form1"
runat
="server"
>
<
div
>
<
asp:DataList
ID
="DataList1"
runat
="server"
>
<
ItemTemplate
>
ProductName:
<
asp:Label
ID
="ProductNameLabel"
runat
="server"
Text
='<%#
Eval("ProductName") %
>
'>
</
asp:Label
><
br
/>
<
br
/>
</
ItemTemplate
>
</
asp:DataList
>
<
webdiyer:aspnetpager
id
="pager1"
runat
="server"
onpagechanged
="ChangePage"
></
webdiyer:aspnetpager
>
</
div
>
</
form
>
</
body
>
</
html
>
后置代码:default.aspx.cs
using
System;
using
System.Data;
using
System.Configuration;
using
System.Collections;
using
System.Web;
using
System.Web.Security;
using
System.Web.UI;
using
System.Web.UI.WebControls;
using
System.Web.UI.WebControls.WebParts;
using
System.Web.UI.HtmlControls;
using
cpp114.tools.oledb;
using
System.Data.OleDb;
using
Wuqi.Webdiyer;
public
partial
class
test_Default : System.Web.UI.Page
{
protected
OleDbConnection conn
=
new
OleDbConnection();
protected
OleDbCommand cmd
=
new
OleDbCommand();
protected
void
Page_Load(
object
sender, EventArgs e)
{
if
(
!
IsPostBack)
{
initdb();
conn.Open();
cmd.CommandText
=
"
select count(*) from t_product
"
;
pager1.RecordCount
=
(
int
)cmd.ExecuteScalar();
conn.Close();
BindData();
}
}
//
初始化连接对象
protected
void
initdb()
{
conn.ConnectionString
=
oledbtool.myConnStr
+
Server.MapPath(oledbtool.mydbName);
cmd.Connection
=
conn;
}
//
数据绑定
protected
void
BindData()
{
initdb();
OleDbDataAdapter sda
=
new
OleDbDataAdapter(
"
select * from t_product
"
,conn);
DataSet ds
=
new
DataSet();
//
sda.Fill(ds, 10, 10, "temptbl");
sda.Fill(ds, pager1.PageSize
*
(pager1.CurrentPageIndex
-
1
), pager1.PageSize,
"
temptbl
"
);
DataList1.DataSource
=
ds.Tables[
"
temptbl
"
];
DataList1.DataBind();
}
//
翻页事件
protected
void
ChangePage(
object
src, PageChangedEventArgs e)
{
pager1.CurrentPageIndex
=
e.NewPageIndex;
BindData();
}
}
posted on
2007-05-11 14:59
刺猬博客
阅读(
1065
) 评论(
5
)
编辑
收藏
举报
会员力量,点亮园子希望
刷新页面
返回顶部