C#

Quote:

hello gentlemen and thank you to you who bring me your help. I am almost at the end of my program and I have an update problem. I don't see any change in my stock.
I have no error when I validate but the quantity does not change in the access database

for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                               {
                                   ref_prod = Convert.ToString(dataGridView1.Rows[i].Cells[0].Value);
                                   Qte_prod = Convert.ToInt64(dataGridView1.Rows[i].Cells[1].Value);

                                   using (OleDbCommand cmd3 = sql_con.CreateCommand())
                                   {

                                       cmd3.CommandText = "INSERT INTO Detail_commandes (com_det, ref_det, qute_det) VALUES (@com_det,@ref_det,@qute_det)";
                                       cmd3.Parameters.AddWithValue("@com_det", TxtNunCmd.Text);
                                       cmd3.Parameters.AddWithValue("@ref_det", ref_prod);
                                       cmd3.Parameters.AddWithValue("@qute_det", Qte_prod);
                                       sql_con.Open();
                                       cmd3.ExecuteNonQuery();
                                       sql_con.Close();

                                   }

                                   using (OleDbCommand cmd4 = sql_con.CreateCommand())
                                   {
                                       //setConnection();
                                       OleDbCommand QteStock = sql_con.CreateCommand();
                                       QteStock.CommandText = "SELECT Quantite FROM Catalogue";
                                       sql_con.Open();
                                       int LastQteStock = Convert.ToInt32(QteStock.ExecuteScalar());
                                       sql_con.Close();
                                       cmd4.CommandText = "UPDATE Catalogue SET Quantite = @Quantite - @QteStc WHERE code_article = (@code_article)";
                                       cmd4.Parameters.AddWithValue("@Quantite", LastQteStock);
                                       cmd4.Parameters.AddWithValue("@QteStc", Qte_prod);
                                       cmd4.Parameters.AddWithValue("@code_article", TxtRefProduit.Text);
                                       sql_con.Open();
                                       cmd4.ExecuteNonQuery();
                                       sql_con.Close();

                                   }
                           }

the goal is to add and save later I can do it once when I want to do it for a second time I have an error: unable to find table 0, I must close the form and open it again so that I can do another one ... how to solve this problem without closing my form before?

  private void BtnAjouter_Click(object sender, EventArgs e)
        {
            int total;
            decimal total_achat;
            //si les champs sont vides
            if (TxtDesignation.Text == "" || TxtPrixUnitaire.Text == "" || TxtQteCmd.Text == "" || TxtQteStock.Text == "" || TxtRefProduit.Text == "")
            {
                MessageBox.Show("Rassurez vous que tous les champs ont bien été rempli.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                //Vérifier si la valeur saisie est numeric
                if (Int32.TryParse(TxtQteCmd.Text, out int value) && TxtRefProduit.Text != "")
                {
                    //Vérifier si la commande est inferieur ou egale au stock
                    int a = 0;
                    int b = 0;
                    int c;

                    //Convertire les textBox en int
                    int.TryParse(TxtQteCmd.Text.Trim(), out a);
                    int.TryParse(TxtQteStock.Text.Trim(), out b);
                    int.TryParse(TxtPrixUnitaire.Text.Trim(), out c);

                    if (a <= b)
                    {
                        total = a * c;
                        total_achat = 0;

                        try
                        {
            
                            setConnection();
                            sql_con.Open();
                            using (OleDbCommand cmd = sql_con.CreateCommand())
                            {
                                cmd.CommandText = "INSERT INTO Detail_temp (ref_det, qute_det, Designation, Prix_unitaire_HT, Prix_total_HT) VALUES (@ref_det,@qute_det,@Designation,@Prix_unitaire_HT,@Prix_total_HT)";
                                cmd.Parameters.AddWithValue("@ref_det", TxtRefProduit.Text);
                                cmd.Parameters.AddWithValue("@qute_det", TxtQteCmd.Text);
                                cmd.Parameters.AddWithValue("@Designation", TxtDesignation.Text);
                                cmd.Parameters.AddWithValue("@Prix_unitaire_HT", TxtPrixUnitaire.Text);
                                cmd.Parameters.AddWithValue("@Prix_total_HT", total);

                                cmd.ExecuteNonQuery();
                                DS.Reset();
                                DB.Fill(DS);
                                DT = DS.Tables[0]; (Problem is here):confused::confused:
                                dataGridView1.DataSource = DT;
                                cmd.Dispose();
                                sql_con.Close();
                             
                            }
                        }
                        catch(Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                        }
                        
Designation, Prix_unitaire_HT, Prix_total_HT) VALUES (@ref_det, @qute_det, @Designation, @Prix_unitaire_HT, @Prix_total_HT)";
                       
                

                        try
                        {

                            LoadDB();
                         
                            //ADDITIONNER UNE COLONNE DU DATAGRIDVIEW
                            for (int i = 0; i < dataGridView1.Rows.Count; i++) //Car tu fais une infériorité stricte
                            {
                                total_achat += Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value);

                            }
                            TxtTotalCmd.Text = total_achat.ToString();//convertir total_achat en string^pour pouvoir l'afficher dans le textbox
                            vider();
                            
                          
                            
                        }
                       
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                            sql_con.Close();
                        }
                        finally
                        {
                            sql_con.Close();
                        }

                    }
                    else
                    {
                        MessageBox.Show("Veuillez verifier le stock du produit!!!");
                    }
                }

            }

        }