ASP无组件分页实现思路及代码
发布时间：2013-06-02 18:08:43作者：知识屋
MVC下：
后台代码：
public ActionResult sys(string page)
{
if (page == null)
{
string sql = "select top 15 * from dingdinfo ORDER BY dingdh desc";
ViewData["ds"] = dr.resultSet(sql, "dingdinfo");
}
if (page != null)
{
int pageSL = Convert.ToInt32(page);
string sql = "select top 15 * from dingdinfo where id not in (select top " + (pageSL - 1) * 15 + " id from dingdinfo order by dingdh desc )ORDER BY dingdh desc";
ViewData["ds"] = dr.resultSet(sql, "dingdinfo");
}
//计算pageCount
string sql1 = "select * from dingdinfo";
int pageCount = dr.resultCount(sql1,"dingdinfo");
int Chu = Convert.ToInt32(pageCount / 15);
int yuS = Convert.ToInt32(pageCount % 15);
if (pageCount > 15)
{
int pageJG = Chu;
if (yuS != 0)
{
pageJG = Chu + 1;
ViewData["jg"] = pageJG;
}
else
{
ViewData["jg"] = pageJG;
}
}
return View();
}
页面显示：
JS代码：
<script type="text/javascript">
//分页
function Page(id) {
window.location = "/bookIndex/sys/?page=" + id;
}
</script>
HTML代码：
<td>
<% int count =Convert.ToInt32(ViewData["jg"]);
if (count != 0)
{
for (int i = 1; i <=count; i++)
{ %>
<a href = "#" onclick="Page(<%:i%>)"><%:i%></a>
<% }
}%>
</td>
页面最终效果：
后台代码：
复制代码代码如下:
public ActionResult sys(string page)
{
if (page == null)
{
string sql = "select top 15 * from dingdinfo ORDER BY dingdh desc";
ViewData["ds"] = dr.resultSet(sql, "dingdinfo");
}
if (page != null)
{
int pageSL = Convert.ToInt32(page);
string sql = "select top 15 * from dingdinfo where id not in (select top " + (pageSL - 1) * 15 + " id from dingdinfo order by dingdh desc )ORDER BY dingdh desc";
ViewData["ds"] = dr.resultSet(sql, "dingdinfo");
}
//计算pageCount
string sql1 = "select * from dingdinfo";
int pageCount = dr.resultCount(sql1,"dingdinfo");
int Chu = Convert.ToInt32(pageCount / 15);
int yuS = Convert.ToInt32(pageCount % 15);
if (pageCount > 15)
{
int pageJG = Chu;
if (yuS != 0)
{
pageJG = Chu + 1;
ViewData["jg"] = pageJG;
}
else
{
ViewData["jg"] = pageJG;
}
}
return View();
}
页面显示：
JS代码：
复制代码代码如下:
<script type="text/javascript">
//分页
function Page(id) {
window.location = "/bookIndex/sys/?page=" + id;
}
</script>
HTML代码：
复制代码代码如下:
<td>
<% int count =Convert.ToInt32(ViewData["jg"]);
if (count != 0)
{
for (int i = 1; i <=count; i++)
{ %>
<a href = "#" onclick="Page(<%:i%>)"><%:i%></a>
<% }
}%>
</td>
页面最终效果：
（免责声明：文章内容如涉及作品内容、版权和其它问题，请及时与我们联系，我们将在第一时间删除内容，文章内容仅供参考）
知识阅读
软件推荐
更多 >
-
1
通过Response.Flush()实现下载失败的解决方法2013-08-11
-
2
ASP程序员必备的知识
-
3
网站建设：ASP网站防范黑客技巧
-
4
ADO 存取数据库时如何分页显示
-
5
ASP中set与dim的区别(自己的理解)
-
6
为你的ASP程序作一个负载测试
-
7
ASP用户登录模块的设计
-
8
asp获取文件md5值
-
9
asp生成静态HTML(动态读取)
-
10
ASP.NET中获得URL重写前的原始地址
