Home > Code Samples > Display CSV file in GridView in VB
Display a CSV File in a GridView on an ASP.Net page
VB.Net
Private Sub _Default_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' declare a new GridView
Dim csvGrid As New GridView()
' add GridView to page
Form.Controls.Add(csvGrid)
' declare csv parser passing in path to file
Using csvData = New CsvReader(Server.MapPath("products.csv"))
' set GridView to use DataTable returned from parser as the source
' for it's data. True is passed in to signify that file contains a
' header row which will name returned DataColumn's based on values
' read in from header row.
csvGrid.DataSource = csvData.ReadToEnd(True)
End Using ' dispose of parser
' tell GridView to create display based on values from DataSource
csvGrid.DataBind()
End Sub
|