Removing duplicates from a DropdownList

[makthar]

In your query use DISTINCT
SELECT DISTINCT CITY FROM <tablename> WHERE STATE='<state
name>'. This will bring only one of each city from the
table.

-----Original Message-----
I'm getting a list of addresses from a database and binding them to adatagrid. I have a dropdown list that allows the user select a particularstate. The event updates the query to only fetch the slected state. Afterthat I'd like to populate a seperate DropdownList that allows the user tosee a selected city. So when I bind the data the code looks like this:
public void BindGrid()
{
UpdateSelectStm t();
adptr_LocationS ummary.Fill(dsL ocationSummary1 );
//CityChooser is a DropdownList
CityChooser.Dat aSource = dsLocationSumma ry1;
CityChooser.Dat aTextField = "City";
CityChooser.Dat aValueField = "City";
CityChooser.Dat aBind();
//ListItemCollect ion cities = CityChooser.Ite ms;
//do something here to remove duplicates
dg_LocationSumm ary.DataBind();
}

Now the problem is that the CityChooser is getting a city for every row, butwhat I'd like is to show only unique cities. I couldn't find a flag forgetting only unique items. I can seem to think of a clean, efficient, way toremove all the duplicates without copying the items into a new list andbinding (though it wouldn't technically be binding I suppose) theCityChooser to the new list.

Thanks

Brian
.