Vb.net – How to read txt files and display the results in a grid headers in Visual Basic 2010 express

datagridviewvb.net

This sounds so simple but I still can't find the answer to it after googling for a while. I have DataGridView on a form and it's called DataGridView1. I have two txt files (with single columns in each) data and I want to be able to display them as Row & Column headings (not as cell contents). For example, the two txt files are

C:\temp\sObj.txt
C:\temp\sQue.txt

Now:
sObj.txt contains data a, b & c in a single column &
sQue.txt contains data d, e & f in a single column.
Now what I want looks like:

a  b  c
d
e
f

Please help, I'm a beginner in programming & need this be done urgently.

Best Answer

As I already said in the comment section, you need a StreamReader to read the lines of your textfile. First of all you have to import the System.IO-namespace:

Import System.IO

So declare your StreamReader with the filepath to your textfile and read each line in it.

Then you have to add the text of your StreamReader as a Column to your DataGridView. The first parameter is the ColumnName, the second is the ColumnHeading:

Using reader As New StreamReader(@"YOURFILEPATHHERE")
    DataGridView1.Columns.Add(reader.ReadLine(),reader.ReadLine())
End Using

So now you have added your columns. Adding your Rows is easier:

Simply read the lines and add your Rows with your String (linetext) as the parameter:

DataGridView1.Rows.Add(reader.ReadLine())

It's pretty easy and you could have done that with minimal research.

Related Solutions

C# – How to automatically resize columns in a DataGridView control AND allow the user to resize the columns on that same grid

This trick works for me:

    grd.DataSource = DT;

    // Set your desired AutoSize Mode:
    grd.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    grd.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
    grd.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;

    // Now that DataGridView has calculated it's Widths; we can now store each column Width values.
    for (int i = 0; i <= grd.Columns.Count - 1; i++)
    {
        // Store Auto Sized Widths:
        int colw = grd.Columns[i].Width;

        // Remove AutoSizing:
        grd.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;

        // Set Width to calculated AutoSize value:
        grd.Columns[i].Width = colw;
    }

In the Code above: You set the Columns AutoSize Property to whathever AutoSizeMode you need. Then (Column by Column) you store each column Width value (from AutoSize value); Disable the AutoSize Property and finally, set the Column Width to the Width value you previously stored.

Vb.net – How to read a CSV file and display the results in a grid in Visual Basic 2010

Use the TextFieldParser class built into the .Net framework.

Here's some code copied from an MSDN forum post by Paul Clement. It converts the CSV into a new in-memory DataTable and then binds the DataGridView to the DataTable

    Dim TextFileReader As New Microsoft.VisualBasic.FileIO.TextFieldParser("C:\Documents and Settings\...\My Documents\My Database\Text\SemiColonDelimited.txt")

    TextFileReader.TextFieldType = FileIO.FieldType.Delimited
    TextFileReader.SetDelimiters(";")

    Dim TextFileTable As DataTable = Nothing

    Dim Column As DataColumn
    Dim Row As DataRow
    Dim UpperBound As Int32
    Dim ColumnCount As Int32
    Dim CurrentRow As String()

    While Not TextFileReader.EndOfData
        Try
            CurrentRow = TextFileReader.ReadFields()
            If Not CurrentRow Is Nothing Then
                ''# Check if DataTable has been created
                If TextFileTable Is Nothing Then
                    TextFileTable = New DataTable("TextFileTable")
                    ''# Get number of columns
                    UpperBound = CurrentRow.GetUpperBound(0)
                    ''# Create new DataTable
                    For ColumnCount = 0 To UpperBound
                        Column = New DataColumn()
                        Column.DataType = System.Type.GetType("System.String")
                        Column.ColumnName = "Column" & ColumnCount
                        Column.Caption = "Column" & ColumnCount
                        Column.ReadOnly = True
                        Column.Unique = False
                        TextFileTable.Columns.Add(Column)
                    Next
                End If
                Row = TextFileTable.NewRow
                For ColumnCount = 0 To UpperBound
                    Row("Column" & ColumnCount) = CurrentRow(ColumnCount).ToString
                Next
                TextFileTable.Rows.Add(Row)
            End If
        Catch ex As _
        Microsoft.VisualBasic.FileIO.MalformedLineException
            MsgBox("Line " & ex.Message & _
            "is not valid and will be skipped.")
        End Try
    End While
    TextFileReader.Dispose()
    frmMain.DataGrid1.DataSource = TextFileTable

Best Answer

Related Solutions

C# – How to automatically resize columns in a DataGridView control AND allow the user to resize the columns on that same grid

Vb.net – How to read a CSV file and display the results in a grid in Visual Basic 2010

Related Topic