how to read csv file from url

Question

Hi

I want to read csv file from the following URL and bind with DataGrid

http://www.votrecourse.com/medias/xml/?C=M;O=D/timetrial.csv"

pls help me in this

Answer 1

Here is an example of how you can read a CSV file from a URL and bind it to a DataGrid in .NET using VB:

First, you'll need to add a reference to the System.Web assembly in your project.

Next, use the WebClient class to download the CSV file from the URL:

Dim client As New WebClient()
Dim data As String = client.DownloadString("http://www.votrecourse.com/medias/xml/?C=M;O=D/timetrial.csv")

Next, you can use the TextFieldParser class to parse the CSV file and load it into a DataTable:

Dim table As New DataTable()
Using parser As New TextFieldParser(New StringReader(data))
    parser.TextFieldType = FieldType.Delimited
    parser.SetDelimiters(",")
    Dim headers() As String = parser.ReadFields()
    For Each header As String In headers
        table.Columns.Add(header)
    Next
    While Not parser.EndOfData
        Dim fields() As String = parser.ReadFields()
        table.Rows.Add(fields)
    End While
End Using

Finally, you can bind the DataTable to the DataGrid:

DataGrid1.DataSource = table
DataGrid1.DataBind()

This is a simple example, you may need to add some error handling and validation depending on your needs.