为什么我的datagrid分页后显示的总是第一页的数据?
代码如下:
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("./") + "test.mdb");
OleDbCommand cmd=new OleDbCommand("select count(*) from news",conn);
DataSet DS=new DataSet();
OleDbDataAdapter DA=new OleDbDataAdapter();
DA.SelectCommand=cmd;
DA.Fill(DS,"count");
DGnews.VirtualItemCount =System.Convert.ToInt32(DS.Tables[0].Rows[0][0]);
bindDB();
}
}
void bindDB()
{
OleDbConnection conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("./") + "test.mdb");
OleDbCommand cmd=new OleDbCommand("select newsid,title from news order by newsid desc",conn);
conn.Open();
DataSet DS=new DataSet();
OleDbDataAdapter DA=new OleDbDataAdapter();
DA.SelectCommand=cmd;
DA.Fill(DS,"newsid");
DGnews.DataSource=DS.Tables[0].DefaultView;
DGnews.DataBind();
conn.Close();
}
public void DGPageIndex_Changed(Object sender, DataGridPageChangedEventArgs e)
{
DGnews.CurrentPageIndex = e.NewPageIndex;
bindDB();
}
无论点击第几页显示的都是开始的数据!请大虾帮忙!!