浅谈mssql access数据库 top分页方法

            {
                //替换升降标识，分页所需
                bool flag = arrstrorders[i].indexof(” desc”, stringcomparison.ordinalignorecase) != -1;
                sbreverseorder.appendformat(“{0} {1}”, arrstrorders[i].remove(index), flag ? “asc” : “desc”);
            }
            else
            {
                sbreverseorder.appendformat(“{0} desc”, arrstrorders[i]);
            }
        }

        //计算总页数
        _pagesize = _pagesize == 0 ? _recordcount : _pagesize;
        int pagecount = (_recordcount + _pagesize – 1) / _pagesize;

        //检查当前页数
        if (_pageindex < 1)
        {
            _pageindex = 1;
        }
        else if (_pageindex > pagecount)
        {
            _pageindex = pagecount;
        }

        stringbuilder sbsql = new stringbuilder();
        //第一页时，直接使用top n，而不进行分页查询
        if (_pageindex == 1)
        {
            sbsql.appendformat(” select top {0} * “, _pagesize);
            sbsql.appendformat(” from ({0}) as t “, _safesql);
            sbsql.appendformat(” order by {0} “, sboriginalorder.tostring());
        }
        //最后一页时，减少一个top n
        else if (_pageindex == pagecount)
        {
            sbsql.append(” select * from “);