using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Data;using System.Data.OleDb;namespace GBQ.Lidar.AMS.Utils{    public class MDBHelper    {        private string _fileName;        private string _connectionString;        private OleDbConnection _odcConnection;        /// 
         /// 构建函数         /// 
         /// MDB文件夹的位置         public MDBHelper(string fileName)        {            this._fileName = fileName;            this._connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";";        }        /// 
         /// 打开数据库        /// 
         public void Open()        {            try            {                this._odcConnection = new OleDbConnection(this._connectionString);                this._odcConnection.Open();            }            catch (Exception)            {                throw new Exception("尝试打开" + this._fileName + "失败，请确认该日期是否是工作日！");            }        }        /// 
         /// 断开链接（关闭数据库文件）        /// 
         public void Close()        {            this._odcConnection.Close();        }        /// 
         /// 根据SQL命令返回一个dataSet        /// 
         /// sql/param>         /// 
     
      DataTable
              public DataTable GetDataSet(string sql)        {            DataTable ds = new DataTable();            try            {                OleDbDataAdapter adapter = new OleDbDataAdapter(sql, this._odcConnection);                adapter.Fill(ds);            }            catch (Exception)            {                throw new Exception("sql语句：" + sql + " 执行失败！");            }            return ds;        }    }}

直接调用即可