CODEWITHSUNDEEP
vb.netcsvdatagridview
noahtot
noahtot

Reputation: 13

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

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?

Upvotes: 1

Views: 11756

Answers (2)

tinstaafl
tinstaafl

Reputation: 6948

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

Upvotes: 9

OneFineDay
OneFineDay

Reputation: 9024

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.

Upvotes: 0

Related Questions