DataGrid分页问题,点第2页等,都还显示原来的数据,怎么办?
我用的是
public static DataSet SelectWork()
{
OleDbCommand cmd = new OleDbCommand("select * from Works order by work_id desc",conn);
OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.SelectCommand = cmd;
DataSet ds = new DataSet();
conn.Open();
adapter.Fill(ds);
conn.Close();
return ds;
}
我这是样调用的:
DataOperator.ConnectDatebase();
this.DataGrid1.DataSource = DataOperator.SelectWork();
this.DataGrid1.DataBind();
我已经有了绑定
private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
this.DataGrid1.CurrentPageIndex = e.NewPageIndex;
this.BindGrid();
}
生成时没出错,但运行时,点击下一页总是显示原来的数据,改成页数,点第2页或其它页还是显示原来的数据
高手帮我一下吧,先谢了