vs调用access数据库

using System.Data.OleDb;

string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\path\\to\\your\\database.mdb";
OleDbConnection connection = new OleDbConnection(connectionString);

try
{
    connection.Open();
    Console.WriteLine("Connected to Access database successfully!");
}
catch (Exception ex)
{
    Console.WriteLine("Failed to connect to Access database: " + ex.Message);
}
finally
{
    connection.Close();
}

string query = "SELECT * FROM YourTable";
OleDbCommand command = new OleDbCommand(query, connection);

try
{
    OleDbDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
        Console.WriteLine(reader["ColumnName"].ToString());
    }
}
catch (Exception ex)
{
    Console.WriteLine("Failed to execute query: " + ex.Message);
}
finally
{
    reader.Close();
}