Hi
I have to read a CSV file in with 6 columns of data. The last column contains values delimited by & eg.
"Lastname","Fir stName","Zip"," Phone","Area"," 001&002%008&012 "
There are 100's of these rows in this CSV file. I have created a DGV with the type in the last column set to ComboBox and I have parsed the last column into a String array.
Question I have is, how do I load the contents of that array into the Combobox?
I have tried this but it does not work.
Any help would be appreciatted.
Thanks
I have to read a CSV file in with 6 columns of data. The last column contains values delimited by & eg.
"Lastname","Fir stName","Zip"," Phone","Area"," 001&002%008&012 "
There are 100's of these rows in this CSV file. I have created a DGV with the type in the last column set to ComboBox and I have parsed the last column into a String array.
Question I have is, how do I load the contents of that array into the Combobox?
I have tried this but it does not work.
Code:
Dim comboboxColumn As New DataGridViewComboBoxCell
Temp2 = Split(Temp1, "&", , CompareMethod.Text)
For I = 0 To Temp2.GetLength(0) - 1
comboboxColumn.Items.Add(Temp2(I))
Next
DGV1.Rows(myRowCounter).Cells("colCodes") = comboboxColumn
Thanks
Comment