Discussion :

[aspkiddy]

Bonjour,
je récupère les informations que l'utilisateur a remplies dans un formulaire...
Je vais enregistrer ces informations dans 2 tables différentes.
Voici mon code qui marche :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
//1er req
 
string connStr = "server=000.0.0.0;user=toto;database=ma_base;port=2222;password=#################;";
MySqlConnection conn = new MySqlConnection(connStr);
 
conn.Open();
 
string sql = "INSERT INTO table_premiere (champSfirst_name,champSlast_name,champScompany_name,champSaddress1,champSadress2,champScity,champSstate,champScountry,champSpostal_code)VALUES (@first_name,@last_name,@company_name,@address1,@adress2,@city,@state,@country,@postal_code)";
 
 
MySqlCommand cmd = new MySqlCommand(sql, conn);
 
MySqlParameter first_name = new MySqlParameter("@first_name", s.FirstName);
MySqlParameter last_name = new MySqlParameter("@last_name", s.LastName);
MySqlParameter company_name = new MySqlParameter("@company_name", s.CompanyName);
MySqlParameter address1 = new MySqlParameter("@address1", s.Address1);
MySqlParameter adress2 = new MySqlParameter("@adress2", s.Address2);
MySqlParameter city = new MySqlParameter("@city", s.City);
MySqlParameter state = new MySqlParameter("@state", s.State);
MySqlParameter country = new MySqlParameter("@country", s.Country);
MySqlParameter postal_code = new MySqlParameter("@postal_code", s.PostalCode);
 
cmd.Parameters.Add(first_name);
cmd.Parameters.Add(last_name);
cmd.Parameters.Add(company_name);
cmd.Parameters.Add(address1);
cmd.Parameters.Add(adress2);
cmd.Parameters.Add(city);
cmd.Parameters.Add(state);
cmd.Parameters.Add(country);
cmd.Parameters.Add(postal_code);
 
cmd.ExecuteNonQuery();
conn.Close();
 
////2e req
string connTATAStr = "server=000.0.0.0;user=toto;database=ma_base;port=2222;password=#################;";
MySqlConnection connTATA = new MySqlConnection(connTATAStr);
 
connTATA.Open();
 
string sqlTATA = "INSERT INTO table_deuxieme (champSfirst_name,champSlast_name,champScompany_name,champSaddress1,champSadress2,champScity,champSstate,champScountry,champSpostal_code)VALUES (@tATAfirst_name,@tATAlast_name,@tATAcompany_name,@tATAaddress1,@tATAadress2,@tATAcity,@tATAstate,@tATAcountry,@tATApostal_code)";
 
MySqlCommand cmdTATA = new MySqlCommand(sqlTATA, connTATA);
 
MySqlParameter tATAfirst_name = new MySqlParameter("@tATAfirst_name", s.FirstName);
MySqlParameter tATAlast_name = new MySqlParameter("@tATAlast_name", s.LastName);
MySqlParameter tATAcompany_name = new MySqlParameter("@tATAcompany_name", s.CompanyName);
MySqlParameter tATAaddress1 = new MySqlParameter("@tATAaddress1", s.Address1);
MySqlParameter tATAadress2 = new MySqlParameter("@tATAadress2", s.Address2);
MySqlParameter tATAcity = new MySqlParameter("@tATAcity", s.City);
MySqlParameter tATAstate = new MySqlParameter("@tATAstate", s.State);
MySqlParameter tATAcountry = new MySqlParameter("@tATAcountry", s.Country);
MySqlParameter tATApostal_code = new MySqlParameter("@tATApostal_code", s.PostalCode);
 
cmdTATA.Parameters.Add(tATAfirst_name);
cmdTATA.Parameters.Add(tATAlast_name);
cmdTATA.Parameters.Add(tATAcompany_name);
cmdTATA.Parameters.Add(tATAaddress1);
cmdTATA.Parameters.Add(tATAadress2);
cmdTATA.Parameters.Add(tATAcity);
cmdTATA.Parameters.Add(tATAstate);
cmdTATA.Parameters.Add(tATAcountry);
cmdTATA.Parameters.Add(tATApostal_code);
 
cmdTATA.ExecuteNonQuery();
connTATA.Close();

Comment je peux optimiser mon code en évitant le doublement ?

[kdmbella]

je pense dans un premier temps que tu doit utiliser une try catch ensuite tu peut récupérer tes paramètres une seule fois te connecter une seule fois à la BD et la crée une seul MySqlCommand utiliser les mème paramètres bref
ce bloc peuètre écrit une seul fois

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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
string connStr = "server=000.0.0.0;user=toto;database=ma_base;port=2222;password=#################;";
MySqlConnection conn = new MySqlConnection(connStr);
 
conn.Open();
 
string sql = "INSERT INTO table_premiere (champSfirst_name,champSlast_name,champScompany_name,champSaddress1,champSadress2,champScity,champSstate,champScountry,champSpostal_code)VALUES (@first_name,@last_name,@company_name,@address1,@adress2,@city,@state,@country,@postal_code)";
 
 
MySqlCommand cmd = new MySqlCommand(sql, conn);
 
MySqlParameter first_name = new MySqlParameter("@first_name", s.FirstName);
MySqlParameter last_name = new MySqlParameter("@last_name", s.LastName);MySqlParameter company_name = new MySqlParameter("@company_name", s.CompanyName);
MySqlParameter address1 = new MySqlParameter("@address1", s.Address1);
MySqlParameter adress2 = new MySqlParameter("@adress2", s.Address2);
MySqlParameter city = new MySqlParameter("@city", s.City);
MySqlParameter state = new MySqlParameter("@state", s.State);
MySqlParameter country = new MySqlParameter("@country", s.Country);
MySqlParameter postal_code = new MySqlParameter("@postal_code", s.PostalCode);
 
cmd.Parameters.Add(first_name);
cmd.Parameters.Add(last_name);
cmd.Parameters.Add(company_name);
cmd.Parameters.Add(address1);
cmd.Parameters.Add(adress2);
cmd.Parameters.Add(city);
cmd.Parameters.Add(state);
cmd.Parameters.Add(country);
cmd.Parameters.Add(postal_code);

la distincton se fera au niveau de cette partie : MySqlCommand cmdTATA =new MySqlCommand(sqlTATA, connTATA); ou le nom de la table variera