Load a csv file into a DataGrid in Silverlight.

See more:

VB

Silverlight

Anyone know how to load a DataGrid with a csv file? In Winforms it was quite easy by means of dg.Rows.Add({object()}). This method is not available in the Silverlight DataGrid. If there is another approach to displaying this kind of data I am open to suggestions.

The trick here that I need it to be dynamic. Open any csv file of diff number of columns without prior knowledge.

Searching - yeah my tail off, nothing matches my criteria.

My attempt:

Dim ofd As New OpenFileDialog
     If ofd.ShowDialog Then
       If IO.File.Exists(ofd.File.FullName) Then
         Dim srsCol As New List(Of String())
         Using fs As IO.FileStream = ofd.File.OpenRead
           Using sr As New IO.StreamReader(fs)
             While Not sr.Peek = -1
               srsCol.Add((sr.ReadLine.Split(","c).ToArray))
             End While
           End Using
         End Using
         dgStaff.ItemsSource = srsCol
       End If
     End If