Hey guys I am a VB noob and need some help, basically this is what I want to do please look at the following picture
The app should basically pull up the data contained within this CSV file :
CLICK FOR CVS FILE
and display it in the listview with 2 columns (with the values seperated for each column in the listview).
Here is that code I have so far (keep in mind I am a noob)
Dim objReader As IO.StreamReader
Dim intcount As Integer
Dim intcount2 As Integer
If IO.File.Exists("f:\surveydata.csv") = True Then
objReader = IO.File.OpenText("f:\surveydata.csv")
Do While objReader.Peek <> -1
_strRespondend(intcount) = objReader.ReadLine()
_strMilk(intcount) = objReader.ReadLine()
intcount += 1
Loop
For intcount = 0 To (_strRespondend.Length - 1)
Me.lstSurveyDisplay.Items.Add(_strRespondend(intcount))
'Do While objReader.Peek <> -1
'_strMilk(intcount2) = objReader.ReadLine()
'
' intcount2 += 1
'Loop
Next
For intcount2 = 0 To (_strMilk.Length - 1)
Me.lstSurveyDisplay.Items(intcount2).SubItems.Add(_strMilk(intcount2))
Next
objReader.Close()
Else
MessageBox.Show("The file is not available. Please restart the program when file is available.", "Error")
Me.Close()
End If
End Sub
Any idea how to go about this one? I'd really appreciate your input. Thanks~