1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| conn.Open();
SqlCommand insert = new SqlCommand(null, conn);
insert.CommandText = "INSERT INTERVENANT (idIntervenant, nom, prenom, adresseInt, villeInt, codePostalInt, mail, tel, logInt, mdp)" +
"values (@id, '@nom', '@prenom', '@adresseInt', '@vilelInt', @'cp', '@mail', '@tel', '@login', '@mdp')";
insert.Parameters.AddWithValue("@id", "NEWID()");
insert.Parameters.AddWithValue("@nom", nom.Text);
insert.Parameters.AddWithValue("@prenom", prenom.Text);
insert.Parameters.AddWithValue("@adresseInt", adresse.Text);
insert.Parameters.AddWithValue("@vilelInt", ville.Text);
insert.Parameters.AddWithValue("@cp", cp.Text);
insert.Parameters.AddWithValue("@mail",mail.Text);
insert.Parameters.AddWithValue("@tel", telephone.Text);
insert.Parameters.AddWithValue("@login", login.Text);
insert.Parameters.AddWithValue("@mdp", mdp.Text);
insert.Prepare();
/* insert.CommandText = "INSERT INTERVENANT (idIntervenant, nom, prenom, adresseInt, villeInt, codePostalInt, mail, tel, login, mdp)" +
"values (NEWID()," + nom.Text + "," + prenom.Text + "," + adresse.Text + "," + ville.Text + "," + cp.Text + "," +
mail.Text + "," + telephone.Text + "," + login.Text + "," + mdp.Text + ")";*/
insert.ExecuteNonQuery(); |
Partager