Problem in Data binding in V.B.Net kindly help

[Rohan101]

I am having problem with value member and display member property
when I do I am receiving error "cannot create childlist for feild employees"
here is the code

Dim con As New SqlConnection("workstation id=SWAP;packet size=4096;user id=sa;data source=swap;persist security info=False;initial catalog=Northwind")
Dim adpt As New SqlDataAdapter("select * from employees", con)
Dim ds As New DataSet
adpt.Fill(ds)
DataGrid1.DataSource = ds
'DataGrid1.DataMember = "employees"


ComboBox1.DataSource = ds
ComboBox1.ValueMember = "employees.firstname"
ComboBox1.DisplayMember = "employees.lastname"

[Ganon11]

I'm going to move this to the .NET forum, where I think you'll have a better chance of getting help.

[bplacker]

I am having problem with value member and display member property
when I do I am receiving error "cannot create childlist for feild employees"
here is the code

Dim con As New SqlConnection("workstation id=SWAP;packet size=4096;user id=sa;data source=swap;persist security info=False;initial catalog=Northwind")
Dim adpt As New SqlDataAdapter("select * from employees", con)
Dim ds As New DataSet
adpt.Fill(ds)
DataGrid1.DataSource = ds
'DataGrid1.DataMember = "employees"


ComboBox1.DataSource = ds
ComboBox1.ValueMember = "employees.firstname"
ComboBox1.DisplayMember = "employees.lastname"

I don't think you have to specify which table the data is coming from, just say ComboBox1.ValueMember = "firstname".

if this doesn't work, you might have to say
ComboBox1.ValueMember = ds.Tables(0).Columns("firstname")