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

            sbsql.appendformat(” from ({0}) as t “, _safesql);
            sbsql.appendformat(” order by {0} “, sbreverseorder.tostring());
            sbsql.append(” ) as t “);
            sbsql.appendformat(” order by {0} “, sboriginalorder.tostring());
        }

        return sbsql.tostring();
    }

    /// <summary>
    /// 获取记录总数sql语句
    /// </summary>
    /// <param name=”_n”>限定记录数</param>
    /// <param name=”_safesql”>sql查询语句</param>
    /// <returns>记录总数sql语句</returns>
    public static string createtopnsql(int _n, string _safesql)
    {
        return string.format(” select top {0} * from ({1}) as t “, _n, _safesql);
    }

    /// <summary>
    /// 获取记录总数sql语句
    /// </summary>
    /// <param name=”_safesql”>sql查询语句</param>
    /// <returns>记录总数sql语句</returns>
    public static string createcountingsql(string _safesql)
    {
        return string.format(” select count(1) as recordcount from ({0}) as t “, _safesql);
    }
}

您可能感兴趣的文章:Access 2000 数据库 80 万记录通用快速分页类Asp.net在线备份、压缩和修复Access数据库示例代码ASP.NET 连接ACCESS数据库的简单方法asp.net中获取新增加记录的ID Access版asp.net下Oracle,SQL Server,Access万能数据库通用类一个简答的Access下的分页asp.net代码asp.net访问Access数据库溢出错误asp.net(C#) Access 数据操作类asp.net access web.config deniedasp.net 数据库备份还原(sqlserver+access)asp.net access添加返回自递增id的实现方法asp.net和asp下ACCESS的参数化查询asp.net实现access数据库分页的方法