Populate combobox from datatable

Question

I'am struggling with the following, I have a datatable with some columns what i want is to have the items in this column displayed in a combobox. But it must not display double items.

How can i do this?

Post code, in which you're populating it currently. Most probably you're not checking Page.IsPostBack when you're filling it. — Ondrej Svejdar, Aug 19 '13 at 14:52
What exactly is the problem? That it's displaying duplicate items? Please be more specific in your question. What technology are you using? Add more tags. — sakura-bloom, Aug 19 '13 at 14:54
Sorry being so vague, what i tried was for each loop, but i was way off. — PandaNL, Aug 19 '13 at 21:27

score 1 · Accepted Answer · answered Aug 19 '13 at 15:55

Try this:

private void FillComboFromColumnIndex(int columnIndex){
  yourDataTable.AsEnumerable()
               .Select(r=>r[columnIndex])
               .Where(x=>x != null)
               .Distinct().ToList()
               .ForEach(x=>yourComboBox.Items.Add(x));
}
//To add all the items in column at index 1, do this
FillComboFromColumnIndex(1);

score 0 · Answer 2 · edited May 23 '17 at 12:20

0

Try this, I'm not sure is it right answer on your question because I'm not sure if I have understood you as well: Hidden Id With ComboBox Items?

edited May 23 '17 at 12:20

Community

1
1

answered Aug 19 '13 at 15:00

Zoran Marjanovic

355
2
3
12

Populate combobox from datatable

2 Answers2