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 45 46 47 48 49 50
|
string pathBdd = @"Data Source=|DataDirectory|\dbShelter.sdf;Password=;Persist Security Info=True";
ConnexionBdd.Init(pathBdd);
SqlCeCommand cmd = ConnexionBdd.PreparerCommande("INSERT INTO Customer (Civility, FirstName, Name, AdressL1, AdressL2, "
+ "ZipCode, City, Country, TelHome, TelOffice, TelMobile, Fax, Email, Observations, OriginBooking, TypeOf, "
+ "Appreciation, DateCreated) "
+ "VALUES (@Civility, @FirstName, @Name, @AdressL1, @AdressL2, @ZipCode, @City, @Country, @TelHome, @TelOffice,"
+ "@TelHome, @Fax, @Email, @Observations, @OriginBooking, @TypeOf, @Appreciation, @DateCreated)");
//Création et décalartion des paramètres
cmd.Parameters.Add(new SqlCeParameter("@Civility", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@FirstName", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@Name", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@AdressL1", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@AdressL2", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@ZipCode", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@City", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@Country", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@TelHome", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@TelOffice", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@TelMobile", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@Fax", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@Email", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@Observations", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@OriginBooking", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@TypeOf", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@Appreciation", SqlDbType.NVarChar));
cmd.Parameters.Add(new SqlCeParameter("@DateCreated", SqlDbType.DateTime));
//Attribution des valeurs aux paramètres
cmd.Parameters["@Civility"].Value = cbCivility.Text;
cmd.Parameters["@FirstName"].Value = tbFirstName.Text;
cmd.Parameters["@Name"].Value = tbName.Text;
cmd.Parameters["@AdressL1"].Value = tbAdressL1.Text;
cmd.Parameters["@AdressL2"].Value = tbAdressL2.Text;
cmd.Parameters["@ZipCode"].Value = tbZipCode.Text;
cmd.Parameters["@City"].Value = tbCity.Text;
cmd.Parameters["@Country"].Value = cbCountry.Text;
cmd.Parameters["@TelHome"].Value = tbTelHome.Text;
cmd.Parameters["@TelOffice"].Value = tbTelOffice.Text;
cmd.Parameters["@TelMobile"].Value = tbTelMobile.Text;
cmd.Parameters["Fax"].Value = tbFax.Text;
cmd.Parameters["Email"].Value = tbEmail.Text;
cmd.Parameters["@Observations"].Value = tbObservations.Text;
cmd.Parameters["@OriginBooking"].Value = cbOriginBooking.Text;
cmd.Parameters["@TypeOf"].Value = cbTypeOf.Text; cmd.Parameters["@Appreciation"].Value = cbAppreciation.Text;
cmd.Parameters["@DateCreated"].Value = dtpDateCreated.Value;
cmd.ExecuteNonQuery(); |
Partager