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
57
58
| private void Valider_Click(object sender, System.EventArgs e)
{
// Code permettant l'enregistrement des résultats
// dans la base de données SqlServer se nommant DistribInfo
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.Text;
SqlParameter paramNClt = new SqlParameter("@NumClt", SqlDbType.VarChar, 13);
paramNClt.Value = NumClt.Text;
SqlParameter paramNClt1 = new SqlParameter("@NumClt1", SqlDbType.VarChar, 13);
paramNClt1.Value = NumClt.Text;
SqlParameter paramNMat = new SqlParameter("@NumMachine", SqlDbType.Int, 13);
paramNMat.Value = int.Parse(NumMachine.Text);
SqlParameter paramResInter = new SqlParameter("@RaisonInter", SqlDbType.VarChar, 250);
paramResInter.Value = RaisonInter.Text;
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("@DPrisCharg", SqlDbType.DateTime, 8);
paramDPrisCharg.Value = DatePrisEnCharge;
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}, {8})",
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(string.Format("{0}{1}{2}",ex.Message, ex.StackTrace));
}
finally
{
connection.Close();
}
} |
réponse à MoscoBlade
Répondre avec citation
Envoyé par loic20h28
Partager