CSV to DataGrid in VB.NET

Question

I don't know how to load my CSV file load into a datagrid view in vb2005.

I have two records as the following

9,N,010324405,,,,,,,,05071958,UU,Yoeun,,,,,,,,,,,M,M,KHM,,P,RESID,,,,,"St. Lum,Phum Ti Pir,Chrouy Changva,Ruessei Kaev",,,,PP,,KHM,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,215,S,,DDD_70300098149,21082012,PLN,KHR,6000,1206013,N,N,6000,M,,12042013,67000.00,NO,120000,0,12052013,0,30042013,,,,

10,N,00032529,,,,,,,,18021962,SDM,Sok,,,,,,,,,,,M,M,KHM,,P,RESID,,,,,"#281,Phum Ti Muoy,Chrouy Changva,Ruessei Kaev",,,,PP,,KHM,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,215,S,,DDD_703004167,20022013,PLN,KHR,10000,1510013,N,N,12000,M,,1802013,15660.00,NO,75000,0,1505213,0,3002013,,,,

My code:

For Each line As String In System.IO.File.ReadAllLines(pathname)
        DataGridView1.Rows.Add(line.Split(","))
Next

I want to read this format load to datagridview, any solution?

Don't use split, it will generate wrong result.

David -
– David -

2013-07-12 08:14:20 +00:00
Commented Jul 12, 2013 at 8:14 — David -
– David -, Commented Jul 12, 2013 at 8:14

David - · Accepted Answer · 2013-07-12 10:20:43Z

5

Try the following code

Dim TextFieldParser1 As New Microsoft.VisualBasic.FileIO.TextFieldParser(pathname)

TextFieldParser1.Delimiters = New String() {","}

While Not TextFieldParser1.EndOfData
    Dim Row1 As String() = TextFieldParser1.ReadFields()

    If DataGridView1.Columns.Count = 0 AndAlso Row1.Count > 0 Then
        Dim i As Integer

        For i = 0 To Row1.Count - 1
            DataGridView1.Columns.Add("Column" & i + 1, "Column" & i + 1)
        Next
    End If

    DataGridView1.Rows.Add(Row1)
End While

answered Jul 12, 2013 at 10:20

David -

2,0311 gold badge13 silver badges9 bronze badges

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

Comments

geekonweb · Accepted Answer · 2013-07-12 08:51:36Z

0

Check the example with CSV library:

at Codeproject

answered Jul 12, 2013 at 8:51

geekonweb

3944 silver badges14 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 11:51:37Z

0

You can follow this url, using OLEDBCommand you can read CSV format. Take a look at p.campbell's solution.

edited May 23, 2017 at 11:51

CommunityBot

11 silver badge

answered Jul 12, 2013 at 9:30

NeverHopeless

11.2k4 gold badges37 silver badges56 bronze badges

2 Comments

Jam Dara Over a year ago

can give me example coding.

NeverHopeless Over a year ago

Have you checked the link and tried p.campbell's answer ? Its an example code.

Collectives™ on Stack Overflow

CSV to DataGrid in VB.NET

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related