Affichage de liste des clients
Bonjour ,
Je voudrais afficher une liste des clients mais une erreur apparait lors de l'exécution du projet.
Voici mon code:
Code:
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
|
public Clients ConsultationClient(int ID_CLIENT)
{
System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection();
conn.ConnectionString = @"Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;User ID=topnet;Initial Catalog=TopnetBase;Data Source=SWEET-4B6F892B4\SQLEXPRESS";
Clients oClients = new Clients();
ClientTopNet oClient = new ClientTopNet();
conn.Open();
System.Data.OleDb.OleDbDataReader rs;
System.Data.OleDb.OleDbCommand comm = new System.Data.OleDb.OleDbCommand("select * from client where ID_CLIENT='" + ID_CLIENT + "'", conn);
rs = comm.ExecuteReader();
while (rs.Read())
{
oClient.ID_CLIENT = rs.GetInt32(0) ;
oClient.LOGIN_CREATION = rs.GetString(1);
oClient.DATE_CREATION = rs.GetDateTime(2);
oClient.LOGIN_MODIFICATION = rs.GetString(3);
oClient.DATE_MODIFICATION = rs.GetDateTime(4);
oClient.TYPE_CLIENT = rs.GetInt32(5);
oClient.CIVILITE = rs.GetInt32(6);
oClient.NOM = rs.GetString(7);
oClient.PRENOM = rs.GetString(8);
oClient.FONCTION = rs.GetString(9);
oClient.RS = rs.GetString(10);
oClient.CIN = rs.GetString(11);
oClient.ADRESSE = rs.GetString(12);
oClient.VILLE = rs.GetString(13);
oClient.CP = rs.GetInt32(14);
oClient.GOUVERN = rs.GetInt32(15);
oClient.TEL = rs.GetString(16);
oClient.GSM = rs.GetString(17);
oClient.FAX = rs.GetString(18);
oClient.EMAIL = rs.GetString(19);
oClient.CD_ORIGINE = rs.GetInt32(20);
oClient.OBSERV = rs.GetString(21);
oClient.EXONERE = rs.GetInt32(22);
oClient.EXOTIMBRE = rs.GetInt32(23);
oClient.SECTEUR_ACT = rs.GetInt32(24);
oClient.VIP = rs.GetInt32(25);
oClient.CHARGECOMPTE = rs.GetString(26);
oClient.CHARGECOMPTE_RD = rs.GetString(27);
oClient.CATEGORIE = rs.GetInt32(28);
oClient.REGISTRE = rs.GetString(29);
oClient.METHOD_ENVOI_FACT = rs.GetInt32(30);
oClient.PERSONNEL = rs.GetInt32(31);
oClient.REF_CLIENTCRM = rs.GetString(32);
oClients.Add(oClient);
}
rs.Close();
conn.Close();
return oClients;
} |
et voici l'erreur:
Citation:
Le cast spécifié n'est pas valide.
Merci de m'aider.
