Load values of a comboBox from a TableAdapter

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

I have created this code to prove:

Code:

---


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.

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

Also, "classification" is double "s".