title: Showing all fields in listbox from database, vb.net
body: <p>I'm trying to make a list box to show all the fields of a particular table in an Access database.  I have a few tables, and the idea would be to have each table loaded by a different button (and the items in the box cleared).  One trick is that tables aren't all the same size.  How do I get all the fields to show up for each table.  What I have now is only showing one field:</p>
  
  <pre><code>Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
      Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;data source='C:\dummy_data.accdb';"
      Dim conn As New OleDbConnection(connString)
      Dim sql As String = "SELECT * FROM Customers"
      Dim cmd As New OleDbCommand(sql, conn)
      conn.Open()
      Dim reader As OleDbDataReader = cmd.ExecuteReader()
      ClientList.Items.Clear()
      While reader.Read()
          ClientList.Items.Add(reader(0).ToString())
      End While
      reader.Close()
      conn.Close()
  
  End Sub
  </code></pre>