How to use the textbox data for data saving location of my datagridview data

Question

0.00/5 (No votes)

See more:

Can someone help me with my problem?
I already have a program that saves my data in the location I declared in the program (D:\Data Save\).
What I want now is I choose the location using the folder browser dialog that pastes the location in a textbox. This one I can browse already and paste the location in the text box. But the problem is when I change the (D:\Data Save\) into my textbox the data is not saving.
I'm working on this for many days already. So I need help from the expert.

In my current program, I declare the D:\Data Save\ for the location, but I want to change it depending on the location I choose in my text label using the folder browser dialog.
Thank you in advance.

What I have tried:

VB

Using sw As StreamWriter = File.CreateText("D:\Data Save\" + DateTime.Now.ToString("ddMMyyyy_hhmmss") & "_Line" & Form1.LineTxt.Text + ".csv")
    Dim dgvColumnNames As List(Of String) = Form1.DataGridView1.Columns.
            Cast(Of DataGridViewColumn).ToList().
            Select(Function(c) c.Name).ToList()

    sw.WriteLine(String.Join(",", dgvColumnNames))

    For Each row As DataGridViewRow In Form1.DataGridView1.Rows

        Dim rowData As New List(Of String)
        For Each column As DataGridViewColumn In Form1.DataGridView1.Columns
            rowData.Add(Convert.ToString(row.Cells(column.Name).Value))
        Next
        sw.WriteLine(String.Join(",", rowData))
        sw.Close()
    Next

End Using

Posted 9-Aug-23 18:37pm

Marlon Rivera

Updated 9-Aug-23 20:08pm

Sandeep Mewara

v2

Add a Solution

Comments

Marlon Rivera 10-Aug-23 3:39am

Thank you so much. It works 100%.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2023-08-09T20:08:00

That code uses a fixed path - it always saves under the "D:\Data Save\" folder, but includes the data from your textbox as part of the file name.
Which means that if textbox contains "E:\MyFolder", the final path string you try to use will be something like this:

Path

D:\Data Save\10082023_070135_LineE:\MyFolder.csv

If you want the folder location to be in the textbox, then you need to replace the folder part with the textbox content:

VB

Dim pathToFile as String = Form1.LineTxt.Text + DateTime.Now.ToString("ddMMyyyy_hhmmss") & "_Line.csv"
Using sw As StreamWriter = File.CreateText(pathToFile)

Or better:

VB

Dim pathToFile as String = Path.Combine(Form1.LineTxt.Text, DateTime.Now.ToString("ddMMyyyy_hhmmss") & "_Line.csv"
Using sw As StreamWriter = File.CreateText(pathToFile)

Because it adds "/" separators as needed.

BTW: it's a much better idea to use ISO date format:

VB

... DateTime.Now.ToString("yyyyMMdd_hhmmss") ...

as the resulting file names are easily sorted into ascending or descending order (and there is less confusion if teh system is set to US date format).