public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con =new SqlConnection("Data Source=(local);Database=img;Uid=sa;Pwd=sa;");
con.Open();
bg();
}
void bg() {
int curpage = Convert.ToInt32(this.labPage.Text);
PagedDataSource ps = new PagedDataSource();
SqlConnection con = new SqlConnection("Data Source=(local);Database=img;Uid=sa;Pwd=sa;");
con.Open();
string strcon = "select * from img";
SqlDataAdapter apter = new SqlDataAdapter(strcon, con);
DataSet ds = new DataSet();
apter.Fill(ds);
ps.DataSource = dr.Tables["img"].DefaultView;
ps.DataSource = "ds";
ps.AllowPaging = true;
ps.PageSize = 3
ps.CurrentPageIndex = curpage - 1;
this.btnBack.Enabled = true;
this.btnNext.Enabled = true;
this.btnOne.Enabled = true;
this.btnUp.Enabled = true;
if (curpage == 1)
{
this.btnOne.Enabled = false;
this.btnUp.Enabled = false;
}
if (curpage == ps.PageCount)
{
this.btnNext.Enabled = false;
this.btnBack.Enabled = false;
}
this.labBackPage.Text = Convert.ToString(ps.PageCount);
this.dList.DataSource = ps;
this.dList.DataKeyField = "id";
this.dList.DataBind();
con.Close();
}
protected void btnOne_Click(object sender, EventArgs e)
{
this.labPage.Text = 1;
this.dList();
}
protected void btnUp_Click(object sender, EventArgs e)
{
this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) - 1) ;
this.dList();
}
protected void btnNext_Click(object sender, EventArgs e)
{
this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) + 1) ;
this.dList();
}
protected void btnBack_Click(object sender, EventArgs e)
{
this.labPage.Text = this.labBackPage.Text;
this.dList();
}
}
前台页面要加个onclick时间如:OnClick="btnNext_Click"