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();
  }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值