Populating dropdownlist with data

[greg_quinn]

I'm an asp.net programmer and am getting my feet wet with windows apps in visual studio.net.

I can populate a dropdownlist on a web page with

Dim sql as String = "Select Id, NAme from Table"
Dim objCommand As New OdbcCommand(sql, objConnection)
objConnection.Open()
Dim objDataReader As OdbcDataReader
objDataReader = objCommand.ExecuteReader()

myList.DataSource = objDataReader
myList.DataBind()

objDataReader.Close()
objConnection.Close()
End Sub

But in vs.net in my windows app it tells me that Databind is not a member of comboBox.

What is the easiest way to populate a dropdownlist in vs.net for a windows app.

Thanks

[taxes]

Hi,

Not sure about Web Pages, but in ordinary VB.NET as well as setting A combobox datasource, you need to

cboName1.DisplayMember = "PlayerName"
            cboName1.ValueMember = "PlayerID"

(copied from one of my projects)

[brown monkey]

sorry for bothers... just want to add something...

Dim cn As New OdbcConnection()
   Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
      cn.ConnectionString = "driver={mysql odbc 3.51 driver};database=temp"
      cn.Open()
   End Sub
 
   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
      Dim cmdtext As String = "insert into xtable values('" & TextBox1.Text & "','" & TextBox2.Text & "')"
      Dim cm As New OdbcCommand(cmdtext, cn)
      cm.ExecuteNonQuery()
   End Sub
 
   Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
      Dim cmdtext As String = "select * from xtable"
 
      Dim da As New OdbcDataAdapter()
      da.SelectCommand = New OdbcCommand(cmdtext, cn)
 
      Dim dt As New DataTable()
      da.Fill(dt)
 
      With ComboBox1
         .DataSource = dt
         .DisplayMember = "xname"
         .ValueMember = "xid"
      End With
   End Sub

hope this helps...