没有合适的资源?快使用搜索试试~ 我知道了~
分页功能实现
需积分: 12 2 下载量 152 浏览量
2012-02-21
16:55:16
上传
评论
收藏 6KB TXT 举报
温馨提示
试读
5页
运用pagedatasource实现分页效果
资源推荐
资源详情
资源评论
private void GridViewBind()
{
string sql = "select A.ID,A.Style,A.WeekNum,A.DoubleClass, B.Class_Name,C.Course_Name,D.TeacherName ";
sql += " from tbl_JW_CourseBasic as A ";
sql += " left outer join tbl_SS_ClassManagement as B on A.ClassID=B.PK_Class_Num ";
sql += " left outer join tbl_SS_Curriculum as C on A.CoureseID=C.PK_Course_Num ";
sql += " left outer join tbl_RS_Teacher as D on A.TeacherID=D.PK_TeacherID ";
DataSet ds = Common.Query(sql);
int curPage = Convert.ToInt32(this.lblNoPage.Text.Trim());
PagedDataSource ps = new PagedDataSource();
string totalBar = ds.Tables[0].Rows.Count.ToString().Trim();
this.lblTotalBar.Text = totalBar;
ps.DataSource = ds.Tables[0].DefaultView;
ps.AllowPaging = true;
ps.PageSize = Convert.ToInt32(this.ddlBarPage.SelectedValue.ToString().Trim());
this.lkbPrevious.Enabled = true;
this.lkbNext.Enabled = true;
this.lkbHome.Enabled = true;
this.lkbLast.Enabled = true;
ps.CurrentPageIndex = curPage - 1;
int nobar = curPage * ps.PageSize;
this.lblNoBar.Text = nobar.ToString().Trim();
if (curPage == 1)
{
this.lkbPrevious.Enabled = false;
this.lkbHome.Enabled = false;
}
if (curPage == ps.PageCount)
{
this.lkbNext.Enabled = false;
{
string sql = "select A.ID,A.Style,A.WeekNum,A.DoubleClass, B.Class_Name,C.Course_Name,D.TeacherName ";
sql += " from tbl_JW_CourseBasic as A ";
sql += " left outer join tbl_SS_ClassManagement as B on A.ClassID=B.PK_Class_Num ";
sql += " left outer join tbl_SS_Curriculum as C on A.CoureseID=C.PK_Course_Num ";
sql += " left outer join tbl_RS_Teacher as D on A.TeacherID=D.PK_TeacherID ";
DataSet ds = Common.Query(sql);
int curPage = Convert.ToInt32(this.lblNoPage.Text.Trim());
PagedDataSource ps = new PagedDataSource();
string totalBar = ds.Tables[0].Rows.Count.ToString().Trim();
this.lblTotalBar.Text = totalBar;
ps.DataSource = ds.Tables[0].DefaultView;
ps.AllowPaging = true;
ps.PageSize = Convert.ToInt32(this.ddlBarPage.SelectedValue.ToString().Trim());
this.lkbPrevious.Enabled = true;
this.lkbNext.Enabled = true;
this.lkbHome.Enabled = true;
this.lkbLast.Enabled = true;
ps.CurrentPageIndex = curPage - 1;
int nobar = curPage * ps.PageSize;
this.lblNoBar.Text = nobar.ToString().Trim();
if (curPage == 1)
{
this.lkbPrevious.Enabled = false;
this.lkbHome.Enabled = false;
}
if (curPage == ps.PageCount)
{
this.lkbNext.Enabled = false;
资源评论
Jelena景
- 粉丝: 17
- 资源: 2
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功