unidac连接access数据库

using System;
using System.Data.OleDb;

class Program
{
    static void Main()
    {
        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\path\\to\\your\\database.mdb";
        try
        {
            using (OleDbConnection connection = new OleDbConnection(connectionString))
            {
                connection.Open();
                Console.WriteLine("Connected to Access database successfully!");
            }
        }
        catch (Exception ex)
        {
            Console.WriteLine("Failed to connect to Access database: " + ex.Message);
        }
    }
}

string sql = "SELECT * FROM Users WHERE Username = ?";
using (OleDbCommand command = new OleDbCommand(sql, connection))
{
    command.Parameters.AddWithValue("@Username", "admin");
    using (OleDbDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            Console.WriteLine("User ID: " + reader["UserID"]);
            Console.WriteLine("Username: " + reader["Username"]);
        }
    }
}