How to import csv file in Datagridview with certain columns and rows?

Question

I'm new to VB.net and I don't know how to display certain columns and rows in datagridview that was imported from CSV file. My problem is I have many columns and all I want to display is 2 columns:

Name,Age,Mobile Number,ID number

Alex,18,09848484841,0010

George,19,02987654321,0020

Toni,17,09277470257,0030

How can I display only the Name & Age columns and its rows?

tinstaafl · Accepted Answer · 2013-10-22 15:04:03Z

9

If you use a datatable you get the data structure and collection together. something like this:

    Dim sr As New IO.StreamReader(filename)
    Dim dt As New DataTable
    Dim newline() As String = sr.ReadLine.Split(","c)
    dt.Columns.AddRange({New DataColumn(newline(0)), _
                         New DataColumn(newline(1))})
    While (Not sr.EndOfStream)
        newline = sr.ReadLine.Split(","c)
        Dim newrow As DataRow = dt.NewRow
        newrow.ItemArray = {newline(0), newline(1)}
        dt.Rows.Add(newrow)
    End While
    DataGridView1.DataSource = dt

answered Oct 22, 2013 at 15:04

tinstaafl

6,9782 gold badges17 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

noahtot Over a year ago

That's what I'm talking about man! You got it! Thank you. You're the man.

Aljie Over a year ago

Hey @tinstaff, When im using this code, i got the error of "Index was outside the bounds of the array." in the code newrow.ItemArray = {newline(0), newline(1)}

tinstaafl Over a year ago

@Aljie, If the line that readline reads, doesn't have at least 2 fields separated by a comma then the newline array won't have enough indexes. You might need a conditional to check if newline's length is at least 2. Sometimes a file will have empty lines in it. This can also happen if the data isn't strongly validated before it's written to the file.

OneFineDay · Accepted Answer · 2013-10-22 04:06:21Z

0

Use a custom class with properties that match the data you want to store and make an instance of that class for each row of data use read, then have a List(Of {custom class}) to hold each object and the DGV's DataSource property can view the collection in the grid. The property names in the class will be used as the header.

answered Oct 22, 2013 at 4:06

OneFineDay

9,0344 gold badges28 silver badges37 bronze badges

Collectives™ on Stack Overflow

How to import csv file in Datagridview with certain columns and rows?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related