using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class paging : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string sql2 = "select top 15 * from students ";
DataTable dt = SQLHelper.ExecuteDataTable(sql2);
Repeater1.DataSource = dt;
Repeater1.DataBind();
BindData();
}
}
private void BindData()
{
int pageSize = Convert.ToInt32(lbl每页数.Text);
int totalRecord = Convert.ToInt32(SQLHelper.ExecuteScalar("select count(*) from students"));
int currentPage = Convert.ToInt32(lbl当前页.Text);
lbl总页数.Text = Convert.ToString((totalRecord + pageSize - 1) / pageSize);
if (currentPage == 1)
{
string sql = "select top " + pageSize + " * from students";
DataTable dt = SQLHelper.ExecuteDataTable(sql);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
else
{
string t = (currentPage * pageSize - pageSize).ToString();
string sql1 = "select * from students order by sno offset " + t + "rows fetch next " + pageSize + " rows only";
DataTable dt = SQLHelper.ExecuteDataTable(sql1);
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
btnFrist.Enabled = true;
btnUp.Enabled = true;
btnDown.Enabled = true;
btnLast.Enabled = true;
if (currentPage == 1)
{
btnFrist.Enabled = false;
btnUp.Enabled = false;
}
else if (currentPage == Convert.ToInt32(lbl总页数.Text))
{
btnLast.Enabled = false;
btnDown.Enabled = false;
}
}
protected void btnFrist_Click(object sender, EventArgs e)
{
lbl当前页.Text = "1";
BindData();
}
protected void btnUp_Click(object sender, EventArgs e)
{
lbl当前页.Text = Convert.ToString(Convert.ToInt32(lbl当前页.Text) - 1);
BindData();
}
protected void btnDown_Click(object sender, EventArgs e)
{
lbl当前页.Text = Convert.ToString(Convert.ToInt32(lbl当前页.Text) + 1);
BindData();
}
protected void btnLast_Click(object sender, EventArgs e)
{
lbl当前页.Text = Convert.ToString(Convert.ToInt32(lbl总页数.Text));
BindData();
}
}