HI,
I was able to read the csv data and display the data in the Datagridview but I didn't know how to save those data in array form. My code looks like following:
If anyone could give hints on how to save data on arrarys that would be great because I want to plot graphs from the loaded csv data.Code:Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try OpenFileDialog1.ShowDialog() Using MyReader As New Microsoft.VisualBasic. FileIO.TextFieldParser(OpenFileDialog1.FileName) MyReader.TextFieldType = FileIO.FieldType.Delimited MyReader.SetDelimiters(",") Dim currentRow As String() While Not MyReader.EndOfData Application.DoEvents() Try currentRow = MyReader.ReadFields() With DataGridView1 .ColumnCount = 2 Dim row As String() = New String() {currentRow(0), currentRow(1)} .Rows.Add(row) End With Catch ex As Microsoft.VisualBasic. FileIO.MalformedLineException MsgBox("Line " & ex.Message & "is not valid and will be skipped.") End Try End While End Using Catch ex As Exception End Try End Sub
Thanks.




Reply With Quote
