Re: Add a listview cell - C# Discussion Boards

27-Jul-20 22:02

And what does this have to do with C#?

Use the right forum, or ask here: Ask a question[^]

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Add a listview cell

ago248627-Jul-20 1:34

27-Jul-20 1:34

I want to add after adding, I had used the datagriedview which works well but for other reasons of redu I decided to use a listview but with this code it adds me that after the second addition, it is to say when I make a first addition, my textbox which receives the sum remains 0 and at the second addition it takes the value of the first and at the third it adds the first and the second, it does not add all the additions, and I do not that's not why. I need an explanation to review what is wrong in the code

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

OriginalGriff27-Jul-20 2:28

27-Jul-20 2:28

We can't tell: we don't have access to your code or data while it is running.

So, it's going to be up to you.
Fortunately, you have a tool available to you which will help you find out what is going on: the debugger. If you don't know how to use it then a quick Google for "Visual Studio debugger" should give you the info you need.

Put a breakpoint on the first line in the function, and run your code through the debugger. Then look at your code, and at your data and work out what should happen manually. Then single step each line checking that what you expected to happen is exactly what did. When it isn't, that's when you have a problem, and you can back-track (or run it again and look more closely) to find out why.

Sorry, but we can't do that for you - time for you to learn a new (and very, very useful) skill: debugging!

ago248627-Jul-20 2:31

27-Jul-20 2:31

ok thank you i'm getting started

OriginalGriff27-Jul-20 2:59

27-Jul-20 2:59

You're welcome!

ago248627-Jul-20 3:18

27-Jul-20 3:18

thank you sir I followed your advice and I saw that the problem came from the fact that at the first addition my variables total_achat and i always remain 0. Frankly I do not know why?.

private void BtnAjouter_Click(object sender, EventArgs e)
        {
            double total;
            decimal total_achat;
           
            //si les champs sont vides
            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
            {
                //Vérifier si la valeur saisie est numeric
                if (CmbRef_Produit.Text != "")
                {
                    //Vérifier si la commande est inferieur ou egale au stock
                    double a = 0;
                    double b = 0;
                    double c;
                    int nbprod;
                    //Convertire les textBox en int
                    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;
                        //ADDITIONNER UNE COLONNE DU DATAGRIDVIEW
                       

                        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;
                                cmd.Dispose();
                                d.sql_con.Close();
                            }

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

                           LoadDB();

                            //ADDITIONNER UNE COLONNE DU DATAGRIDVIEW
                            for (int i = 0; i < listView1.Items.Count; i++) //Car tu fais une infériorité stricte
                            {
                                total_achat += Convert.ToDecimal(listView1.Items[i].SubItems[4].Text);
                                nbprod++;
                                LblNbProd.Text = nbprod.ToString();

                            }



                            //label3.Text = total.ToString();
                            Lbl_Affich_TotalCmd.Text = total_achat.ToString();//convertir total_achat en string pour pouvoir l'afficher dans le textbox
                            Ajouter(CmbRef_Produit.Text, TxtQteCmd.Text, Lbl_Affich_Designation.Text, Lbl_Affich_PrixUnitaire.Text, total.ToString()); //AFficher dans la listView
                            Vider();
                            TxtQteCmd.Text = "1";
                            //SupDetail_Temp();
                           
                            
                        }
                       
                        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);
                }
            }

        }

with the datagridview I have no problem.

private void BtnAjouter_Click(object sender, EventArgs e)
        {
            double total;
            decimal total_achat;
           
            //si les champs sont vides
            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
            {
                //Vérifier si la valeur saisie est numeric
                if (CmbRef_Produit.Text != "")
                {
                    //Vérifier si la commande est inferieur ou egale au stock
                    double a = 0;
                    double b = 0;
                    double c;
                    int nbprod;
                    //Convertire les textBox en int
                    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;
                        //ADDITIONNER UNE COLONNE DU DATAGRIDVIEW
                       

                        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;
                                cmd.Dispose();
                                d.sql_con.Close();
                            }

                            
                           
                        }
                        catch(Exception ex)
                        {
                            MessageBox.Show(ex.ToString());
                        }
                       
                        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);
                                nbprod++;
                                LblNbProd.Text = nbprod.ToString();

                            }



                            //label3.Text = total.ToString();
                            Lbl_Affich_TotalCmd.Text = total_achat.ToString();//convertir total_achat en string pour pouvoir l'afficher dans le textbox
                            Ajouter(CmbRef_Produit.Text, TxtQteCmd.Text, Lbl_Affich_Designation.Text, Lbl_Affich_PrixUnitaire.Text, total.ToString()); //AFficher dans la listView
                            Vider();
                            TxtQteCmd.Text = "1";
                            //SupDetail_Temp();
                           
                            
                        }
                       
                        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);
                }
            }

        }

