具体不多说了，只贴出相关源码~

using system;
using system.collections.generic;
using system.text;
using system.data;
using system.data.oledb;
using system.web;

/**//// <summary>
/// 名称：access下的分页方案（仿sql存储过程）
/// 作者：cncxz(虫虫)
/// blog：http://cncxz.cnblogs.com
/// </summary>
public class adopager
{
    protected string m_connstring;
    protected oledbconnection m_conn;

    public adopager()
    {
        createconn(string.empty);
    }
    public adopager(string dbpath)
    {
        createconn(dbpath);
    }

    private void createconn(string dbpath)
    {
        if (string.isnullorempty(dbpath))
        {
            string str = system.configuration.configurationmanager.appsettings["dbpath"] as string;
            if (string.isnullorempty(str))
                str = "~/app_data/db.mdb";
            m_connstring = string.format(@"provider=microsoft.jet.oledb.4.0;data source={0}", httpcontext.current.server.mappath(str));
        }
        else
            m_connstring = string.format(@"provider=microsoft.jet.oledb.4.0;data source={0}", dbpath);

        m_conn = new oledbconnection(m_connstring);
    }
    /**//// <summary>
    /// 打开连接
    /// </summary>
    public void connopen()
    {
        if (m_conn.state != connectionstate.open)
            m_conn.open();
    }
    /**//// <summary>
    /// 关闭连接
    /// </summary>
    public void connclose()
    {
        if (m_conn.state != connectionstate.closed)
            m_conn.close();
    }

    private string recordid(string query, int passcount)
    {
        oledbcommand cmd = new oledbcommand(query, m_conn);
        string result = string.empty;
        u