title: How To Populate a DropDown List From a DataSet?
body: <p>I am trying to populate an ASP dropdown list in vb.net with the results from a stored procedure returned in a data set. I was wondering if anyone knew the vb.net code to populate the dropdown list?</p>
  
  <pre><code>Private Sub Form1_Load(sender As Object, e As EventArgs) Handles Me.Load
  
      Dim connString As String = "Server=MYCOMPUTER\SQLEXPRESS;Database=scales;Trusted_Connection=True"
      Dim myConn As New SqlConnection(connString)
      myConn.Open()
      Dim da As New SqlDataAdapter("select scaleName from scales", myConn)
      Dim dt As New DataTable
      da.Fill(dt)
  
      ComboBox1.DisplayMember = "scaleName"
  
      ComboBox1.DataSource = dt
      myConn.Close()
  </code></pre>