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
59
60
61
| //Connexion à la base de données:
Cnx2.ConnectionString = "Data Source=LANS0004; Initial Catalog=HW_INVENTORY; Integrated Security=True";
SqlCommand cmd;
string req;
//REQUÊTE PARAMETREE POUR L'INSERTION:
try
{
Cnx2.Open();
req = "INSERT INTO MATERIELS (Nom, SN, Type, Modele, Site, Service, Date_Entree,"+
"Date_Sortie, Fin_Leasing, IP, MAC, Num_Cde, Num_Immo, Num_Contrat, Date_Inventaire, Commentaires)VALUES"+
"(@nom,@sn,@type,@modele,@site,@service,@datee,@dateS,@fleas,@ip,@mac,@cde,@nimmo,@con,@inv,@comm)";
cmd = new SqlCommand(req,Cnx2);
//Création et déclaration des paramètres:
cmd.Parameters.Add("@nom",System.Data.SqlDbType.NVarChar, 20, "Nom");
cmd.Parameters.Add("@sn",System.Data.SqlDbType.NVarChar, 50, "SN");
cmd.Parameters.Add("@type",System.Data.SqlDbType.NVarChar, 20, "Type");
cmd.Parameters.Add("@modele",System.Data.SqlDbType.NVarChar, 30, "Modele");
cmd.Parameters.Add("@site",System.Data.SqlDbType.NVarChar, 10, "Site");
cmd.Parameters.Add("@service",System.Data.SqlDbType.NVarChar, 50, "Service");
cmd.Parameters.Add("@dateE",System.Data.SqlDbType.DateTime, 20, "Date_Entree");
cmd.Parameters.Add("@dateS",System.Data.SqlDbType.DateTime, 20, "Date_Sortie");
cmd.Parameters.Add("@fleas",System.Data.SqlDbType.DateTime, 20, "Fin_Leasing");
cmd.Parameters.Add("@ip",System.Data.SqlDbType.NVarChar, 15, "IP");
cmd.Parameters.Add("@mac",System.Data.SqlDbType.NVarChar, 35, "MAC");
cmd.Parameters.Add("@cde",System.Data.SqlDbType.NVarChar, 50, "Num_Cde");
cmd.Parameters.Add("@nimmo",System.Data.SqlDbType.NVarChar, 50, "Num_Immo");
cmd.Parameters.Add("@con",System.Data.SqlDbType.NVarChar, 50, "Num_Contrat");
cmd.Parameters.Add("@inv",System.Data.SqlDbType.DateTime, 20, "Date_Inventaire");
cmd.Parameters.Add("@comm",System.Data.SqlDbType.NVarChar, 100, "Commentaires");
//Attribution des valeurs aux paramètres:
cmd.Parameters["@nom"].Value = TBNom.Text;
cmd.Parameters["@sn"].Value = Convert.ToString(TBSN.Text);
cmd.Parameters["@type"].Value = Convert.ToString(LBType.SelectedValue);
cmd.Parameters["@modele"].Value = Convert.ToString(LBModele.SelectedValue);
cmd.Parameters["@site"].Value = Convert.ToString(LBsite.SelectedValue);
cmd.Parameters["@service"].Value = Convert.ToString(LBServ.SelectedValue);
cmd.Parameters["@dateE"].Value = Convert.ToDateTime(TBDE.Text);
cmd.Parameters["@dateS"].Value = Convert.ToDateTime(TBDS.Text);
cmd.Parameters["@fleas"].Value = Convert.ToDateTime(TBFleas.Text);
cmd.Parameters["@ip"].Value = TBIP.Text;
cmd.Parameters["@mac"].Value = TBMAC.Text;
cmd.Parameters["@cde"].Value = TBCde.Text;
cmd.Parameters["@nimmo"].Value = TBImmo.Text;
cmd.Parameters["@con"].Value = TBCont.Text;
cmd.Parameters["@inv"].Value = Convert.ToDateTime(TBInv.Text);
cmd.Parameters["@comm"].Value = RTB.Text;
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
catch(Exception EX)
{
MessageBox.Show(EX.Message);
} |
