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 51 52 53 54 55 56
| private void Valider_Click(object sender, System.EventArgs e)
{
SqlConnection connection;
connection = new SqlConnection("Data Source=DIST-5B8D87E3A9;Initial Catalog=DistribInfo;Integrated Security=SSPI");
connection.Open();
try
{
SqlParameter paramNInter = new SqlParameter("@NumInter", SqlDbType.VarChar, 15);
paramNInter.Value = NumIntervention;
SqlParameter paramNClt = new SqlParameter("@NumClt", SqlDbType.VarChar, 13);
paramNClt.Value = NumClt;
SqlParameter paramNClt1 = new SqlParameter("@NumClt1", SqlDbType.VarChar, 13);
paramNClt1.Value = NumClt;
SqlParameter paramNMat = new SqlParameter("@NumMachine", SqlDbType.Int, 13);
paramNMat.Value = NumMachine;
SqlParameter paramResInter = new SqlParameter("@RaisonInter", SqlDbType.VarChar, 250);
paramResInter.Value = RaisonInter;
SqlParameter paramLieInter = new SqlParameter("@LieInter", SqlDbType.Text);
paramLieInter.Value = LieuInter.SelectedItem.ToString();
SqlParameter paramDepo = new SqlParameter("@Depositaire", SqlDbType.Char, 50);
paramDepo.Value = Dépositaire.SelectedItem.ToString();
SqlParameter paramRecep = new SqlParameter("@Receptionneur", SqlDbType.Char, 20);
paramRecep.Value = Réceptionneur.SelectedItem.ToString();
SqlParameter paramDPrisCharg = new SqlParameter("@DatePrisEnCharge", SqlDbType.DateTime, 8);
paramDPrisCharg.Value = DatePrisEnCharge.Format;
string sql = string.Format("INSERT INTO INTERVENTION(IN_NUMINTER, IN_NUMCLT, IN_M_NUMCLT, IN_IDMAT, IN_RESINTER, IN_LIEINTER, IN_DEPOMAT, IN_RECEPMAT, IN_PRICHARG) VALUES({0}, {1}, {2}, {3}, {4}, {5}, {6}, {7})",
paramNInter.ParameterName, paramNClt.ParameterName,
paramNClt1.ParameterName, paramNMat.ParameterName,
paramResInter.ParameterName, paramLieInter.ParameterName,
paramDepo.ParameterName, paramRecep.ParameterName,
paramDPrisCharg.ParameterName);
SqlCommand cmd = new SqlCommand(sql.ToString(), connection);
cmd.Parameters.Add(paramNInter);
cmd.Parameters.Add(paramNClt);
cmd.Parameters.Add(paramNClt1);
cmd.Parameters.Add(paramNMat);
cmd.Parameters.Add(paramResInter);
cmd.Parameters.Add(paramLieInter);
cmd.Parameters.Add(paramDepo);
cmd.Parameters.Add(paramRecep);
cmd.Parameters.Add(paramDPrisCharg);
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
}
} |
Partager