我的DataList绑定数据后。我想用HyperLink来实现分页!
可是不知道咋回事?
我每页只让它显5个的!现在却把所有的都显示出来了! //分页
public void strpage()
{
int CurPage;
if (Request.QueryString["Page"] != null)
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage = 1;
string strCon = "server=(local);database=School;User Id=sa;pwd=sa;";
SqlConnection myConn=new SqlConnection(strCon);
//定义数据适配器
SqlDataAdapter oda=new SqlDataAdapter();
oda.SelectCommand=new SqlCommand ("Select * From GuestBook order by Id desc",myConn);
//创建数据集
DataSet ds =new DataSet();
//创建所有数集
oda.Fill(ds, "GuestBook");
PagedDataSource ps = new PagedDataSource();
ps.DataSource = ds.Tables["GuestBook"].DefaultView;
ps.AllowPaging = true;
//每个页面显示的留言数
ps.PageSize = 5;
this.onepage.Text = ps.PageSize.ToString();
//求留言总数
this.allmsg.Text = ps.DataSourceCount.ToString();
//ps.CurrentPageIndex = curPage - 1;
ps.CurrentPageIndex = CurPage - 1;
//求总页
this.allpage.Text = ps.PageCount.ToString();
this.allpage1.Text = ps.PageCount.ToString();
this.nowpage.Text = CurPage.ToString();
this.DataList1.DataSource = ps;
this.DataList1.DataBind();
//上一页
if (!ps.IsFirstPage)
prepage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
//下一页
if (!ps.IsLastPage)
nextpage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
}
可是不知道咋回事?
我每页只让它显5个的!现在却把所有的都显示出来了! //分页
public void strpage()
{
int CurPage;
if (Request.QueryString["Page"] != null)
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage = 1;
string strCon = "server=(local);database=School;User Id=sa;pwd=sa;";
SqlConnection myConn=new SqlConnection(strCon);
//定义数据适配器
SqlDataAdapter oda=new SqlDataAdapter();
oda.SelectCommand=new SqlCommand ("Select * From GuestBook order by Id desc",myConn);
//创建数据集
DataSet ds =new DataSet();
//创建所有数集
oda.Fill(ds, "GuestBook");
PagedDataSource ps = new PagedDataSource();
ps.DataSource = ds.Tables["GuestBook"].DefaultView;
ps.AllowPaging = true;
//每个页面显示的留言数
ps.PageSize = 5;
this.onepage.Text = ps.PageSize.ToString();
//求留言总数
this.allmsg.Text = ps.DataSourceCount.ToString();
//ps.CurrentPageIndex = curPage - 1;
ps.CurrentPageIndex = CurPage - 1;
//求总页
this.allpage.Text = ps.PageCount.ToString();
this.allpage1.Text = ps.PageCount.ToString();
this.nowpage.Text = CurPage.ToString();
this.DataList1.DataSource = ps;
this.DataList1.DataBind();
//上一页
if (!ps.IsFirstPage)
prepage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
//下一页
if (!ps.IsLastPage)
nextpage.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货