读取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();


       } 

转载于:https://www.cnblogs.com/zhjzwl/archive/2009/03/03/1402069.html