分页取出
if (!IsPostBack) { SqlConnection con=new SqlConnection("Data Source=PC-201007141920//;Initial Catalog=db_sifuco;Integrated Security=True"); con.Open(); SqlCommand cmd=new SqlCommand("select * from table_admin",con); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(ds, Pager1.PageSize * (Pager1.CurrentPageIndex - 1), Pager1.PageSize, "test"); DataTable dt = ds.Tables["test"]; GridView1.DataSource = dt; Pager1.RecordCount =2; GridView1.DataBind(); } } protected void Pager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e) { Pager1.CurrentPageIndex = e.NewPageIndex; SqlConnection con = new SqlConnection("Data Source=PC-201007141920//;Initial Catalog=db_sifuco;Integrated Security=True"); con.Open(); SqlCommand cmd = new SqlCommand("select * from table_admin", con); DataSet ds = new DataSet(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmd; sda.Fill(ds, Pager1.PageSize * (Pager1.CurrentPageIndex - 1), Pager1.PageSize, "test"); GridView1.DataSource = ds.Tables["test"]; GridView1.DataBind(); }、、
全部取出
if (!IsPostBack) { ProductSystem productSystem = new ProductSystem(); List<Product> List_Product=productSystem.Get_Product(); PagedDataSource pds = new PagedDataSource(); pds.DataSource = List_Product; pds.AllowPaging = true; pds.PageSize = AspNetPager1.PageSize; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; AspNetPager1.RecordCount=List_Product.Count; GridView1.DataSource = pds; GridView1.DataBind(); } } protected void AspNetPager1_PageChanging(object src, Wuqi.Webdiyer.PageChangingEventArgs e) { AspNetPager1.CurrentPageIndex=e.NewPageIndex; ProductSystem productSystem = new ProductSystem(); List<Product> List_Product = productSystem.Get_Product(); PagedDataSource pds = new PagedDataSource(); pds.DataSource = List_Product; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; AspNetPager1.RecordCount = List_Product.Count; GridView1.DataSource = pds; GridView1.DataBind(); }