Repeater的一个分页,不知道效率怎样?

王朝asp·作者佚名  2006-01-09
窄屏简体版  字體: |||超大  

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

}

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航