C# : ADO.NET 读取 Access mdb

mdb_ADO.cs 示例代码:

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

namespace mdb_ADO
{
    class Program
    {
        static void Main(string[] args)
        {
            string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb";
            OleDbConnection Conn = new OleDbConnection(connStr);
            Conn.Open(); 
            // get records from the table
            string sql = "Select * from [产品]";

            // create a text writer to the new file
            string wfile = "产品.txt";
            StreamWriter writer = new StreamWriter(wfile, false);
            
            // create the data set command object
            // and the DataReader
            OleDbCommand cmd = new OleDbCommand(sql, Conn); 
            OleDbDataReader DR = cmd.ExecuteReader();
            while (DR.Read())
            {
                writer.WriteLine(DR["产品名称"].ToString() +"\t"+ DR["供应商"].ToString());
            }
            DR.Close(); 
            Conn.Close();
            writer.Close();
        }
    }
}