AspNetPager分页控件,我不想用存储过程,怎 么绑定DataGrid啊
有代码吗,有高手吗,
有代码吗,有高手吗,
解决方案 »
- 这个查询怎么实现呢……
- 根据正则表达式获取内容
- 急!!!CS0246: 找不到类型或命名空间名称“Db”(是否缺少 using 指令或程序集引用?) 请各位帮帮忙!!3Q
- asp.net导航问题
- ASP.NET MVC电影网站更新了!
- 复杂的页面跳转传参问题 o(∩_∩)o...哈哈
- 关于遮挡层?
- RegisterStartupScript註冊的腳本為什麼有些機器可以打開,有些打不開
- vs.net 2003 树形控件不能安装
- 网站建好后,如何弄安装页面?
- 在GridView中动态为PagerTemplate添加LinkButton,但是无法为LinkButton绑定事件
- 请问这段vb代码在.net中怎么实现?
里面有例子可以看看
//将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();
}