OriginalGriff27-Jul-20 3:37

27-Jul-20 3:37

So use the debugger to find out!
Start by breakpointing the line itself:

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

When it hits for the first time, the total and the loop index should both be zero because that is what your code told them to be:

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

After it, you will have added the cell value, so step over that line.
What's the value of the total now? If it's still zero, then it means that this code evaluates to zero:

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

So look at why that is: what's the value of dataGridView1.Rows[i].Cells[4].Value - use the debugger to find out by firstly hovering over word "Value" and if that looks "right" then adding the calculation to teh Watch pane.

ago248627-Jul-20 4:08

27-Jul-20 4:08

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

OriginalGriff27-Jul-20 4:38

27-Jul-20 4:38

Yes, because the line hasn't been executed yet. Breakpoints stop at the beginning of the line, not the end.
Step over the line, (as opposed to step into) and see if it changes.

ago248627-Jul-20 4:45

27-Jul-20 4:45

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.

ago248627-Jul-20 4:53

saving a Word Doc from address bar in .net/C#

27-Jul-20 4:53

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);
                }
            }

        }

Pita3225-Jul-20 5:50

Pita32

25-Jul-20 5:50

I've got a situation in my .Net application where 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.

To get the input file from the address bar:

HttpPostedFileBase fileContent = Request.Files[0];

Then the save:

fileContent.SaveAs(fullPath);

Unfortunately the SaveAs does not work, as when you get the Word Document from the Response object, it blanks it out when doing the SaveAs.

So what I need to do is get the Word Document that the user selected, and save the contents of that Word Document to a Word Document with a different, standardized name.

so what I have so far is

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

I know my readDoc variable contains the selected Word document contents, and it appears to do the ReadToEnd correctly, the problem now is, I need to be able to save those contents stored in readDoc to a different Word Document with a different name.

Any ideas on how to go about this?

Gerry Schmitz25-Jul-20 7:19

Gerry Schmitz

25-Jul-20 7:19

Once you have the file name, you don't have to "read" the file; you can just copy it with a new name.

File.Copy Method (System.IO) | Microsoft Docs

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

DerekT-P25-Jul-20 9:22

DerekT-P

25-Jul-20 9:22

No, because as I understand it, the file is being uploaded to a webserver. File.Copy works on the local system only; could be a bit of an issue if you could just copy files by name from a remote client!

Gerry Schmitz25-Jul-20 9:58

Gerry Schmitz

25-Jul-20 9:58

Frankly, I couldn't tell where he was planning to copy from or to, or why the document had to be opened. Congrats on your insight. And no, I wasn't "copying" from "client to server."

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.

It was only in wine that he laid down no limit for himself, but he did not allow himself to be confused by it.
― Confucian Analects: Rules of Confucius about his food

DerekT-P25-Jul-20 11:38

DerekT-P

25-Jul-20 11:38

True, it's certainly confusing. I'd latched on (probably incorrectly) to his reference to the "response object". But then it's posted in "General" rather than "Web" so you're probably right.

Richard MacCutchan25-Jul-20 21:59

Richard MacCutchan

25-Jul-20 21:59

Once you have read all the file data you just need to write it out to the place where it is to be saved:

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();
}

This is an over simplification, and could cause problems for Word document type files, as they are not text streams. A better solution would be to read and write byte arrays so the actual format of the file's content is copied verbatim.

Pita3226-Jul-20 6:37

Pita32

26-Jul-20 6:37

Hi Richard -

Yes this indeed is a Word document, which is the problem.

I get the Word document from the user via a popup modal, via the statement

HttpPostedFileBase filecontent = Request.Files[0];

it's when I try to do the save

filecontent.SaveAs(fullpath);

where it fails, as it writes out a blank document.

Could you give me an idea or example of your read and write bytes proposed solution? I'm not familiar.

Thanks, appreciate it.

Richard MacCutchan26-Jul-20 6:46

Richard MacCutchan

26-Jul-20 6:46

You are using an abstract class that does not do anything. You need to create your own class that is based on HttpPostedFileBase Class (System.Web) | Microsoft Docs[^] as explained in the documentation, and implement the methods that it contains.

Richard Deeming26-Jul-20 23:50

Richard Deeming

26-Jul-20 23:50

That's not correct. There's already a concrete class in the framework which inherits from HttpPostedFileBase. It's recommended to use the HttpPostedFileBase class in MVC so that it's easier to test.

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Richard MacCutchan27-Jul-20 0:03

Richard MacCutchan

27-Jul-20 0:03

My bad, but I couldn't see that in the documentation anywhere.