温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:AspNetPager7.02控件及Demo源码
当前文件:
AspNetPager/AccessDataSource/default.aspx[1K,2009-6-12 11:32:09],打开代码结构图
AspNetPager/AccessDataSource/default.aspx[1K,2009-6-12 11:32:09],打开代码结构图1<%@ Page Language="C#" AutoEventWireup="true" CodeFile="default.aspx.cs" Inherits="DataSources_PagedDataSrc" MasterPageFile="~/navpage.master" Title="AspNetPager示例—使用AccessDataSource"%> 2
3
<asp:Content runat="server" ID="content1" ContentPlaceHolderID="main"> 4
<div>该示例演示如何使用AspNetPager分页控件和AccessDataSource控件来对Access数据库中的数据进行分页,不需要使用存储过程。 5
</div> 6
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/NorthWnd.mdb" 7
SelectCommand="select orderid,orderdate,customerid,employeeID from orders order by orderid desc" CacheKeyDependency="ADS_Orders" EnableCaching="True" OnSelected="AccessDataSource1_Selected"></asp:AccessDataSource> 8
<br /> 9
<asp:Repeater ID="Repeater1" runat="server"> 10
<HeaderTemplate> 11
<table width="100%" border="1" cellspacing="0" cellpadding="4" style="border-collapse:collapse"> 12
<tr style="backGround-color:#CCCCFF"><th style="width:25%">订单编号</th><th style="width:25%">订单日期</th><th style="width:25%">客户编号</th><th style="width:25%">雇员编号</th></tr> 13
</HeaderTemplate> 14
<ItemTemplate> 15
<tr style="background-color:#FAF3DC"> 16
<td><%#DataBinder.Eval(Container.DataItem,"orderid")%></td> 17
<td><%#DataBinder.Eval(Container.DataItem,"orderdate","{0:d}")%></td> 18
<td><%#DataBinder.Eval(Container.DataItem,"customerid")%></td> 19
<td><%#DataBinder.Eval(Container.DataItem,"employeeid")%></td> 20
</tr> 21
</ItemTemplate> 22
<FooterTemplate> 23
</table> 24
</FooterTemplate> 25
</asp:Repeater> 26
<webdiyer:aspnetpager id="AspNetPager1" runat="server" horizontalalign="Center" onpagechanged="AspNetPager1_PageChanged" 27
width="100%"></webdiyer:aspnetpager> 28
</asp:Content>




