Populating Combo Box from sql

[lolwtf]

I don't use combo boxes very much, so I basically forgot how to use them. Im connecting to an SQL database and I just want to populate a combo box with a users first name. Heres what I have so far:

DBATimeOff.SelectCommand.CommandText = "SELECT FName FROM tblEmployee"
DBATimeOff.Fill(DataTimeOff)

CmbEmployee.DisplayMember = "FName"
CmbEmployee.ValueMember = "EmployeeID"

Am I even close?

Thanks in advance

[jbisono]

Ok once you have a connection set up, the easiest way to go is using a dataset you can basically do this. i did not test this.

Dim statement As String = "SELECT EmployeeId, FName FROM tblEmployee"
Dim adapt As New SqlDataAdapter(statement,connection)
Dim ds As New DataSet()
connection.Open()
adapt.Fill(ds)
connection.Close()
CmbEmployee.DataSource = ds
CmbEmployee.DisplayMember = "FName"
CmbEmployee.ValueMember = "EmployeeID"
CmbEmployee.DataBind()

regards.

[lolwtf]

I could not get that code to work. Heres my full code if it helps:

OdbcConnection1.Open()

DBATimeOff.SelectCommand.CommandText = "SELECT FName FROM tblEmployee"

DBATimeOff.Fill(DataTimeOff)

CmbEmployee.DataSource = DataTimeOff

CmbEmployee.DisplayMember = "FName"

[kvprajapati]

Wrap source code with BB code tag - See # icon at toolbar.

Post your complete code and error description.

[lolwtf]

OdbcConnection1.Open()


        DBATimeOff.SelectCommand.CommandText = "SELECT FName FROM tblEmployee"






        DBATimeOff.Fill(DataTimeOff)



        CmbEmployee.DataSource = DataTimeOff

        CmbEmployee.DisplayMember = "FName"

I dont get any errors, but the combo box is not populating. Instead, the combo box is displaying this:
System.Data.DataViewManagerListItemTypeDescriptor

I think something weird is happening with the dataset.

[kvprajapati]

I said "post your complete code".

If DataTimeOff is an instance of DataTable then use following code:

CmbEmployee.DataSource = DataTimeOff
       CmbEmployee.DisplayMember = DataTimeOff.Columns(0).ColumnName

and If DataTimeOff is DataSet instance then use following code:

CmbEmployee.DataSource = DataTimeOff.Tables(0)
       CmbEmployee.DisplayMember = DataTimeOff.Tables(0).Columns(0).ColumnName

[lolwtf]

That did it! thank you!