用C#在Visual Studio中实现Access数据库的插入、更新和删除

using System.Data.OleDb;

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb";
string insertQuery = "INSERT INTO TableName (Column1, Column2) VALUES (@Value1, @Value2)";

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    connection.Open();
    
    using (OleDbCommand command = new OleDbCommand(insertQuery, connection))
    {
        command.Parameters.AddWithValue("@Value1", value1);
        command.Parameters.AddWithValue("@Value2", value2);
        
        command.ExecuteNonQuery();
    }
}

using System.Data.OleDb;

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb";
string updateQuery = "UPDATE TableName SET Column1 = @Value1, Column2 = @Value2 WHERE ID = @ID";

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    connection.Open();
    
    using (OleDbCommand command = new OleDbCommand(updateQuery, connection))
    {
        command.Parameters.AddWithValue("@Value1", newValue1);
        command.Parameters.AddWithValue("@Value2", newValue2);
        command.Parameters.AddWithValue("@ID", recordID);
        
        command.ExecuteNonQuery();
    }
}

using System.Data.OleDb;

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb";
string deleteQuery = "DELETE FROM TableName WHERE ID = @ID";

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    connection.Open();
    
    using (OleDbCommand command = new OleDbCommand(deleteQuery, connection))
    {
        command.Parameters.AddWithValue("@ID", recordID);
        
        command.ExecuteNonQuery();
    }
}