Diaplay contents of a CSV File

[Dodger]

Hi Dennis,

Here is some code to display CSV data in a datagrid. I realize this reply is a bit late, but it may help someone else.

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim xDataSet As New Data.DataSet()
        Dim xTable As New DataTable()
        Dim xFile As StreamReader = New StreamReader("C:\csvpath.csv")

        With xTable.Columns
            .Add("Column0")
            .Add("Column1")
        End With

        While xFile.Peek <> -1
            xTable.Rows.Add(Split(xFile.ReadLine, ",", , CompareMethod.Text))
        End While

        xDataSet.Tables.Add(xTable)
        DataGrid1.DataSource = xDataSet
End Sub

_Dodger.