c# 读取Access数据库资料

 

 //读取Access需使用OLEDB
using System.Data.OleDb;

 

        /// <summary>

        /// 读取Access数据库
        /// </summary>
        private void ReadAccessData()
        {
            //1、建立连接

            string sAccessConnection

 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\BegVCSharp\ReaderAccess\ReaderAccess\nwind.mdb";

 

 

            OleDbConnection odcConnection = new OleDbConnection(sAccessConnection);
            //2、打开连接
            odcConnection.Open();

            //建立SQL查询
            OleDbCommand odCommand = odcConnection.CreateCommand();
            //3、输入查询语句
            odCommand.CommandText = "select customerID,companyName from Customers";

            //建立读取
            OleDbDataReader odrReader = odCommand.ExecuteReader();

            //查询并显示数据
            while (odrReader.Read())
            {
                //显示取出值(具体显示方式可由自己定义)
                tbValue.Text += "\r\t";
                tbValue.Text += odrReader["CustomerID"].ToString().PadRight(10, ' ');
                tbValue.Text += odrReader["CustomerID"].ToString();
            }

            //关闭连接
            odrReader.Close();

            odcConnection.Close();

 

       }