Repeater控件分页例子(ASP.NET 2.0) [转载]

原文地址 http://www.aspxclub.com/l11/c_3549.html

 1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Web;
 5using System.Web.Security;
 6using System.Web.UI;
 7using System.Web.UI.WebControls;
 8using System.Web.UI.WebControls.WebParts;
 9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11
12public partial class _Default : System.Web.UI.Page 
13{
14    protected void Page_Load(object sender, EventArgs e)
15    {
16        if (!IsPostBack)
17            RepeaterDataBind();
18    }
19
20    private void RepeaterDataBind()
21    {
22               string connectionString = ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString;
23               SqlConnection conn = new SqlConnection(connectionString);
24       // Configuration rootWebConfig =
25        conn.Open();
26        SqlDataAdapter Adapter = new SqlDataAdapter("select firstname, lastname from Employees", conn);
27        DataSet ds  = new DataSet();
28        try
29        {
30            Adapter.Fill(ds, "testTable");
31            PagedDataSource objPage = new PagedDataSource();
32            objPage.DataSource = ds.Tables["testTable"].DefaultView;
33            objPage.AllowPaging = true;
34            objPage.PageSize = 5;
35            int CurPage;
36            if(Request.QueryString["Page"] != null)
37                CurPage = Convert.ToInt32(Request.QueryString["Page"]);
38            else
39                CurPage = 1;
40            objPage.CurrentPageIndex = CurPage - 1;
41            lblCurPage.Text = "当前第" + CurPage.ToString()+"页";
42
43            if(!objPage.IsFirstPage)
44                lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
45            if(!objPage.IsLastPage)
46                lnkNext.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
47            RepeaterPage.DataSource = objPage;
48            RepeaterPage.DataBind();
49
50        }
51        catch(Exception error)
52        {
53            Response.Write(error.ToString());
54        }
55        finally
56        {
57            conn.Close();
58        }
59    }
60}
61