Wap页面使用asp.net中移动控件List分页

时间： 2021-07-31 作者：daque

一、创作一个类public class navigation{private string _sitename, _siteurl;public navigation(string sitename, string siteurl){_sitename = sitename;_siteurl = siteurl;}public string sitename { get { return _sitename; } }public string siteurl { get { return _siteurl; } }}

二、分页dbaccess mydb = new dbaccess();mydb.sqlstr = "select count(bookid) as totalid from szhotline where bkcity='" + bkcity + "' and atype=" + atype;dataset dstotal = mydb.readtable("szhotline");int counttotal = convert.toint32(dstotal.tables["szhotline"].rows[0]["totalid"].tostring()); //总记录数int totalpage = 0; //总页数if (counttotal % perpage == 0)totalpage = convert.toint16(counttotal/perpage);elsetotalpage = convert.toint16(counttotal/perpage) + 1;

int cp_n, cp_p; if (cur_page > 1)cp_p = cur_page - 1;elsecp_p = 1;

if (cur_page < totalpage)cp_n = cur_page + 1;elsecp_n = totalpage;

link_p.navigateurl = "szhotline.aspx?page_c=" + cp_p + "&bkcity=" + bkcity + "&atype=" + atype;link_n.navigateurl = "szhotline.aspx?page_c=" + cp_n + "&bkcity=" + bkcity + "&atype=" + atype;list1.datatextfield="sitename";list1.datavaluefield="siteurl";arraylist arr = new arraylist();mydb.sqlstr = "select top " + perpage + " * from (select top " + perpage*convert.toint16(cur_page) + " bookid,bookname from szhotline where atype=" + atype + " and bkcity='" + bkcity + "' order by bookid desc) order by bookid asc";dataset myds = mydb.readtable("szhotline");for (int i=0; i {string bkname = myds.tables["szhotline"].rows["bookname"].tostring().trim();string bkurl = "szhotdet.aspx?bookid=" + myds.tables["szhotline"].rows["bookid"].tostring().trim();arr.add(new navigation(bkname, bkurl));}list1.datasource = arr;list1.itemsaslinks = true;list1.databind ();

activeform = list;表明：其中dbaccess是自树立的安排数据库的类，由于数据库应用的是access。采用的分页采用了select top n * from (select * m from table order by id desc) order by id desc的方法，安置m，n两个参数分页。

Wap页面使用asp.net中移动控件List分页

相关推荐

推荐下载

热门阅览

最新排行