SqlConnection cn = new SqlConnection("Data Source=ROBIN//SqlExpress;Initial Catalog=Products;Integrated Security=True");
SqlCommand cmd=new SqlCommand("SELECT [Name], [ImageUrl] FROM [Information]",cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
//对PagedDataSource 对象的相关属性赋值
PagedDataSource Pds = new PagedDataSource();
Pds.DataSource = ds.Tables[0].DefaultView;
Pds.AllowPaging = true;
Pds.PageSize = 5;
int CurPage;
//当前页面从Page查询参数获取
if (Request.QueryString["Page"] != null)
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage = 1;
Pds.CurrentPageIndex = CurPage - 1;
lblCurrentPage.Text = "Page: " + CurPage.ToString();
if (!Pds.IsFirstPage)
lnkPrev.PostBackUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
if (!Pds.IsLastPage)
lnkNext.PostBackUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
//把PagedDataSource 对象赋给Repeater控件
DataList1.DataSource = Pds;
DataList1.DataBind();