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

class Program
{
        static void Main(string[] args)
        {
            OleDbConnection conn = new OleDbConnection();
            conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;
                                    Data Source=|DataDirectory|\dbdemo.accdb";
            conn.Open();

            string sql = "select * from student";
            OleDbCommand cmd   = new OleDbCommand(sql, conn);
            //查询返回数据读取器
            OleDbDataReader dr = cmd.ExecuteReader();
            //遍历数据读取器
            while (dr.Read())
            {
                var t1 = dr.GetValue(1);
                Console.WriteLine(t1);
            }
            conn.Close();
            Console.ReadLine();
        }
}