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

                    }
                }
            }
        }
    }
}