我把GRIDVIEW放在了继承了母版的页面中,点击查询显示第一页的时候可以正常显示,但点击其他页面后就查询不到数据了,跟踪了以下好像是下边的过程根本就没执行,那位老大给指点下啊,拜谢啦。
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
SetBind(); }
protected void SetBind()
{
DataSet ds = new DataSet();
OracleConnection Conn = new OracleConnection(SqlStr);
OracleCommand cmd = new OracleCommand(SqlStr, Conn);
OracleDataAdapter DataAdp = new OracleDataAdapter(cmd);
Conn.Open();
DataAdp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
DataAdp.Dispose();
ds.Dispose();
Conn.Dispose();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
SetBind(); }
protected void SetBind()
{
DataSet ds = new DataSet();
OracleConnection Conn = new OracleConnection(SqlStr);
OracleCommand cmd = new OracleCommand(SqlStr, Conn);
OracleDataAdapter DataAdp = new OracleDataAdapter(cmd);
Conn.Open();
DataAdp.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
DataAdp.Dispose();
ds.Dispose();
Conn.Dispose();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货