Question

GridView分页处理问题

为什么这样绑定数据 要点击2次下一页 才会进到下一页
后台cs
protected void Page_Load(object sender, EventArgs e)
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = " Provider=SQLOLEDB;Data Source=.;Integrated Security=SSPI;Initial Catalog=高职院校素质教育管理系统";
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from Student_Product", conn);
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
conn.Close();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView gvw = (GridView)sender;
if (e.NewPageIndex < 0)
{
TextBox pageNum = (TextBox)gvw.BottomPagerRow.FindControl("txtNewPageIndex");
int Pa = int.Parse(pageNum.Text);
if (Pa <= 0)
{
gvw.PageIndex = 0;
}
else
{
gvw.PageIndex = Pa - 1;
}
}
else
{
gvw.PageIndex = e.NewPageIndex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Bind();
}
}

private void Bind()
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = " Provider=SQLOLEDB;Data Source=.;Integrated Security=SSPI;Initial Catalog=高职院校素质教育管理系统";
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from Student_Product", conn);
DataTable dt = new DataTable();
da.Fill(dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
conn.Close();

}

如果改成这样的话 就不能分页了

Answer 1

protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Bind();
}
}
private void Bind()
{
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString = " Provider=SQLOLEDB;Data Source=.;Integrated Security=SSPI;Initial Catalog=高职院校素质教育管理系统";
conn.Open();
OleDbDataAdapter da = new OleDbDataAdapter("select * from Student_Product", conn);
DataTable dt = new DataTable();
da.Fill(dt);
this.GridView1.DataSource = dt;
this.GridView1.DataBind();
conn.Close();

}

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView gvw = (GridView)sender;
if (e.NewPageIndex < 0)
{
TextBox pageNum = (TextBox)gvw.BottomPagerRow.FindControl("txtNewPageIndex");
int Pa = int.Parse(pageNum.Text);
if (Pa <= 0)
{
gvw.PageIndex = 0;
}
else
{
gvw.PageIndex = Pa - 1;
}
}
else
{
gvw.PageIndex = e.NewPageIndex;
Bind();

}
}

这样试试。。。

Answer 2

pageload里面
加
if(!ispostback)
{
绑定方法
}

Answer 3

没有加 ispostback 重载了. .