OleDbConnection strConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + "員工信息.mdb" + ";Persist Security Info=False");
//建立數(shù)據庫引擎連接，注意數(shù)據表（后綴為.db）應放在DEBUG文件下
OleDbDataAdapter myda = new OleDbDataAdapter("select * from 雇員 ,strConnection);
//建立適配器，通過SQL語句去搜索數(shù)據庫
DataSet myds = new DataSet();
//建立數(shù)據集
myda.Fill(myds, "雇員");
//用FILL的方式將適配器已經連接好的數(shù)據表填充到數(shù)據集MYDS這張表
dataGridView1.DataSource = myds.Tables["聯(lián)系人ID"];
//用顯示控件來顯示表

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
namespace ConsoleApplication19
{ 
  class Program
  {
    static void Main(string[] args)
    {
      OleDbConnection mycon =null;
      OleDbDataReader myReader=null;
      try
      {
        string strcon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db4.mdb;";
        mycon = new OleDbConnection(strcon);
        mycon.Open();
        string sql = "select * from 雇員 ";
        OleDbCommand mycom = new OleDbCommand(sql, mycon);
        myReader = mycom.ExecuteReader();
        while (myReader.Read())
        {
          Console.WriteLine(myReader.GetString(0)+" "+myReader.GetDouble(1)+" "+myReader.GetString(2)+" "+myReader.GetString(3)+" "+myReader.GetString(4));
        }
      }
      finally
      {
        myReader.Close();
        mycon.Close();
      }
    }
  }
}