private void metroButton_save_sourcing_Click(object sender, EventArgs e) { Boolean it_is_ok = false; foreach (int id in my_list_contact) { string query_sourcing = "insert into sourcing(ID_candidat,date_soorcing,poste,Entreprise,resultat)"; query_sourcing += "values(" + id + ",'" + dateTimePicker_sourcing_date.Value + "','" + metroTextBox_add_sourcing_poste.Text + "','" + metroTextBox_add_sourcing_entreprise.Text + "','EnCours')"; it_is_ok = Class_Database_app.add_sourcing(query_sourcing); } if (it_is_ok) { DialogResult c = MessageBox.Show("tout a bien faite", "ok", MessageBoxButtons.OK); if (c == DialogResult.OK) { Close(); } } }