protected void dgStudent_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
dgStudent.CurrentPageIndex = e.NewPageIndex; DBAccess acc = new DBAccess(); //自己写的一个类里面是一些数据库操作的函数
string sqlstr = "select a.*,b.classname from studinfo a,classinfo b where a.stuclassid=b.classid order by stuId";
acc.BindDataGrid(sqlstr, dgStudent);
}
这样好象实现不了分页显示,但我看好多书 都是在这个事件里 写dgStudent.CurrentPageIndex = e.NewPageIndex; 然后绑定数据源的.
该如何实现分页显示呢?谢谢大家指教!!!
{
dgStudent.CurrentPageIndex = e.NewPageIndex; DBAccess acc = new DBAccess(); //自己写的一个类里面是一些数据库操作的函数
string sqlstr = "select a.*,b.classname from studinfo a,classinfo b where a.stuclassid=b.classid order by stuId";
acc.BindDataGrid(sqlstr, dgStudent);
}
这样好象实现不了分页显示,但我看好多书 都是在这个事件里 写dgStudent.CurrentPageIndex = e.NewPageIndex; 然后绑定数据源的.
该如何实现分页显示呢?谢谢大家指教!!!
string sqlstr = "select a.*,b.classname from studinfo a,classinfo b where a.stuclassid=b.classid order by stuId";
acc.BindDataGrid(sqlstr, dgStudent);
写对了吗?
写成 public void binddata(){
}
吧,再protected void dgStudent_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
dgStudent.CurrentPageIndex = e.NewPageIndex; binddata();
}
protected void dgStudent_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
{
dgStudent.CurrentPageIndex = e.NewPageIndex; dgStudent.DataBind();
}