Repeater的一个分页，不知道效率怎样？

最新推荐文章于 2024-12-25 08:30:49 发布

原创最新推荐文章于 2024-12-25 08:30:49 发布 · 1k 阅读

本内容遵循CC 4.0 BY-SA版权协议

博客展示了ASP.NET中数据绑定与分页的实现代码。通过建立数据库连接，使用SqlDataAdapter填充DataSet，获取新闻数据。利用PagedDataSource进行分页处理，设置每页显示数量，根据当前页码调整导航链接，最后将数据绑定到Repeater控件上。

<asp:Repeater ID="Repeater1" runat="server">
    <Itemtemplate>
     <div style="padding:5px;background-color:#dedede">
      [<%# DataBinder.Eval(Container.DataItem, "uid") %>]
      <%# DataBinder.Eval(Container.DataItem, "Title") %> Posted AT :
      <%# DataBinder.Eval(Container.DataItem, "addtime") %>
     </div>
    </Itemtemplate>
   </asp:Repeater>

=====================================

  private void Page_Load(object sender, System.EventArgs e)
  {
//   //建立连接
//   System.Data.SqlClient.SqlConnection mConnection;
//   mConnection = new System.Data.SqlClient.SqlConnection();
//   mConnection.ConnectionString="Data Source = localhost;User ID=sa;Password=;Initial Catalog=News";
//   mConnection.Open();
//
//   //DataAdapter
//   System.Data.SqlClient.SqlCommand vCommand=mConnection.CreateCommand();
//   System.Data.SqlClient.SqlDataAdapter vAdapter = new System.Data.SqlClient.SqlDataAdapter();
//   vCommand.CommandText="SELECT * FROM [_news]"; // + "AND [NodeID]=" + iRootID.ToString();
//   vAdapter.SelectCommand=vCommand;

//   //DataSet
//   DataSet ds=new DataSet();
//   vAdapter.Fill(ds);

      Logic lg = new Logic();
      DataTable dt00 = lg.GetAllNews();
//      this.PagingRepeater1.DataSource = dt00;
//      this.PagingRepeater1.DataBind();

   PagedDataSource objPds = new PagedDataSource();
   objPds.DataSource = dt00.DefaultView;//ds.Tables[0].DefaultView;
   objPds.AllowPaging = true;
   objPds.PageSize = 10;
   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();
  }

标签