.net操作access数据库

using System.Data.OleDb;

string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\path\to\your\database.accdb;";
using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    try
    {
        connection.Open();
        Console.WriteLine("Connected to the database.");
    }
    catch (Exception ex)
    {
        Console.WriteLine("Failed to connect to the database: " + ex.Message);
    }
}

string sql = "SELECT * FROM Users WHERE Username = @Username AND Password = @Password";
using (OleDbCommand command = new OleDbCommand(sql, connection))
{
    command.Parameters.AddWithValue("@Username", "admin");
    command.Parameters.AddWithValue("@Password", "password");

    using (OleDbDataReader reader = command.ExecuteReader())
    {
        while (reader.Read())
        {
            Console.WriteLine("User ID: " + reader["UserID"]);
        }
    }
}