Discussion :

[Tanaes]

Salut c'est encore moi !

J'ai un petit soucis avec le datagridview, je m'explique :

J'ai réussi à en insérer un dans mon formulaire windows form :

Je le rempli :

Et quand je valide, je voudrais insérer dans ma bdd (sous mysql) les valeurs avec des virgules ou des tirets entre chaque, par exemple dans ma colonne quantité (de ma bdd) je voudrais avoir " 1 - 1 ", pareil pour les produits, les prix, etc...

Voici le code de mon insert dans la BDD :

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
string requeteInsertion = "INSERT INTO FICHEFACTURE VALUES(";
                requeteInsertion += "'";
                requeteInsertion += tbx_facture_no_facture.Text;
                requeteInsertion += "' , '";
                requeteInsertion += tbx_facture_date.Text = DateTime.Today.ToString("yyy/MM/dd");
                requeteInsertion += "' , '";
                requeteInsertion += tbx_facture_nb_facture.Text;
                requeteInsertion += "' , '";
                requeteInsertion += dataGridView1.Rows[0].Cells[0].Value;
                requeteInsertion += "', ' ";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                      requeteInsertion += dataGridView1.Rows[0].Cells[1].Value;
                }
                requeteInsertion += "', '";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += dataGridView1.Rows[i].Cells[2].Value;
                }
                requeteInsertion += "' , '";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += dataGridView1.Rows[i].Cells[4].Value;
                }
                requeteInsertion += "', '";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += dataGridView1.Rows[i].Cells[3].Value;
                }
                requeteInsertion += "' ,'";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += dataGridView1.Rows[i].Cells[5].Value;
                }
                requeteInsertion += "' ,'";
                requeteInsertion += dataGridView2.Rows[0].Cells[0].Value;
                requeteInsertion += "' ,'";
                requeteInsertion += dataGridView2.Rows[0].Cells[1].Value;
                requeteInsertion += "' ,'";
                requeteInsertion += dataGridView2.Rows[0].Cells[2].Value;
                requeteInsertion += "' ,'";
                requeteInsertion += lbl_facture_paiement_id.Text;
                requeteInsertion += "' ,'";
                requeteInsertion += lbl_facture_cli_id.Text;
                requeteInsertion += "')";
                requeteInsertion += ";";
 
                curseurInsertion.ReqAdmin(requeteInsertion);
                curseurInsertion.fermer();

Merci de votre aide !

Cordialement,
Tanaes.

[Tanaes]

Problème résolu !!!
Je mets mon code pour ceux qui veulent :

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
string requeteInsertion = "INSERT INTO FICHEFACTURE VALUES(";
                requeteInsertion += "'";
                requeteInsertion += tbx_facture_no_facture.Text;
                requeteInsertion += "' , '";
                requeteInsertion += tbx_facture_date.Text = DateTime.Today.ToString("yyy/MM/dd");
                requeteInsertion += "' , '";
                requeteInsertion += tbx_facture_nb_facture.Text;
                requeteInsertion += "' , '";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += " - " + dataGridView1.Rows[0].Cells[0].Value;
                }
                requeteInsertion += "', ' ";
 
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += " - " + dataGridView1.Rows[i].Cells[1].Value;
                }
                requeteInsertion += "', '";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += " - " + dataGridView1.Rows[i].Cells[2];
                }
                requeteInsertion += "' , '";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += " - " + dataGridView1.Rows[i].Cells[4];
                }
                requeteInsertion += "', '";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += " - " + dataGridView1.Rows[i].Cells[3];
                }
                requeteInsertion += "' ,'";
                for (int i = 0; i < dataGridView1.Rows.Count; i++)
                {
                    requeteInsertion += " - " + dataGridView1.Rows[i].Cells[5];
                }
                requeteInsertion += "' ,'";
                requeteInsertion += dataGridView2.Rows[0].Cells[0].Value;
                requeteInsertion += "' ,'";
                requeteInsertion += dataGridView2.Rows[0].Cells[1].Value;
                requeteInsertion += "' ,'";
                requeteInsertion += dataGridView2.Rows[0].Cells[2].Value;
                requeteInsertion += "' ,'";
                requeteInsertion += lbl_facture_paiement_id.Text;
                requeteInsertion += "' ,'";
                requeteInsertion += lbl_facture_cli_id.Text;
                requeteInsertion += "')";
                requeteInsertion += ";";

Merci quand même