asp.net设置每页显示的条数,但还是显示全部条数
在repeater中,设置每页显示条数,但还是把全部数据显示出来,
考虑是BindRepeater的问题,但是多次调试还是找不出答案,求解答。
(绑定) protected void BindToRepeater()
{
sql = "select * from T_Register order by F_RegisterTime desc";
DbDataAdapter da = cs.GetAdapter(sql);
DataSet ds = cs.GetDataSet(sql);
da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "task");
DataTable dt = ds.Tables["task"];
rpMember.DataSource = ds;
rpMember.DataBind();
}
(txtSeperate.Text是输入每页显示条数)
protected void btnSeperate_Click1(object sender, EventArgs e)
{
AspNetPager1.PageSize = Convert.ToInt32(txtSeperate.Text);
BindToRepeater();
}
求指点,。急