Need help writing text file into listview with 8 columns

[kberrianjr]

I am currently working on a program to track my mile for my monthly expense report for work. Everything is working great, however, I can not for the life of me find a code to write 8 lines from the text file back into the listview on my form. I have found some samples that work for 2 to 4 columns, but not for 8. My code for saving the file is as follows:

Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Dim sfile As New SaveFileDialog
        With sfile
            .Title = "Choose your path to save the information"
            .InitialDirectory = "D:\"
            .Filter = ("ONLY Text Files (*.txt) | *.txt")
        End With

        If sfile.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
            Dim Write As New IO.StreamWriter(sfile.FileName)
            Dim k As ListView.ColumnHeaderCollection = ListView1.Columns
            For Each x As ListViewItem In ListView1.Items
                Dim StrLn As String = ""
                For i = 0 To x.SubItems.Count - 1
                    StrLn += k(i).Text + " :" + x.SubItems(i).Text + Space(3)
                Next
                Write.WriteLine(StrLn)
            Next
            Write.Close() 'Or  Write.Flush()
        End If

        Me.Close()
    End Sub

I just need help with writing everything back into the listview when the form loads. I have not had any luck with this part.

Thank you,
Kenneth

[ddanbe]

And what is your code for loading the file?
"Not having any luck" tells us very little.
Do you get errors, explain what's happening.
Please specify.

[Santanu.Das]

You can read this link to read a text file to get the lines.

[kberrianjr]

So the thing is I am having problems figuring out what the code should be, I need help with how to start the process. Everything I have looked at confuses me. If someone can point me in the right direction it would help me out alot.

[kberrianjr]

The way my code saves my data to the text file looks like this:

Vehicle :Toyota Sienna Date :1/1/2018 Starting Location :Office Starting Mileage :123 Destination :Waco ISD Ending Mileage :125 Total Mileage :2 Expense :$0.68
Vehicle :Toyota Sienna Date :1/1/2018 Starting Location :Waco ISD Starting Mileage :125 Destination :Office Ending Mileage :127 Total Mileage :2 Expense :$0.68
Vehicle :Toyota Sienna Date :1/1/2018 Starting Location :Office Starting Mileage :127 Destination :City of Waco Ending Mileage :129 Total Mileage :2 Expense :$0.68

What I need to do is add the data behind the : back into the listbox. Is there a way to do that? I do not want to add all the information like Vehicle :Toyota Sienna I just want to add Toyota Sienna. If this make sense.

[kberrianjr]

I think I want to change my code from saving into a text file to being saved into a database.

[tinstaafl]

I think your first step would be to get familiar with DataTables and the DataGridView control. These were specifically designed for viewing and editing the data to and from an SQL based database. There are plenty pf free tutorials that will help with this.

[kberrianjr]

Thank you, I will be looking into that soon. I eventually want to be able to search and edit entries that is why I decided to change from a text file to a database. I am fairly new to programming and would like to learn more about saving to databases

[Mr.M]

Its a good idea to do database but if your data is not too big and you don't worry that much with data loos then you can still continue with text file but since you are new I think you will have to read more in file streams, IO, just to name a few and there are ways also to search for data using also regex and delimitors and Array. I think thats what you need to look into.

[Reverend Jim]

I suggest you isolate your database read/write code in separate modules. That will make it easier to transition from one data source to another. The only code you would have to change would be isolated in one or two modules. You could start with a json, xml, or even csv file, get your app working, then move to an actual database at a later point.