title: VB.NET fill combobox from access from only one field
body: <p>I am still learning vb.net and I am messing with accessing a database. I have a combobox that I want to be populated by a only one field from access, because I do not want to create many columns, the field is like this "Very good; Good; Normal; Bad; Very bad". I would like to know if is possible to divide the values in the combobox. So it would be:</p>
  
  <pre><code>Very Good
  Good
  Normal
  Bad
  Very Bad
  </code></pre>
  
  <p>I saw in the internet that if the values were in different fields, is possible to do it. but to divide from one only one field it can be done?  </p>
  
  <pre><code>If retVal Then
  
          Dim somestring As String = rs.Fields("Answer").Value
          Dim somestring2() As String
      somestring2 = somestring.Split(";")
  
          For i = 0 To somestring2.Length - 1
              While dr.Read
                  ComboBox1.Items.Add(dr.GetString(somestring2(i)))
  
              End While
              dr.Close()
  
          Next
  
      End If
  </code></pre>
  
  <p>I am having this trouble! Why?</p>
  
  <blockquote>
    <p>Conversion from string "Very bad" to type 'Integer' is not valid.</p>
  </blockquote>