C#

total_achat += Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value);

total_achat = 0;
...
for (int i = 0; i < dataGridView1.Rows.Count; i++)

Convert.ToDecimal(dataGridView1.Rows[i].Cells[4].Value)

when I put the breakpoint on total buy + = Convert.ToDecimal (dataGridView1.Rows [i] .Cells [4] .Value); total_achat displays 0.

sir sorry and thank you for seeing my error after a review of my code.
I don't know how to explain it to you but I will illustrate it as a comment in my code.

private void Ajouter (String refProd, String quantite, String design, String prixU, String prixTtc)
       {

           String[] row = { refProd, quantite, design, prixU, prixTtc };
           ListViewItem item = new ListViewItem(row);

           listView1.Items.Add(item);
       }

private void BtnAjouter_Click(object sender, EventArgs e)
        {
            double total;
            decimal total_achat;
           
         
            if (Lbl_Affich_Designation.Text == "" || Lbl_Affich_PrixUnitaire.Text == "" || TxtQteCmd.Text == "" || Lbl_affich_TxtQteStock.Text == "" || CmbRef_Produit.Text == "")
            {
                MessageBox.Show("Rassurez vous que tous les champs ont bien été rempli.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
               
                if (CmbRef_Produit.Text != "")
                {
                   
                    double a = 0;
                    double b = 0;
                    double c;
                    int nbprod;
             
                    double.TryParse(TxtQteCmd.Text.Trim(), out a);
                    double.TryParse(Lbl_affich_TxtQteStock.Text.Trim(), out b);
                    double.TryParse(Lbl_Affich_PrixUnitaire.Text.Trim(), out c);

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

                        try
                        {
            
                            

                            using (OleDbCommand cmd = d.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", CmbRef_Produit.Text);
                                cmd.Parameters.AddWithValue("@qute_det", TxtQteCmd.Text);
                                cmd.Parameters.AddWithValue("@Designation", Lbl_Affich_Designation.Text);
                                cmd.Parameters.AddWithValue("@Prix_unitaire_HT", Lbl_Affich_PrixUnitaire.Text);
                                cmd.Parameters.AddWithValue("@Prix_total_HT", total);
                              
                                d.sql_con.Open();

                                cmd.ExecuteNonQuery();
            
                                dataGridView1.DataSource = d.DT;
                                Ajouter(CmbRef_Produit.Text, TxtQteCmd.Text, Lbl_Affich_Designation.Text, Lbl_Affich_PrixUnitaire.Text, total.ToString()); //I had to put the display of my listview here and not after the for loop
                                cmd.Dispose();
                                d.sql_con.Close();
                            }

                            
                           
                        }
                        catch(Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                        }
                       
                        try
                        {

                           LoadDB();

                        
                            for (int i = 0; i < listView1.Items.Count; i++) 
                            {
                                total_achat += Convert.ToDecimal(listView1.Items[i].SubItems[4].Text);
                                nbprod++;
                                LblNbProd.Text = nbprod.ToString();

                            }



                            Lbl_Affich_TotalCmd.Text = total_achat.ToString();
                            //Ajouter(CmbRef_Produit.Text, TxtQteCmd.Text, Lbl_Affich_Designation.Text, Lbl_Affich_PrixUnitaire.Text, total.ToString());
                            Vider();
                            TxtQteCmd.Text = "1";
                         
                           
                            
                        }
                       
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                            d.sql_con.Close();
                        }

                    }
                    else
                    {
                        MessageBox.Show("Veuillez verifier le stock du produit!!!", "Problème avec le stock", MessageBoxButtons.OK, MessageBoxIcon.Information);
                    }
                }
                else
                {
                    MessageBox.Show("Caractères non autorisés", "Problème de saisie", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                }
            }

        }

Quote:

I have a popup modal where the user will select a Word document and my process will save it to a repository under a different standardized name.

using (var documentReader = new StreamReader(fileContent.InputStream))
{
    var readDoc = documentReader.ReadToEnd();

    // write the text to a new file
    StreamWriter writer = new StreamWriter(saveasfilename);
    writer.Write(readDoc);
    writer.Close();
}

HttpPostedFileBase filecontent = Request.Files[0];

filecontent.SaveAs(fullpath);

SELECT name, OBJECT_NAME(referenced_object_id) As ForeignTable
FROM sys.foreign_keys
WHERE parent_object_id = OBJECT_ID('TableName')