c# access数据库更新值

using System.Data.OleDb;

string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\path\\to\\database.accdb";

using (OleDbConnection connection = new OleDbConnection(connectionString))
{
    string sql = "UPDATE TableName SET ColumnName = @NewValue WHERE Condition";
    OleDbCommand command = new OleDbCommand(sql, connection);
    command.Parameters.AddWithValue("@NewValue", newValue);
    
    // 其中TableName是要更新的表名，ColumnName是要更新的列名，Condition是更新条件，@NewValue是参数名，newValue是要更新的新值。
    
    // 打开数据库连接
    connection.Open();
    
    // 执行更新操作
    int rowsAffected = command.ExecuteNonQuery();
    
    // 输出更新的行数
    Console.WriteLine("Rows Affected: " + rowsAffected);
}