使用C#使用DataGridView中的值更新数据库

using MySql.Data.MySqlClient;

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

try
{
    connection.Open();
    // 连接成功后的操作
}
catch (Exception ex)
{
    Console.WriteLine(ex.Message);
}
finally
{
    connection.Close();
}

int selectedRowIndex = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[selectedRowIndex];
string value1 = Convert.ToString(selectedRow.Cells["列名1"].Value);
string value2 = Convert.ToString(selectedRow.Cells["列名2"].Value);
// 获取其他列的值

string sql = "UPDATE 表名 SET 列名1 = @Value1, 列名2 = @Value2 WHERE 条件";
MySqlCommand command = new MySqlCommand(sql, connection);
command.Parameters.AddWithValue("@Value1", value1);
command.Parameters.AddWithValue("@Value2", value2);
// 添加其他参数

int rowsAffected = command.ExecuteNonQuery();