C# 读取 Access

通过using语句实现非GC资源的自动回收。

还需要有try…catch…之类的异常检测语句，检测file.exist。

 

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

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

namespace ReadAccess
{
    class Program
    {
        static void Main(string[] args)
        {
            using (OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=school.mdb"))
            {
                conn.Open();

                string sql = "select * from sheet1 where student='stu2'";

                OleDbCommand command;

                command = new OleDbCommand(sql, conn);

                using (OleDbDataReader reader = command.ExecuteReader())
                {
                    //1次读取1个记录
                    while (reader.Read())
                    {

                        for (int i = 0; i < reader.FieldCount; i++)
                        {

                            Console.Write("{0} ", reader[i]);

                        }

                        Console.WriteLine();

                    }
                }
            }
        }
    }
}