binding a combobox to a specific column in a DataTable

[anatanat]

hello :)

I want to bind a combobox to a specific column in a DataTable.
I want the combobox items to display distinct values.

I tried:
combo.datasourc e = dataTable;
combo.DisplayMe mber = "DESIRED COLUMN";

(here I got the values I want, but including empty rows, and with repetitions).
I tried to iterate and check the text of the items, but I can't do "visible = false" since I iterate over datarows,
and I can't remove the specific item from the combobox, since I bound the combobox to a datatable via the datasource property.

do anyone have an idea?

thanks, anat :)

[cloud255]

Hi, this is why I don't use databindings... you just lose so much control.

What is suggest is that that you loop through the datatable and check if the current item should exist in the items collection of the combobox. If it should then you simply call the Add method to add the item to the combobox.

[anatanat]

sorry for the big delay in resonding, but thanks for your help :)
this is what I did at the end

(I iterated over the items in the desired column, and created a dictionary with the values as the key (if it's not contained already in the dictionary) in order to get distinct values only, and then I took all the keys from the dictionary and inserted it to the combobox).