Another stupid question on combobox

[PlayKid]

Dear all,

 

I am trying to filter data by using dataview and display the results on the combo box, but the problem is it displays more than 1 exactly the same results on a combo box, how can I do it to prevent this happned?

 

Thanks

 

PlayKid

[DiverDan]

If I'm not mistaking your question, I think you're wanting this:

If Not ComboBox1.Items.Contains(someValue) Then
   ComboBox1.Items.Add(someValue)
End If

[PlayKid]

No, this is not what I mean, I am populating the combobox by dataview, and it automatically populate the data onto it, since I am not adding it manually, so your code is not what I want.

But thanks for your replying.

PlayKid

[rfazendeiro]

Maybe you can resolve your problem in the query?? maybe add the DISTINCT after the select

 

SELECT DISTINCT *

FROM TABLE

WHERE conditions

 

hope this helps