title: data reader in vb.net
body: <p>Please help, how do I make a while loop  equivalent of this for loop. So that I could read from one row in the table of mysql database and display  it on the combobox in vb.net.</p>
  
  <p>I use this code, but its definitely not useful if there are 3 or more items that are added in the row:</p>
  
  <pre><code>Dim i As Integer
          Dim rdr As Odbc.OdbcDataReader
          rdr = con.readfrom_drug_type_table()
      For i = 0 To 1
          If rdr.HasRows = True Then
              rdr.Read()
  
              ComboBox2.Items.Add(rdr("Drug_type"))
          End If
      Next i
  </code></pre>
  
  <p>I want to read all the data from that the Drug_type row
  Please help, thanks</p>