1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| private void modification_Click(object sender, EventArgs e)
{
string maRequete = "update from contact set nom=@nom,prenom=@prenom,adresse=@adresse,Telephone=@telephone,ville=@ville,sexe=@sexe ";
cmd = new SqlCommand(maRequete, cx);
cmd.Parameters.Add(new SqlParameter("@nom", SqlDbType.VarChar, 25));
cmd.Parameters.Add(new SqlParameter("@prenom", SqlDbType.VarChar, 25));
cmd.Parameters.Add(new SqlParameter("@adresse", SqlDbType.VarChar, 25));
cmd.Parameters.Add(new SqlParameter("@telephone", SqlDbType.VarChar, 25));
cmd.Parameters.Add(new SqlParameter("@ville", SqlDbType.VarChar, 25));
cmd.Parameters.Add(new SqlParameter("@sexe", SqlDbType.VarChar, 25));
cmd.Parameters["@nom"].Value = nom1.Text;
cmd.Parameters["@prenom"].Value = prenom1.Text;
cmd.Parameters["@adresse"].Value = adresse1.Text;
cmd.Parameters["@telephone"].Value = telephone1.Text;
cmd.Parameters["@ville"].Value = ville1.Text;
cmd.Parameters["@sexe"].Value = sexe1.Text;
try
{
cmd.Connection.Open();
cmd.ExecuteNonQuery();
//result.Text = recup.ToString();
cmd.Connection.Close();
cmd.Dispose();
cx.Close();
MessageBox.Show("modification effectuée ...");
cmd.Connection.Close();
listContact();
nom1.Text = "";
prenom1.Text = "";
adresse1.Text = "";
telephone1.Text = "";
ville1.Text = "";
sexe1.Text = "";
}
catch (SqlException ex)
{
System.Console.Write(ex.Message);
}
}
}
} |
Partager