C#操作mdb数据库文件

C#操作mdb数据库文件

源码如下：

namespace CSharpWindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private string _fileName;
        private string _connectionString;
        private OleDbConnection _odcConnection;

        private void button1_Click(object sender, EventArgs e)
        {
            //////////////////////////////////////////////////////////////根据IMEI 862075035979565 进行查找
            string exefilepath = System.IO.Directory.GetCurrentDirectory();
            string mdbfilepath = exefilepath + "\\M02C_KMD_ST2017040801_13000.MDB";
            string mdbFile = mdbfilepath;
            string strimei = "7762075035979565";
            //MAC在数据库文件中的名称
            string strMACSection = "";
            //IMEI在数据库文件中的名称
            string strIMEISection = "";
            //SN在数据库文件中的名称
            string strSNSection = "";

            DataTable dt = new DataTable();
            try
            {
                DataRow dr;
                this._fileName = mdbFile;
                this._connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + mdbFile + ";";
                //1、建立连接 C#操作Access之读取mdb 
                this._odcConnection = new OleDbConnection(this._connectionString);
                //2、打开连接 C#操作Access之读取mdb 
                this._odcConnection.Open();
                //建立SQL查询   
                OleDbCommand odCommand = _odcConnection.CreateCommand();
                //3、输入查询语句 C#操作Access之读取mdb  
                odCommand.CommandText = "select * from " + "SNTable";
                //建立读取   
                OleDbDataReader odrReader = odCommand.ExecuteReader();
                //查询并显示数据   
                int size = odrReader.FieldCount;
                for (int i = 0; i < size; i++)
                {
                    DataColumn dc;
                    string sstr = odrReader.GetName(i);
                    sstr.ToLower();
                    if (0==sstr.IndexOf("MAC"))
                    {
                        strMACSection = odrReader.GetName(i);
                    }
                    else if (0 == sstr.IndexOf("IMEI"))
                    {
                        strIMEISection = odrReader.GetName(i);
                    }
                    else if (0 == sstr.IndexOf("SN"))
                    {
                        strSNSection = odrReader.GetName(i);
                    }
                    else
                    {

                    }

                    dc = new DataColumn(odrReader.GetName(i));
                    dt.Columns.Add(dc);
                }
                while (odrReader.Read())
                {
                    dr = dt.NewRow();
                    for (int i = 0; i < size; i++)
                    {
                        string s1 = odrReader.GetName(i);
                        string s2 = odrReader[s1].ToString();
                        string s3 = odrReader[s1].ToString();
                        if (-1 != s1.IndexOf(strIMEISection) && -1 != s3.IndexOf(strimei))
                        {
                            //string strMAC = "MAC";
                            string s4 = odrReader[strMACSection].ToString();
                            //00:1E:C8:98:9C:F1
                            //string strSN = "SN";
                            string s5 = odrReader[strSNSection].ToString();
                            //M02C17051501447 

                            //关闭连接 C#操作Access之读取mdb  
                            odrReader.Close();
                            _odcConnection.Close();

                            return;
                        }
                        dr[s1] = s3;
                        //dr[odrReader.GetName(i)] =
                        //odrReader[odrReader.GetName(i)].ToString();
                    }
                    dt.Rows.Add(dr);
                }
                //关闭连接 C#操作Access之读取mdb  
                odrReader.Close();
                _odcConnection.Close();
                //success = true;
            }
            catch
            {
                //success = false;
            }            
        }
    }
}

C#操作mdb文件引用的库为

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