//关键翻页语句 //将sql语句变量清空(与上面的查询记录条数的sql变量复用) sqlstring = ""; if (ViewState["Quary"] != null && ViewState["Quary"].ToString().Trim() != "") { //如果是有查询条件 sqlstring = "select top "+pagesize +" * " +" from Tb_Menus " +" where [MenuID] not in " +" (select top "+pagesize * (pageindex-1)+" [MenuID] " +" from Tb_Menus " +" where " + ViewState["Quary"].ToString().Trim() +" order by MenuID asc) and " + ViewState["Quary"].ToString().Trim() +" order by MenuID asc"; } else {//如果是没有点 条件字来查询 sqlstring = "select top "+pagesize +" * " +" from Tb_Menus " +" where [MenuID] not in " +" (select top "+pagesize * (pageindex-1)+" [MenuID] " +" from Tb_Menus " +" order by MenuID asc) " +" order by MenuID asc"; } //取得页面显示的数据 dg_Modal.DataSource = DbHelperSQL.Query(sqlstring);//sqloper.dsFill(sqlstring); dg_Modal.DataBind();
//关键翻页语句 //将sql语句变量清空 sqlstring = "";if (ViewState["Quary"] != null && ViewState["Quary"].ToString().Trim() != "") { //如果是有查询条件 sqlstring = "select top "+pagesize +" * " +" from Tb_Menus " +" where [MenuID] not in " +" (select top "+pagesize * (pageindex-1)+" [MenuID] " +" from Tb_Menus " +" where " + ViewState["Quary"].ToString().Trim() +" order by MenuID asc) and " + ViewState["Quary"].ToString().Trim() +" order by MenuID asc"; } else {//如果是没有点 条件字来查询 sqlstring = "select top "+pagesize +" * " +" from Tb_Menus " +" where [MenuID] not in " +" (select top "+pagesize * (pageindex-1)+" [MenuID] " +" from Tb_Menus " +" order by MenuID asc) " +" order by MenuID asc"; } //取得页面显示的数据 dg_Modal.DataSource = DbHelperSQL.Query(sqlstring); dg_Modal.DataBind();
里面有例子可以看看
//将sql语句变量清空(与上面的查询记录条数的sql变量复用)
sqlstring = ""; if (ViewState["Quary"] != null && ViewState["Quary"].ToString().Trim() != "")
{ //如果是有查询条件
sqlstring = "select top "+pagesize
+" * "
+" from Tb_Menus "
+" where [MenuID] not in "
+" (select top "+pagesize * (pageindex-1)+" [MenuID] "
+" from Tb_Menus "
+" where " + ViewState["Quary"].ToString().Trim()
+" order by MenuID asc) and "
+ ViewState["Quary"].ToString().Trim()
+" order by MenuID asc";
}
else
{//如果是没有点 条件字来查询
sqlstring = "select top "+pagesize
+" * "
+" from Tb_Menus "
+" where [MenuID] not in "
+" (select top "+pagesize * (pageindex-1)+" [MenuID] "
+" from Tb_Menus "
+" order by MenuID asc) "
+" order by MenuID asc";
}
//取得页面显示的数据
dg_Modal.DataSource = DbHelperSQL.Query(sqlstring);//sqloper.dsFill(sqlstring);
dg_Modal.DataBind();
//将sql语句变量清空
sqlstring = "";if (ViewState["Quary"] != null && ViewState["Quary"].ToString().Trim() != "")
{ //如果是有查询条件
sqlstring = "select top "+pagesize
+" * "
+" from Tb_Menus "
+" where [MenuID] not in "
+" (select top "+pagesize * (pageindex-1)+" [MenuID] "
+" from Tb_Menus "
+" where " + ViewState["Quary"].ToString().Trim()
+" order by MenuID asc) and "
+ ViewState["Quary"].ToString().Trim()
+" order by MenuID asc";
}
else
{//如果是没有点 条件字来查询
sqlstring = "select top "+pagesize
+" * "
+" from Tb_Menus "
+" where [MenuID] not in "
+" (select top "+pagesize * (pageindex-1)+" [MenuID] "
+" from Tb_Menus "
+" order by MenuID asc) "
+" order by MenuID asc";
}
//取得页面显示的数据
dg_Modal.DataSource = DbHelperSQL.Query(sqlstring);
dg_Modal.DataBind();
{
//绑定分页控件
this.AspNetPager1.RecordCount = rowsTotal;//记录总数
this.AspNetPager1.PageSize = pageSize;//每页记录数 //绑定主控件
this.gv.DataSource = returnMyDataTable();//返回DataTable的方法,用不用存储过程自己随意
this.gv.DataBind();
}