Dgv csv

[.paul.]

as you're using vb2010:

1,Chai,boxes x 20 bags,$18.00
2,Chang,24 - 12 oz bottles,$19.00
3,Aniseed Syrup,12 - 550 ml bottles,$10.00
4,Chef Anton's Cajun Seasoning,48 - 6 oz jars,$22.00
5,Chef Anton's Gumbo Mix,36 boxes,$21.35
6,Grandma's Boysenberry Spread,12 - 8 oz jars,$25.00
7,Uncle Bob's Organic Dried Pears,12 - 1 lb pkgs.,$30.00
8,Northwoods Cranberry Sauce,12 - 12 oz jars,$40.00
9,Mishi Kobe Niku,18 - 500 g pkgs.,$97.00
10,Ikura,12 - 200 ml jars,$31.00

Public Class Form1
 
    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
        Dim lines() As String = IO.File.ReadAllLines("csv.txt")
        Dim dt As New DataTable
        dt.Columns.AddRange(New DataColumn() {New DataColumn("id"), New DataColumn("name"), New DataColumn("quantity"), New DataColumn("price")})
        Array.ForEach(lines, Sub(line) dt.Rows.Add(line.Split(","c)))
        datagridview1.datasource = dt
    End Sub
 
End Class