private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
string CommandText;
int row = dataGridView1.CurrentRow.Index;
string ID = Convert.ToString(dataGridView1.Rows[row].Cells[0].Value);
CommandText = "update auto.transportation set transportation.active = 'X' where transportation.idtransportation ='" + ID + "';";
My_Execute_Non_Query(CommandText);
button1_Click(sender, e);
}