title: How to get all rows for particular column from database in combobox in VB.net?
body: <p>Here I am trying to get column from database in combo box.<br>
  The code below causes combo box to have <code>System.Data.DataViewManagerListItemTypeDescriptor</code> in the combo box.<br>
  What I'm I missing in my code?</p>
  
  <pre><code>Imports System.Data
  Imports System.Data.OleDb
  
  Public Class Sales
      Private Const s As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\HOME\Desktop\Project\company\company\login.mdb"
      Public conn As OleDbConnection
      Public adapt As OleDbDataAdapter
      Public ds As DataSet
      Public tables As DataTableCollection
      Public table As DataTable
      Public rows As DataRowCollection
      Public row As DataRow
      Public cols As DataColumnCollection
      Public col As DataColumn
      Public sql As String
      Public isql, usql, dsql As String
      Public icmd, ucmd, dcmd As OleDbCommand
      Public p As OleDbParameter
  
      Private Sub Sales_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
          'TODO: This line of code loads data into the 'LoginDataSet1.Login' table. You can move, or remove it, as needed.
          Me.LoginTableAdapter.Fill(Me.LoginDataSet1.Login)
          Try
              sql = "select cust_ID from Customer"
              conn = New OleDbConnection(s)
              adapt = New OleDbDataAdapter(sql, conn)
              ds = New DataSet
              conn.Open()
  
              adapt.Fill(ds, "ABC")
              ComboBox1.DataSource = ds
              ComboBox1.DisplayMember = "cust_ID"
              ComboBox1.ValueMember = "cust_ID"
  
  
              conn.Close()
  
          Catch ex As Exception
  
          End Try
      End Sub
  End Class
  </code></pre>