datalist的查询分页

SqlConnection con = new SqlConnection("Data Source=Localhost;Integrated Security=SSPI;Initial Catalog=news"); protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { String sql = "select * from news where remark=1"; con.Open(); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sql, con); da.Fill(ds,"news"); PagedDataSource objpage = new PagedDataSource(); //设置数据源 objpage.DataSource = ds.Tables["news"].DefaultView; //允许分页 objpage.AllowPaging = true; //设置每页显示的项数 objpage.PageSize = 5; int curpage; if (Request.QueryString["page"] != null) { curpage = Convert.ToInt32(Request.QueryString["page"]); } else { curpage = 1; } //设置当前页的索引 objpage.CurrentPageIndex = curpage - 1; //如果当前页不是首页 if (!objpage.IsFirstPage) {//上一页 InkPrev InkNext是页面上的HyperLink标签 InkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToString(curpage - 1); } if (!objpage.IsLastPage) {//下一页 InkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" + Convert.ToString(curpage + 1); } this.DataList1.DataSource = objpage; this.DataList1.DataBind(); con.Close(); } }