connect.Open(); MySqlCommand cmd = new MySqlCommand("SELECT * from users",connect); MySqlTransaction tr = connect.BeginTransaction(); cmd.CommandText = "delete from users where ID='" + textBox3.Text + "';"; cmd.ExecuteNonQuery(); tr.Commit(); connect.Close();