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
| //CREATION DU FORMULAIRE ET RECUPERATION DES INFORMATION DE L INSCRIPTION
formInscription formInscription = new formInscription();
DialogResult dr= formInscription.ShowDialog();
if (dr == DialogResult.OK)
{
try
{
connect.Open();
//MessageBox.Show(formInscription.Identifiant + ' ' + formInscription.Mdp + ' ' + formInscription.Nom + ' ' + formInscription.Prenom + ' ' + formInscription.Email + ' ' + formInscription.Tel + ' ');
OleDbCommand cd = new OleDbCommand
{
Connection = connect,
CommandText = @"INSERT INTO Profil (Identifiant, Password, Nom, Prénom, Email, Téléphone,[Date de création])
VALUES ('" + formInscription.Identifiant + "','" + formInscription.Mdp + "','"
+ formInscription.Nom + "','" + formInscription.Prenom + "','" + formInscription.Email
+ "','" + formInscription.Tel + "','" + DateTime.Now.ToShortDateString().ToString() + "');"
};
cd.ExecuteNonQuery();
MessageBox.Show("Inscription réussi", "Bravo", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (OleDbException er)
{
MessageBox.Show(er.Message);
Application.Exit();
}
finally
{
connect.Close();
} |
Partager