- public partial class fenye : System.web.UI.Page
- {
- DBAccess db = new DBAccess();
- protected void Page_Load(object sender, EventArgs e)
- {
- if (!Page.IsPostBack)
- {
- BindGrid();
- }
- }
- protected void AspNetPager1_PageChanged(object sender, EventArgs e)
- {
- BindGrid();
- }
- public void BindGrid()
- {
- this.AspNetPager1.RecordCount = Int32.Parse(db.GetAllCount().ToString());
- int pageIndex = this.AspNetPager1.CurrentPageIndex - 1;
- int pageSize = this.AspNetPager1.PageSize = 2;
- Repeater1.DataSource = db.GetCurrentPage(pageIndex, pageSize);
- Repeater1.DataBind();
- }
- }
- //执行数据库查询并返回一个数据集 [当前页码,每页记录条数]
- public DataSet GetCurrentPage(int pageIndex, int pageSize)
- {
- //设置导入的起始地址
- int firstPage = pageIndex * pageSize;
- string sqlStr = "select * from Ticket order by TicketId desc";
- SqlCommand cmd = CreateCommand(sqlStr);
- DataSet dataset = new DataSet();
- SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
- dataAdapter.Fill(dataset, firstPage, pageSize, "Ticket");
- cmd.Dispose();
- Close();
- dataAdapter.Dispose();
- return dataset;
- }
- //获得查询数据的总条数
- public object GetAllCount()
- {
- string sqlStr = "select count(*) from Ticket";
- object obj = GetScalar(sqlStr);
- return obj;
- }
- //该片段来自于http://www.codesnippet.cn/detail/220420132926.html
来源: http://www.codesnippet.cn/detail/220420132926.html