如何在vs上实现mysql数据库的增删改

using MySql.Data.MySqlClient;

string connectionString = "server=<MySQL服务器地址>;user=<用户名>;password=<密码>;database=<数据库名>";
MySqlConnection connection = new MySqlConnection(connectionString);

try
{
    connection.Open();
    // 连接成功后可以进行增删改操作
}
catch (Exception ex)
{
    // 处理连接错误
}
finally
{
    connection.Close();
}

MySqlCommand command = connection.CreateCommand();
command.CommandText = "INSERT INTO <表名> (列1, 列2, 列3) VALUES (@Value1, @Value2, @Value3)";
command.Parameters.AddWithValue("@Value1", "值1");
command.Parameters.AddWithValue("@Value2", "值2");
command.Parameters.AddWithValue("@Value3", "值3");

try
{
    int rowsAffected = command.ExecuteNonQuery();
    // 处理插入操作结果
}
catch (Exception ex)
{
    // 处理插入操作错误
}

// 更新操作
command.CommandText = "UPDATE <表名> SET 列1 = @NewValue WHERE 列2 = @Condition";
command.Parameters.AddWithValue("@NewValue", "新值");
command.Parameters.AddWithValue("@Condition", "条件");

// 删除操作
command.CommandText = "DELETE FROM <表名> WHERE 列1 = @Condition";
command.Parameters.AddWithValue("@Condition", "条件");