How to read text file data and display in datagridview with VB.NET

Question

1.00/5 (1 vote)

See more:

In my project I'm using a data grid to display the information that has been saved into the textile (Stock related information). I have used the code below and the error that is showing is "Index was outside the bounds of the array". Has anyone got any suggestions?
It would be appreciated.

What I have tried:

Dim fname As String = "C:\Users\Windows 7 User\Desktop\Stock.txt"
        Dim colsexpected As Integer = 8
        Dim thereader As New StreamReader(fname, Encoding.Default)
        Dim sline As String
        Do
            sline = thereader.ReadLine
            If sline Is Nothing Then Exit Do
            Dim words() As String = sline.Split(",")
            DataGridView1.Rows.Add("")
            For ix As Integer = 0 To 7
                DataGridView1.Rows(DataGridView1.Rows.Count - 1).Cells(ix).Value = words(ix)

            Next

        Loop

        thereader.Close()

Posted 6-Jan-18 3:50am

faiqaa

Updated 7-Jan-18 7:08am

v2

Add a Solution

Comments

Kenneth Haugland 6-Jan-18 10:28am

If its WPF I can help, but this feels like WinFroms? So is it?

faiqaa 6-Jan-18 11:38am

Yes it's WinForms.

Richard MacCutchan 6-Jan-18 12:11pm

What does "nothing is working for me" mean?

faiqaa 6-Jan-18 14:56pm

I meant that I have looked online at other solutions but none of them has helped me in solving my issue.
Thanks

Richard MacCutchan 6-Jan-18 15:25pm

What issue?

faiqaa 6-Jan-18 16:52pm

The issue is that I'm currently not able to display the data saved on a text file into a data grid.

Valery Possoz 7-Jan-18 4:33am

A few things to check:
- have you created the grid columns? if they do not exist it will throw an exception.
- Your casting of values is weird. If the data is not what the code expects it will crash.
- ProductName is a string but you cast it as an integer, if you have a string in the text file it will crash.
- Quantity is an integer but you do not cast it. It is likely to throw an exception.

use the debugger it will be obvious, it is a good opportunity to learn about exception handling.

Once you solve this, it will work.

faiqaa 7-Jan-18 13:04pm

Hi sir and yes I'm using grid columns (4), I have tried using this code:

Dim fname As String = "C:\Users\Windows 7 User\Desktop\Stock.txt"
Dim colsexpected As Integer = 4
Dim thereader As New StreamReader(fname, Encoding.Default)
Dim sline As String
Do
sline = thereader.ReadLine
If sline Is Nothing Then Exit Do
Dim words() As String = sline.Split(",")
DataGridView1.Rows.Add("")
For ix As Integer = 0 To 3
DataGridView1.Rows(DataGridView1.Rows.Count - 1).Cells(ix).Value = words(ix)

Next

Loop

thereader.Close()

However it still gives me an error "The Index was outside the bounds of the array"

Richard Deeming 9-Jan-18 13:11pm

The most likely problem is that one or more lines in your text file don't contain three commas. For example, there might be a blank line at the end of the file.

faiqaa 10-Jan-18 3:47am

Hi sir,
what changes would you recommend me? hmm a blank line at the end? the thing is that I need to save stock information so I would keep adding and removing it, display it in a data grid later, I don't know how to deal with this issue.

Richard Deeming 10-Jan-18 8:38am

Check the length of the words array. Limit your ix loop to the minimum of the length of the array or the number of columns in your datagrid.

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)

Maciej Los · Answer 1 · 2018-01-06T23:10:00

The best way to read delimited text file is to use OleDb[^].
An example code you'll find here: Read Text File Specific Columns[^]

I'd recommend to read also:
Much ADO About Text Files[^]
Schema.ini File (Text File Driver) | Microsoft Docs[^]
How to: Add a Schema Definition to a Text File Data Source[^]
Using OleDb to Import Text Files (tab, CSV, custom)[^]

Good luck!