[150504][C#]C#连接Access数据库并读取数据

public static void ReadData(string connectionString, string queryString)
{
    using (OleDbConnection connection = new OleDbConnection(connectionString))
    {
        OleDbCommand command = new OleDbCommand(queryString, connection);

        connection.Open();
        OleDbDataReader reader = command.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(reader[0].ToString());
        }
        reader.Close();
    }
}

上段代码需要引用以下命名空间

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

connectionString为连接字符串

string connectionString=@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=F:\Shop.accdb;"

Provider=Microsoft.ACE.OLEDB.12.0 适用于Access2007及以上版本

Data Source为数据库文件路径

queryString为标准SQL语句