分页显示数据库东西代码

 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"