1 下载ASPNetPage.dll文件
2 引用这个文件到工具箱
3 拉一gridview 在页面上引用这个控件
4 cs写
public partial class _Default : System.Web.UI.Page
{
string str = System.Configuration.ConfigurationManager.ConnectionStrings["zb_oldConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
bind();
}
}
public void bind()
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = str;
conn.Open();
DataSet ds = new DataSet();
string sqlstr = "select * from BDO_Employee";
SqlDataAdapter da = new SqlDataAdapter(sqlstr,conn);
da.Fill(ds, "BDO_Employee");
GridView1.AllowPaging = true;
GridView1.DataSource = ds;
GridView1.DataBind();
conn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
this.GridView1.PageIndex = e.NewPageIndex;
bind();
Wuqi.Webdiyer.AspNetPager pager = AspNetPager1 as Wuqi.Webdiyer.AspNetPager;
pager.CurrentPageIndex = e.NewPageIndex;
pager.PageSize = 10;
}
}