Re: Add a listview cell - C# Discussion Boards

ago248627-Jul-20 2:31

27-Jul-20 2:31

ok thank you i'm getting started

Re: Add a listview cell

OriginalGriff27-Jul-20 2:59

OriginalGriff

27-Jul-20 2:59

You're welcome!

"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!

Re: Add a listview cell

ago248627-Jul-20 3:18

ago2486

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

        }

Re: Add a listview cell

OriginalGriff27-Jul-20 3:37

OriginalGriff

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.

Re: Add a listview cell

ago248627-Jul-20 4:08

ago2486

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.

Re: Add a listview cell

OriginalGriff27-Jul-20 4:38

OriginalGriff

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.

Re: Add a listview cell

ago248627-Jul-20 4:45

ago2486

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.

Re: Add a listview cell

ago248627-Jul-20 4:53

ago2486

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

        }

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

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?

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

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

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

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!

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

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

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

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.

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

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.

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

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.

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

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.

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

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

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

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.

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

Richard Deeming26-Jul-20 23:51

Richard Deeming

26-Jul-20 23:51

fileContent.SaveAs should work fine. Are you reading the posted file multiple times?

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

Get List Of SQL Foreign Keys Using C#

Kevin Marois24-Jul-20 6:46

Kevin Marois

24-Jul-20 6:46

I've been Googling this but I can't seem to find an answer. How can I get a list of foregin keys for a table ini SQL using C#?

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

Re: Get List Of SQL Foreign Keys Using C#

Richard Deeming24-Jul-20 7:29

Richard Deeming

24-Jul-20 7:29

For SQL Server, select from the sys.foreign_keys view:
sys.foreign_keys (Transact-SQL) - SQL Server | Microsoft Docs[^]

SQL

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

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

Re: Get List Of SQL Foreign Keys Using C#

Kevin Marois24-Jul-20 7:42

Kevin Marois

24-Jul-20 7:42

I want to do it using C#

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

Re: Get List Of SQL Foreign Keys Using C#

Dave Kreskowiak24-Jul-20 7:49

Dave Kreskowiak

24-Jul-20 7:49

It's no different from executing a SELECT on any other database tables.

You can use a normal SqlConnection and SqlCommand objects and execute a reader, or just use a SqlDataAdapter and just fill a DataTable.

Asking questions is a skill
CodeProject Forum Guidelines
Google: C# How to debug code
Seriously, go read these articles.

Dave Kreskowiak

Re: Get List Of SQL Foreign Keys Using C#

Kevin Marois24-Jul-20 7:53

Kevin Marois

24-Jul-20 7:53

True. Thanks

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

Re: Get List Of SQL Foreign Keys Using C#

Kevin Marois24-Jul-20 7:53

Kevin Marois

24-Jul-20 7:53

Thanks!

If it's not broken, fix it until it is.
Everything makes sense in someone's mind.
Ya can't fix stupid.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.