ComboBox trouble

[DayWalker]

I am filling a combobox from a sql table.

ie:

 

Dim dataAdapter as new SqlDataAdapter("SELECT ID, Barcode FROM Table WHERE Barcode = ' " & txtBarcode.text & " '", Connection)

Dim DataSet as new DataSet

 

dataAdapter.Fill(DataSet, "Table")

 

With combobox

.datasource = DataSet.Tables("Table")

.DisplayMember = "ID"

End With

 

It works fine the problem is there are about 12 ID's with the value of 1; 2 ect. All with the same barcodes.

Is there a way to only display 1 instance of 1 and 1 instance of 2..ect in the combobox??

[DayWalker]

I tired using "Select Distinct ........" but it throws a error??

[PlausiblyDamp]

What error did it give?

[DayWalker]

Its fine i sorted it out. I had put brackets in the statement once i took them out it was fine : SELECT Distinct ID, Barcode FROM....

This works 100%