ASPNETPAGER分页控件问题

Question

DataList1.DataSource = il.view().Skip(AspNetPager1.StartRecordIndex - 1).Take(6);
为什么他分页出毛病啦， 一页不显示一页内容 而是随机显示的 怎么改呢？？
LINQ操作的

Answer 1

protected void Bind()
    {
       
            PagedDataSource ps = new PagedDataSource();
            SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
            con.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from tb_msgboard  ", con);
            DataSet ds = new DataSet();
            sda.Fill(ds, "tb_msgboard");
            ps.DataSource = ds.Tables["tb_msgboard"].DefaultView;
            ps.AllowPaging = true;
            ps.PageSize = 3;
            int curpage = Convert.ToInt32(this.labPage.Text.Trim());
            ps.CurrentPageIndex = curpage - 1;
            this.lnkbtnFist.Enabled = true;
            this.lnkbtnFront.Enabled = true;
            this.lnkbtnLast.Enabled = true;
            this.lnkbtnNext.Enabled = true;
            if (curpage == 1)
            {
                this.lnkbtnFist.Enabled = false;
                this.lnkbtnFront.Enabled = false;
            }
            this.labBackPage.Text = Convert.ToString(ps.PageCount);
            this.DataList1.DataKeyField = "id";
            DataList1.DataSource = ps;
            DataList1.DataBind();
            con.Close();
         }