分页功能 datalist

   if (!Page.IsPostBack)
        {
            using (SqlConnection conn = new SqlConnection
             (System.Configuration.ConfigurationManager
             .ConnectionStrings["ConnectionStr"].ConnectionString))
            {
                conn.Open();
                SqlDataAdapter sqladp = new SqlDataAdapter
                    ("SELECT [id], [title], [content] ,[createtime]  FROM [news]", conn);
                DataTable dt = new DataTable();
                sqladp.Fill(dt);
                PagedDataSource SQLpaged = new PagedDataSource();
                SQLpaged.DataSource = dt.DefaultView;
                SQLpaged.AllowPaging = true;
                SQLpaged.PageSize = 4;
                int this_Page;
                if (Request.QueryString["Page"] != null)
                    this_Page = Convert.ToInt32(Request.QueryString["Page"]);
                else
                    this_Page = 1;
                SQLpaged.CurrentPageIndex = this_Page - 1;
                Label1.Text = "当前页：" + this_Page.ToString() + "/" + SQLpaged.PageCount;
                if (!SQLpaged.IsFirstPage)
                    HyperLink1.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(this_Page - 1);
                if (!SQLpaged.IsLastPage)
                    HyperLink2.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(this_Page + 1);
                DataList1.DataSource = SQLpaged;
                DataList1.DataBind();
            }