Load values of a comboBox from a TableAdapter

[lanz80]

Hi,

I would like to how I can load a set of values in a comboBox from a TableAdapter. I have the tableAdapter method to read the data , (in this case GetDataByStreet)--> Me.StreetsTableAdapter.GetDataByStreet()

But I don't know how to assign the sentence to the comboBox, in order to load the data set in it.

Thanks with anticipation.

Regards

[lanz80]

I have created this code to prove:

 
StreetCombo.DisplayMember = "AreaClasification"
StreetCombo.ValueMember = "AreaClasification"
StreetCombo.DataSource = Me.StreetTableAdapter.GetDataByStreet()

But I doesn´t work because only fills the first index of the comboBox, but not the following values.

[jmcilhinney]

If there's only one value in your ComboBox then your query only matches one record, plain and simple.

Also, "classification" is double "s".