using System; using System.Configuration; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GetData(); } } private void GetData() { int curPage = Convert.ToInt32(lblCurPage.Text); PagedDataSource pds = new PagedDataSource(); SqlConnection conn = new SqlConnection("server=(local);initial catalog=test;integrated security=true;"); SqlDataAdapter sda = new SqlDataAdapter("select bname ,bauthor from T_book", conn); DataSet ds = new DataSet(); sda.Fill(ds, "book"); pds.DataSource = ds.Tables["book"].DefaultView; pds.AllowPaging = true; pds.PageSize = 6; pds.CurrentPageIndex = curPage-1; this.lbtFirst.Enabled = true; this.lbtNext.Enabled = true; this.lbtPre.Enabled = true; this.lbtLast.Enabled = true; if (curPage == 1) { this.lbtFirst.Enabled = false; this.lbtPre.Enabled = false; } if (curPage == pds.PageCount) { this.lbtNext.Enabled = false; this.lbtLast.Enabled = false; } this.lblTotalPage.Text = Convert.ToString(pds.PageCount); this.DataList1.DataSource = pds; this.DataList1.DataBind(); } /// <summary> /// 首页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtFirst_Click(object sender, EventArgs e) { this.lblCurPage.Text = "1"; GetData(); } /// <summary> /// 下一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtNext_Click(object sender, EventArgs e) { this.lblCurPage.Text = (Convert.ToInt32(lblCurPage.Text) + 1).ToString(); GetData(); } /// <summary> /// 上一页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtPre_Click(object sender, EventArgs e) { this.lblCurPage.Text = (Convert.ToInt32(lblCurPage.Text) - 1).ToString(); GetData(); } /// <summary> /// 尾页 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtLast_Click(object sender, EventArgs e) { this.lblCurPage.Text = this.lblTotalPage.Text; GetData(); } }