ASP無組件分頁實現(xiàn)思路及代碼
更新時間:2013年05月28日 16:50:06 作者:
無組件分頁不可思議吧,看一看本文的效果就知道了,下面與大家分享下具體的實現(xiàn),感興趣的朋友可以參考下哈
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>
頁面最終效果:
后臺代碼:
復(fù)制代碼 代碼如下:
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代碼:
復(fù)制代碼 代碼如下:
<script type="text/javascript">
//分頁
function Page(id) {
window.location = "/bookIndex/sys/?page=" + id;
}
</script>
HTML代碼:
復(fù)制代碼 代碼如下:
<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>
頁面最終效果:

相關(guān)文章
Microsoft JET Database Engine(0x80004005)未指定錯誤的解決方法
今天在配置iis asp運行環(huán)境的時候提示Microsoft JET Database Engine(0x80004005)未指定錯誤,不過最后通過如下方法解決了,這里腳本之家小編特為大家分享下,方便需要的朋友2014-06-06asp中獲取當前頁面的地址與參數(shù)的函數(shù)代碼
asp中獲取當前頁面的地址與參數(shù)的函數(shù)代碼,經(jīng)常需要用得到,特整理下,方便需要的朋友。2011-01-01ASP ACCESS 日期操作語句小結(jié) By Stabx
ASP ACCESS 日期操作語句小結(jié) By Stabx...2006-10-10