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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
|
private void buttonAddpat_Click(object sender, EventArgs e)
{
/* ---------------------------------------------------'Ajoutre dans la table Assure--------------------------------------------*/
String sinsert0 = "insert into Assure(Matricule_unique) values(?)";
OleDbParameter objparm;
OleDbParameter objparm1;
OleDbCommand objinsert = new OleDbCommand();
OleDbCommand objinsert1 = new OleDbCommand();
objinsert.CommandText = sinsert0;
objinsert.Connection = bdd.cnx;
rowcollectionpatient = dtpatient.Rows;
rowpatient = dtpatient.NewRow();
rowpatient["Assure.Matricule_unique"] = comboBoxNumass.Text;
rowpatient["num_pat"] = 1;
rowpatient["prenom"] = textBoxprenom.Text;
rowpatient["nom"] = textBoxnom.Text;
rowpatient["Adresse"] = textBoxadresse.Text;
rowpatient["Tel"] = textBoxtel.Text;
rowpatient["Qualite"] = comboBoxQualite.Text;
rowpatient["Patient.Matricule_unique"] = comboBoxNumass.Text;
rowcollectionpatient.Add(rowpatient);
dspatient.WriteXml("../../../icone//ds.xml");
objparm = objinsert.Parameters.Add("@Matricule_unique", OleDbType.Char);
objparm.SourceColumn = "Assure.Matricule_unique";
objparm.SourceVersion = DataRowVersion.Current;
bdd.OpenConnection();
dapatient.InsertCommand = objinsert;
dapatient.InsertCommand.Connection = bdd.cnx;
dapatient.Update(dspatient, "tpatient");
bdd.closeConnection();
/**************************************************************************************************************************/
String sinsert = "insert into Patient(num_pat,prenom,nom,Adresse,Tel,Qualite,Matricule_unique) values(?,?,?,?,?,?,?)";
objinsert1.CommandText = sinsert;
objinsert1.Connection=bdd.cnx;
objparm1 = objinsert1.Parameters.Add("@num_pat", OleDbType.Char);
objparm1.SourceColumn = "num_pat";
objparm1.SourceVersion = DataRowVersion.Current;
objparm1 = objinsert1.Parameters.Add("@Prenom", OleDbType.Char);
objparm1.SourceColumn = "Prenom";
objparm1.SourceVersion = DataRowVersion.Current;
objparm1 = objinsert1.Parameters.Add("@Nom", OleDbType.Char);
objparm1.SourceColumn = "Nom";
objparm1.SourceVersion = DataRowVersion.Current;
objparm1 = objinsert1.Parameters.Add("@Adresse", OleDbType.Char);
objparm1.SourceColumn = "Adresse";
objparm1.SourceVersion = DataRowVersion.Current;
objparm1 = objinsert1.Parameters.Add("@tel", OleDbType.Char);
objparm1.SourceColumn = "tel";
objparm1.SourceVersion = DataRowVersion.Current;
objparm1 = objinsert1.Parameters.Add("@Qualite", OleDbType.Char);
objparm1.SourceColumn = "Qualite";
objparm1.SourceVersion = DataRowVersion.Current;
objparm1 = objinsert1.Parameters.Add("@Patient.Matricule_unique", OleDbType.Char);
objparm1.SourceColumn = "Patient.Matricule_unique";
objparm1.SourceVersion = DataRowVersion.Current;
bdd.OpenConnection();
dapatient.InsertCommand = objinsert1;
dapatient.InsertCommand.Connection = bdd.cnx;
dapatient.Update(dspatient, "tpatient");
bdd.closeConnection();
} |
