I have to read a CSV file in with 6 columns of data. The last column contains values delimited by & eg.
"Lastname","FirstName","Zip","Phone","Area","001&0 02%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.
Expand|Select|Wrap|Line Numbers
- 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