C#操作mdb数据库文件

迷南。 2022-06-08 12:25 315阅读 0赞

# 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;