如何使用DataGridView中的列来影响MySQL

dataGridView1.Columns.Add("Column1", "Column Header 1");
dataGridView1.Columns.Add("Column2", "Column Header 2");

string connectionString = "server=localhost;database=mydatabase;uid=username;pwd=password;";
MySqlConnection connection = new MySqlConnection(connectionString);
connection.Open();

foreach (DataGridViewRow row in dataGridView1.Rows)
{
    string column1Value = row.Cells["Column1"].Value.ToString();
    string column2Value = row.Cells["Column2"].Value.ToString();

    string query = "INSERT INTO mytable (column1, column2) VALUES (@column1, @column2)";
    MySqlCommand command = new MySqlCommand(query, connection);
    command.Parameters.AddWithValue("@column1", column1Value);
    command.Parameters.AddWithValue("@column2", column2Value);
    command.ExecuteNonQuery();
}

connection.Close();