一个关于分页的小问题，高分请教！着急啊！！！

[hlong001]

我用的dataGrid控件，用的内置的默认导航按钮的分页模式
可我运行时 点下一页时 页面显示为空了
我的代码如下：
private void Page_Load(object sender, System.EventArgs e)
{
where = "Colid="+Request.QueryString["cid"];
if (!IsPostBack)
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");
}


private void MyConnection(string MySql)
{
OleDbConnection conn = new OleDbConnection(Application["connstr"].ToString());
conn.Open();

OleDbDataAdapter MyCommand = new OleDbDataAdapter(MySql, conn);
DataSet ds = new DataSet();
MyCommand.Fill(ds, "CommInfo");

DataView dv = ds.Tables["CommInfo"].DefaultView;
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");
}

非常简单的代码 应该没什么错啊 我用的是access数据库 我打开首页 第一页的数据能显示
请教阿！！！！

[vzxq]

翻页后要再绑定一次数据源

[chmodyou]

看一下初始化函数InitializeComponent()中是否有这条语句:this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);

[sunnystar365]

private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
MyConnection();
}
}

private void MyConnection()
{
string where = "Colid="+Request.QueryString["cid"];
string MySql="Select * from CommInfo where "+where+" ORDER BY PubTime DESC
OleDbConnection conn = new OleDbConnection(Application["connstr"].ToString());
conn.Open();

OleDbDataAdapter MyCommand = new OleDbDataAdapter(MySql, conn);
DataSet ds = new DataSet();
MyCommand.Fill(ds, "CommInfo");

DataView dv = ds.Tables["CommInfo"].DefaultView;
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
MyConnection();
}

可以改为以上代码试一下。
如果还是没有显示，那就代码调试一下，看看PageIndexChanged事件会不会被执行

[singlepine]

http://singlepine.cnblogs.com/articles/281425.html

[swordragon]

private string where;

private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
where = "Colid="+Request.QueryString["cid"];
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");
}
}

private void MyConnection(string MySql)
{
OleDbConnection conn = new OleDbConnection(Application["connstr"].ToString());
conn.Open();

OleDbDataAdapter MyCommand = new OleDbDataAdapter(MySql, conn);
DataSet ds = new DataSet();
MyCommand.Fill(ds, "CommInfo");

DataView dv = ds.Tables["CommInfo"].DefaultView;
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;

where = "Colid="+Request.QueryString["cid"];
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");
}

[Anders_lt]

在PageIndexChanged 函数中要重新跟dataGrid 邦定

[swordragon]

如果刚才的代码不行的话：
private string where;

private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
where = "Colid="+Request.QueryString["cid"];
Session["Colid"] = where;
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");
}
}

private void MyConnection(string MySql)
{
OleDbConnection conn = new OleDbConnection(Application["connstr"].ToString());
conn.Open();

OleDbDataAdapter MyCommand = new OleDbDataAdapter(MySql, conn);
DataSet ds = new DataSet();
MyCommand.Fill(ds, "CommInfo");

DataView dv = ds.Tables["CommInfo"].DefaultView;
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;

//where = "Colid="+Request.QueryString["cid"];
where = Session["Colid"].ToString();
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");
}

[yefeihaha]

private int startIndex;
private void Page_Load(object sender, System.EventArgs e)
{
where = "Colid="+Request.QueryString["cid"];
if (!IsPostBack)

{ startIndex=0;
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");}
}


private void MyConnection(string MySql)
{
OleDbConnection conn = new OleDbConnection(Application["connstr"].ToString());
conn.Open();

OleDbDataAdapter MyCommand = new OleDbDataAdapter(MySql, conn);
DataSet ds = new DataSet();
MyCommand.Fill(ds, "CommInfo");

DataView dv = ds.Tables["CommInfo"].DefaultView;
DataGrid1.DataSource = dv;
DataGrid1.DataBind();
}

private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{ startIndex=e.NewPageIndex*DataGrid1.PageSize;
DataGrid1.CurrentPageIndex=e.NewPageIndex;
MyConnection("Select * from CommInfo where "+where+" ORDER BY PubTime DESC");
}

[活靶子哥哥]

分页事件内还要绑定

[wang790809]

把所有代码帖出来

[goody9807]

Try:

private void DataGrid1_PageIndexChanged(object source,
System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex=e.NewPageIndex;
MyConnection("Select * from CommInfo");
}

[纷享刘晨]

1、conn打开了，在最后要关闭掉
2、每次都new一个conn，不知道是不是这的问题

DataGrid的分页应该是假份页吧，每次取出全部结果集，然后返回一部分