一个donet下的access操作类，主要用于WinForm

using System;
using System.Data;
using System.Configuration;
using System.Data.OleDb;
using System.Windows.Forms;

/// <summary>
/// accessDatabase 的摘要说明
/// </summary>
public class accessDatabase
{
    public accessDatabase()
    {
    }

    private static string datapatch =Application.StartupPath + "//data.mdb";//数据库地址
    private static OleDbConnection _myConnection = new OleDbConnection(GetConnectionString());

    public static string GetConnectionString()
    {
        return "Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + datapatch;
    }

    private static OleDbConnection myConnection
    {
        get
        {
            if (_myConnection.State != ConnectionState.Open)
            {
                _myConnection.Close();
                _myConnection.Open();
            }
            return _myConnection;
        }
    }

    public static void myClose()
    {
        try
        {
            _myConnection.Close();
        }
        catch { }
    }
    /// 取得dataset
    /// 查询语句
    public static DataSet GetDataSet(string Commandtext)
    {
        string strCommandText = Commandtext;
        DataSet myDataset = null;
        try
        {
            OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText, myConnection);
            OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);
            myDataset = new DataSet();
            myAdpater.Fill(myDataset);
        }
        catch { }
        return myDataset;
    }
   
    /// 取得表
   /// 查询语句
    public static DataTable GetDataTable(string Commandtext)
    {
        string strCommandText =Commandtext;
        DataTable mytable = null;
        try
        {
            OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText, myConnection);
            OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);
            DataSet myDataset = new DataSet();
            myAdpater.Fill(myDataset);
            mytable = myDataset.Tables[0];
        }
        catch { }
        return mytable;
    }

    /// <summary>
    /// 返回分页表
    /// </summary>
    /// <param name="Commendtext"></param>
    /// <param name="PageIndex"></param>
    /// <returns></returns>
    public static DataTable GetDataTable(string Commandtext,int PageIndex,int PageSize)
    {
        string strCommandText =Commandtext;
        DataTable mytable = null;
        try
        {
            OleDbDataAdapter myAdpater = new OleDbDataAdapter(strCommandText, myConnection);
            OleDbCommandBuilder myBuilder = new OleDbCommandBuilder(myAdpater);
            DataSet myDataset = new DataSet();
            myAdpater.Fill(myDataset,PageIndex*PageSize,PageSize,"Table1");
            mytable = myDataset.Tables["Table1"];
        }
        catch { }
        return mytable;
    }

    /// <summary>
    /// 获取查询语句返回的记录总数
    /// </summary>
    /// <param name="pSQL"></param>
    /// <returns></returns>
    public static int GetRecordCount(string pSQL)
    {
        DataView dv = GetDataTable(pSQL).DefaultView;
        if (dv == null)
        {
            return 0;
        }
        else
        {
            return dv.Count;
        }
    }
    /// <summary>
    /// 获取查询语句第一行第一列的值
    /// </summary>
    /// <param name="pSQL"></param>
    /// <returns></returns>
    public static object GetOneValue(string pSQL)
    {
        OleDbCommand a_oCommand = new OleDbCommand();
        object a_oReturn = null;
        try
        {
            a_oCommand.Connection = myConnection;
            a_oCommand.CommandText = pSQL;
            a_oReturn = a_oCommand.ExecuteScalar();
        }
        catch { }

        return a_oReturn;
    }
    /// <summary>
    /// 执行无返回值的SQL语句
    /// </summary>
    /// <param name="strSQL"></param>
    /// <returns></returns>
    public static string ExecuteNonSQL(string strSQL)
    {
        OleDbCommand a_oCommand = new OleDbCommand();
        string result = string.Empty;
        try
        {
            a_oCommand.Connection = myConnection;
            a_oCommand.CommandText = strSQL;
            a_oCommand.ExecuteNonQuery();
        }
        catch(Exception ex)
        {
            result = ex.Message;
        }
        return result;
    }

    /// <summary>
    /// 将字符串转换为SQL字符串
    /// </summary>
    /// <param name="pStr"></param>
    /// <returns></returns>
    public static string StrToSQL(string pStr)
    {
        pStr = pStr.Trim();
        pStr = pStr.Replace("'", "''");
        return "'" + pStr + "'";
    }
    public static string StrToSQL(DateTime pDateTime)
    {
        return "#" + pDateTime.ToString("yyyy-MM-dd HH:mm:ss") + "#";
    }
    public static string StrToSQL(DateTime pDateTime, string pFormat)
    {
        return "#" + pDateTime.ToString(pFormat) + "#";
    }
    public static string StrToSQL(object pObj)
    {
        return "'" + pObj + "'";
    }
   
}