一个基础的C#的ACCESS操作类

假设存在一个ACCESS数据库路径为“c:\db.mdb”，里面有一个表名叫student，并且已经有一个表格控件datagridview1，该类的使用例子如下： 
... 
using AccessDb; 
... 
            //初始化，载入数据库路径 
            AccessDbClass mydb = new AccessDbClass("c:\db.mdb"); 

            //返回符合SQL要求的DataTable，并且与控件dataGridView1绑定 
            DataTable dt = new DataTable(); 
            dt = mydb.SelectToDataTable(@"select * from student"); 
            this.dataGridView1.DataSource = dt; 

            //返回DataSet，其中包括一个符合SQL要求和给定名称的DataTable，并且与控件dataGridView1绑定 
            DataSet ds = new DataSet(); 
            ds = mydb.SelectToDataSet(@"select * from student","student"); 
            this.dataGridView1.DataSource = ds.Tables["student"];   
     
            //关闭数据库 
            mydb.Close(); 

public class AccessDbClass 
    ...{ 

        变量声明处#region 变量声明处 
        public OleDbConnection Conn; 
        public string ConnString;//连接字符串 
        #endregion 


        构造函数与连接关闭数据库#region 构造函数与连接关闭数据库 
        /** <summary> 
        /// 构造函数 
        /// </summary> 
        /// <param name="Dbpath">ACCESS数据库路径</param> 
        public AccessDbClass(string Dbpath) 
        ...{ 
            ConnString = "Provider=Microsoft.Jet.OleDb.4.0;Data Source=";

//Access2007及以上版本连接方式: Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\myFolder\myAccess2007file.accdb; Jet OLEDB:Database Password=MyDbPassword; 
            ConnString += Dbpath; 
            Conn = new OleDbConnection(ConnString); 
            Conn.Open(); 
        } 

        /** <summary> 
        /// 打开数据源链接 
        /// </summary> 
        /// <returns></returns>

  public OleDbConnection DbConn() 
        ...{ 
            Conn.Open(); 
            return Conn; 
        } 

        /** <summary> 
        /// 请在数据传递完毕后调用该函数，关闭数据链接。 
        /// </summary> 
        public void Close() 
        ...{ 
            Conn.Close(); 
        } 
        #endregion 


        数据库基本操作#region 数据库基本操作 
        /** <summary> 
        /// 根据SQL命令返回数据DataTable数据表, 
        /// 可直接作为dataGridView的数据源 
        /// </summary> 
        /// <param name="SQL"></param> 
        /// <returns></returns> 
        public DataTable SelectToDataTable(string SQL) 
        ...{ 
            OleDbDataAdapter adapter = new OleDbDataAdapter(); 
            OleDbCommand command = new OleDbCommand(SQL, Conn); 
            adapter.SelectCommand = command; 
            DataTable Dt = new DataTable(); 
            adapter.Fill(Dt);     
            return Dt; 
        } 

        /** <summary>

/// 根据SQL命令返回数据DataSet数据集，其中的表可直接作为dataGridView的数据源。 
        /// </summary> 
        /// <param name="SQL"></param> 
        /// <param name="subtableName">在返回的数据集中所添加的表的名称</param> 
        /// <returns></returns> 
        public DataSet SelectToDataSet(string SQL, string subtableName) 
        ...{ 
            OleDbDataAdapter adapter = new OleDbDataAdapter(); 
            OleDbCommand command = new OleDbCommand(SQL, Conn); 
            adapter.SelectCommand = command; 
            DataSet Ds = new DataSet(); 
            Ds.Tables.Add(subtableName); 
            adapter.Fill(Ds, subtableName); 
            return Ds; 
        } 

        /** <summary> 
        /// 在指定的数据集中添加带有指定名称的表，由于存在覆盖已有名称表的危险，返回操作之前的数据集。 
        /// </summary> 
        /// <param name="SQL"></param> 
        /// <param name="subtableName">添加的表名</param> 
        /// <param name="DataSetName">被添加的数据集名</param> 
        /// <returns></returns> 
        public DataSet SelectToDataSet (string SQL, string subtableName, DataSet DataSetName)

...{ 
            OleDbDataAdapter adapter = new OleDbDataAdapter(); 
            OleDbCommand command = new OleDbCommand(SQL, Conn); 
            adapter.SelectCommand = command; 
            DataTable Dt = new DataTable(); 
            DataSet Ds = new DataSet(); 
            Ds = DataSetName; 
            adapter.Fill(DataSetName, subtableName); 
            return Ds; 
        } 

        /** <summary> 
        /// 根据SQL命令返回OleDbDataAdapter， 
        /// 使用前请在主程序中添加命名空间System.Data.OleDb 
        /// </summary> 
        /// <param name="SQL"></param> 
        /// <returns></returns> 
        public OleDbDataAdapter SelectToOleDbDataAdapter(string SQL) 
        ...{ 
            OleDbDataAdapter adapter = new OleDbDataAdapter(); 
            OleDbCommand command = new OleDbCommand(SQL, Conn); 
            adapter.SelectCommand = command; 
            return adapter; 
        } 

        /** <summary> 
        /// 执行SQL命令，不需要返回数据的修改，删除可以使用本函数

  /// </summary> 
        /// <param name="SQL"></param> 
        /// <returns></returns> 
        public bool ExecuteSQLNonquery(string SQL) 
        ...{ 
            OleDbCommand cmd = new OleDbCommand(SQL, Conn); 
            try 
            ...{ 
                cmd.ExecuteNonQuery(); 
                return true; 
            } 
            catch 
            ...{ 
                return false; 
            } 
        }

        #endregion 
    } 
}

PS:本文来自：http://www.zxbc.cn/html/20070813/26070_6.html，转载请注明出处，请尊重作者劳动成果。