以上程序可以实现分页当是为什么要连续点击下两下分页按钮才能切换到下一页呢?正常情况下只点击一次就行的,请高手指点!!!protected OleDbConnection cn;
protected OleDbCommand cmd;
string strSql;
void Page_Load(object sender, EventArgs e)
{ strSql = "select * from table2";
cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = E:\\work\\MyWeb\\test.mdb");
cn.Open();
cmd = new OleDbCommand(strSql,cn);
OleDbDataAdapter dapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
dapter.Fill(ds,"Tab");
this.DataGrid1.DataSource = ds.Tables["Tab"];
this.DataGrid1.DataBind();
cn.Close();
}void DataGrid1_PageIndexChanged(object sender, DataGridPageChangedEventArgs e) {
DataGrid1.CurrentPageIndex = e.NewPageIndex;
}
protected OleDbCommand cmd;
string strSql;
void Page_Load(object sender, EventArgs e)
{ strSql = "select * from table2";
cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = E:\\work\\MyWeb\\test.mdb");
cn.Open();
cmd = new OleDbCommand(strSql,cn);
OleDbDataAdapter dapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
dapter.Fill(ds,"Tab");
this.DataGrid1.DataSource = ds.Tables["Tab"];
this.DataGrid1.DataBind();
cn.Close();
}void DataGrid1_PageIndexChanged(object sender, DataGridPageChangedEventArgs e) {
DataGrid1.CurrentPageIndex = e.NewPageIndex;
}
strSql = "select * from table2";
cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = E:\\work\\MyWeb\\test.mdb");
cn.Open();
cmd = new OleDbCommand(strSql,cn);
OleDbDataAdapter dapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
dapter.Fill(ds,"Tab");
this.DataGrid1.DataSource = ds.Tables["Tab"];
this.DataGrid1.DataBind();
cn.Close();}
DataGrid1.CurrentPageIndex = e.NewPageIndex;
DataGrid1.DataBind();
}
protected OleDbCommand cmd;
string strSql;
void Page_Load(object sender, EventArgs e)
{
if (!ispostback)
{
databind();
} }void DataGrid1_PageIndexChanged(object sender, DataGridPageChangedEventArgs e) {
DataGrid1.CurrentPageIndex = e.NewPageIndex;
databind();
}
proteced void databind()
{strSql = "select * from table2";
cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source = E:\\work\\MyWeb\\test.mdb");
cn.Open();
cmd = new OleDbCommand(strSql,cn);
OleDbDataAdapter dapter = new OleDbDataAdapter(cmd);
DataSet ds = new DataSet();
dapter.Fill(ds,"Tab");
this.DataGrid1.DataSource = ds.Tables["Tab"];
this.DataGrid1.DataBind();
cn.Close();}