ASP.NET中对DataList控件进行数据绑定并分页

dlBind方法为自定义的无返回值类型方法，该方法主要用来从数据库中查询出符合指定条件的记录，并绑定到DataList控件中，然后通过设置PagedDataSource类对象的AllowPaging属性为True，来实现DataList控件的分页功能。dlBind方法实现代码如下：

public void dlBind()

    {

        int curpage = Convert.ToInt32(this.labPage.Text);

        PagedDataSource ps = new PagedDataSource();

        sqlcon = new SqlConnection(strCon);

        sqlcon.Open();

        string sqlstr = "select a.*,b.* from tb_Card as a join tb_Module as b on a.ModuleID=b.ModuleID";

        SqlDataAdapter MyAdapter = new SqlDataAdapter(sqlstr, sqlcon);

        DataSet ds = new DataSet();

        MyAdapter.Fill(ds, "tb_Card");

        ps.DataSource = ds.Tables["tb_Card"].DefaultView;

        ps.AllowPaging = true; //是否可以分页

        ps.PageSize = 2; //显示的数量

        ps.CurrentPageIndex = curpage - 1; //取得当前页的页码

        this.lnkbtnUp.Enabled = true;

        this.lnkbtnNext.Enabled = true;

        this.lnkbtnBack.Enabled = true;

        this.lnkbtnOne.Enabled = true;

        if (curpage == 1)

        {

            this.lnkbtnOne.Enabled = false;//不显示第一页按钮

            this.lnkbtnUp.Enabled = false;//不显示上一页按钮

        }

        if (curpage == ps.PageCount)

        {

            this.lnkbtnNext.Enabled = false;//不显示下一页

            this.lnkbtnBack.Enabled = false;//不显示最后一页

        }

        this.labBackPage.Text = Convert.ToString(ps.PageCount);

        this.dlContent.DataSource = ps;

        this.dlContent.DataKeyField = "CardID";

        this.dlContent.DataBind();

        sqlcon.Close();

    }