Filling combo box with distinct values from a dataset
Posted on 2004-08-30
I'm attempting to fill a combo box with the values in one column of a dataset table. Here's the code I'm using:
Me.cmbItems.DataSource = DataSet1.Tables(0)
Me.cmbItems.DisplayMember = "Items"
(Dataset = dataset1, "items" is the column in the dataset1 table, ds_table)
This works fine, but I need to cut out all redundancy - anybody have some code to do this same thing but to grab only distinct values from a dataset table column?