using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
RepeaterDataBind();
}
private void RepeaterDataBind()
...{
string connectionString = ConfigurationManager.ConnectionStrings["Northwind"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
// Configuration rootWebConfig =
conn.Open();
SqlDataAdapter Adapter = new SqlDataAdapter("select firstname, lastname from Employees", conn);
DataSet ds = new DataSet();
try
...{
Adapter.Fill(ds, "testTable");
PagedDataSource objPage = new PagedDataSource();
objPage.DataSource = ds.Tables["testTable"].DefaultView;
objPage.AllowPaging = true;
objPage.PageSize = 5; 软件开发网 www.mscto.com
int CurPage;
if(Request.QueryString["Page"] != null)
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage = 1;
objPage.CurrentPageIndex = CurPage - 1;
lblCurPage.Text = "当前第" + CurPage.ToString()+"页";
if(!objPage.IsFirstPage)
lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
if(!objPage.IsLastPage)
lnkNext.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
RepeaterPage.DataSource = objPage;
RepeaterPage.DataBind();
}
catch(Exception error)
...{
Response.Write(error.ToString());
}
finally
...{
conn.Close();
}
}
}