<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script language="C#" runat="server">
public void Page_Load(Object src, EventArgs e)
{
OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +
Server.MapPath("../App_Data/CorpMngData.mdb"));
OleDbDataAdapter objCommand = new OleDbDataAdapter("select * from back_MenuInfo where parentID = 0 and hidden = 0 order by menuOrder", objConn);
DataSet ds = new DataSet();
objCommand.Fill(ds);
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = ds.Tables[0].DefaultView;
objPds.AllowPaging = true;
objPds.PageSize = 2;
int CurPage;
if (Request.QueryString["Page"] != null)
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage = 1;
objPds.CurrentPageIndex = CurPage - 1;
lblCurrentPage.Text = "当前页：" + CurPage.ToString();
if (!objPds.IsFirstPage)
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
if (!objPds.IsLastPage)
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
Repeater1.DataSource = objPds;
Repeater1.DataBind();
}
</script>
<html>
<head>
<title>Repeater控件分页的例子</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
P,TD,DIV,SPAN {font-size:9pt}
</style>
</head>
<body>
<form id="Form1" name="form1" method="POST" runat="server">
<div style="padding: 5px; background-color: #dedede">
<asp:Label ID="lblCurrentPage" runat="server"></asp:Label>
<asp:HyperLink ID="lnkPrev" runat="server">上一页</asp:HyperLink>
<asp:HyperLink ID="lnkNext" runat="server">下一页</asp:HyperLink>
</div>
<hr size="1" color="#000099" />
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<div style="padding: 5px; background-color: #dedede">
<%# DataBinder.Eval(Container.DataItem, "menuName")%>
</div>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>
122
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
