using System; using System.Data; using System.Configuration; using System.Collections; 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 Page : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { bind(); } } int pageCount;//总页数 int currentPage=1;//第定义当前页 void bind() { SqlConnection conn = new SqlConnection("server=.;database=pubs;uid=sa;pwd=123;"); string sqlStr = "select * from authors"; SqlDataAdapter sda = new SqlDataAdapter(sqlStr,conn); DataSet ds = new DataSet(); sda.Fill(ds,"pro"); //创建数据源 PagedDataSource pds=new PagedDataSource(); pds.DataSource = ds.Tables["pro"].DefaultView; //允许分页 pds.AllowPaging = true; //设置每页显示记录数 pds.PageSize = int.Parse(this.DropDownList1.SelectedItem.Value); //获取总页数 pageCount = pds.PageCount; this.Label1.Text = pageCount.ToString(); pds.CurrentPageIndex = currentPage-1; //当前页 this.Label2.Text = Convert.ToString(currentPage); //数据绑定 this.GridView1.DataSource = pds; this.GridView1.DataBind(); this.DataList1.DataSource = pds; this.DataList1.DataBind(); this.Repeater1.DataSource = pds; this.Repeater1.DataBind(); } protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e) { bind(); } /// <summary> /// 第一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button1_Click(object sender, EventArgs e) {//如果当前不是第一页的时候 if (this.Label2.Text == "1") { } else { currentPage = 1; bind(); } } /// <summary> /// 下一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button2_Click(object sender, EventArgs e) {//如果当前不是最后页的时候 if (this.Label1.Text == this.Label2.Text) { } else { currentPage = int.Parse(this.Label2.Text)+1; this.Label2.Text = currentPage.ToString(); bind(); } } /// <summary> /// 上一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button3_Click(object sender, EventArgs e) {//如果当前不是第一页的时候 if (this.Label2.Text != "1") { currentPage = int.Parse(this.Label2.Text) - 1; this.Label2.Text = currentPage.ToString(); bind(); } } /// <summary> /// 最后一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button4_Click(object sender, EventArgs e) {//如果当前不是最后一页的时候 if (this.Label1.Text != this.Label2.Text) { this.Label2.Text = this.Label1.Text; currentPage = int.Parse(this.Label2.Text); bind(); } } //页面跳转 protected void Button5_Click(object sender, EventArgs e) { currentPage = Convert.ToInt32(this.TextBox1.Text); bind(); } }