C#操作Access之读取mdb

转载来自http://blog.csdn.net/chelen_jak/article/details/65629418

using System.Data;  
using System.Data.OleDb;  

        private class MDBHelp  
        {  
            private string _fileName;  
            private string _connectionString;  
            private OleDbConnection _odcConnection;  


            /// <summary>  
            /// 构建函数  
            /// </summary>  
            /// <param name="fileName">MDB文件（含完整路徑）</param>  
            public MDBHelp(string fileName)  
            {  
                this._fileName = fileName;  
                this._connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";";  
            }  


            /// <summary>  
            /// 建立连接（打开数据库文件）  
            /// </summary>  
            public void Open()  
            {  
                try  
                {  
                    // 建立连接  
                    this._odcConnection = new OleDbConnection(this._connectionString);  


                    // 打开连接  
                    this._odcConnection.Open();  
                }  
                catch (Exception)  
                {  
                    throw new Exception("嘗試打开 " + this._fileName + " 失敗, 請確認文件是否存在！");  
                }  
            }  


            /// <summary>  
            /// 断开连接（关闭据库文件）  
            /// </summary>  
            public void Close()  
            {  
                this._odcConnection.Close();  
            }  


            /// <summary>  
            /// 根据sql命令返回一个DataSet  
            /// </summary>  
            /// <param name="sql">sql命令</param>  
            /// <returns>以DataTable形式返回数据</returns>  
            public DataSet GetDataSet(string sql)  
            {  
                DataSet ds = new DataSet();  


                try  
                {  
                    OleDbDataAdapter adapter = new OleDbDataAdapter(sql, this._odcConnection);  
                    adapter.Fill(ds);  
                }  
                catch (Exception)  
                {  
                    throw new Exception("sql語句： " + sql + " 執行失敗！");  
                }  


                return ds;  
            }  
        }     

调用方法

string mdbFile = "p:\\EvenYYMM.mdb";           //默認路徑  

MDBHelp mdbHelp = new MDBHelp(mdbFile);  
try  
{  
    mdbHelp.Open();     // 打開數據庫  

    var ds1 = mdbHelp.GetDataSet("select count(*) as n1 from even where id > " + last_id.ToString());  

    var ds = mdbHelp.GetDataSet("select to 10 * from even where Id >= 100 order by id");  

    mdbHelp.Close();    // 關閉數據庫  
}  
finally  
{  
    mdbHelp = null;  
}