//列举其中两个方法
//方法一
//后台程序
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class gridview : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
AspNetPager1.CurrentPageIndex = 1;
this.bind();
}
public void bind()
{
string sqltrn = "select * from Orders";
SqlConnection con = db.reatesqlcon();
SqlDataAdapter sd = new SqlDataAdapter(sqltrn,con);
DataSet ds = new DataSet();
sd.Fill(ds);
DataView dv =ds.Tables[0].DefaultView;
this.AspNetPager1.RecordCount =dv.Count;
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
this.GridView1.DataSource = pds;
this.GridView1.DataBind();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
this.bind();
}
}
//方法二
private void RepeaterBind()
{
using (SqlConnection con = new SqlConnection("server=.;uid=sa;pwd=123;database=db_shopping"))
{
SqlDataAdapter da = new SqlDataAdapter("select * from tb_product", con);
DataSet ds = new DataSet();
da.Fill(ds);
AspNetPager1.RecordCount = ds.Tables[0].Rows.Count;
da.Fill(ds,AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"tbpager");
Repeater1.DataSource = ds.Tables["tbpager"].DefaultView;
Repeater1.DataBind();
}
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
RepeaterBind();
}