简单的一个自定义分页（C#）

最新推荐文章于 2022-06-09 18:28:09 发布

tlw1112

最新推荐文章于 2022-06-09 18:28:09 发布

阅读量526

点赞数

文章标签： c# hyperlink dataset asp button microsoft

本文链接：https://blog.csdn.net/tlw1112/article/details/1957755

版权

using System.Data.OleDb;

private void Page_Load(object sender, System.EventArgs e)
  {
   // 在此处放置用户代码以初始化页面
   OleDbConnection objConn=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:/test.mdb");
   OleDbDataAdapter objCommand=new OleDbDataAdapter("select * from Users",objConn);
   DataSet ds=new DataSet();
   objCommand.Fill(ds);

   //对PagedDataSource 对象的相关属性赋值
   PagedDataSource objPds = new PagedDataSource();
   objPds.DataSource = ds.Tables[0].DefaultView;
   objPds.AllowPaging = true;
   objPds.PageSize = 5;
   int CurPage;

   //当前页面从Page查询参数获取
   if (Request.QueryString["Page"] != null)
    CurPage=Convert.ToInt32(Request.QueryString["Page"]);
   else
    CurPage=1;

objPds.CurrentPageIndex = CurPage-1;
Label1.Text = "Page: " + CurPage.ToString();

if (!objPds.IsFirstPage)
HyperLink2.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage-1);

if (!objPds.IsLastPage)
HyperLink1.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurPage+1);

   //把PagedDataSource 对象赋给Repeater控件
   DataList1.DataSource=objPds;
   DataList1.DataBind();
  }
  -------------------------------------------------------------------------------------
  <%@ Page language="c#" Codebehind="WebForm1.aspx.cs" AutoEventWireup="false" Inherits="WebApplication1.WebForm1" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
  <title>WebForm1</title>
  <meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
  <meta name="CODE_LANGUAGE" Content="C#">
  <meta name="vs_defaultClientScript" content="JavaScript">
  <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
</HEAD>
<body>
  <form id="Form1" method="post" runat="server">
   <FONT face="宋体">
    <P>
     <asp:Button id="Button1" runat="server" Text="Button"></asp:Button>
     <asp:HyperLink id="HyperLink1" runat="server">qianjin</asp:HyperLink>
     <asp:Label id="Label1" runat="server">Label</asp:Label>
     <asp:HyperLink id="HyperLink2" runat="server">huotui</asp:HyperLink></P>
    <P>
     <asp:DataList id="DataList1" runat="server">
      <ItemTemplate>
       <asp:Label id="Label2" runat="server"><%# DataBinder.Eval(Container.DataItem, "姓名") %>
</asp:Label>
      </ItemTemplate>
     </asp:DataList></P>
   </FONT>
   <asp:Repeater id="Repeater1" runat="server"></asp:Repeater>
  </form>
</body>
</HTML>

tlw1112

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
简单的一个自定义分页（C#）

using System.Data.OleDb;private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 OleDbConnection objConn=new OleDbConnection (@"Provider=Microsoft.Jet.OLEDB.4.0; Data Sour
复制链接

扫一扫