Duplicate Items

[Jim McGivney]

In VWD I have an aspx page with a DropDownList control. The DropDownList
is populated from a column from a table in an Access database.
If there are duplicate values in the column they are added to the
DropDownList. Is there a way to eliminate duplicate items on the
DropDownList ?
Thanks,
Jim

 

[Guest]

Use the DISTINCT keyword in the SQL that generates the drop down list, e.g.

SELECT DISTINCT ValueField, TextField FROM Table

This will return only unique rows.

 

[Karl Seguin [MVP]]

use the distinct keyword in your query:

SELECT DISTINCT BLAH FROM Table

Karl

 

[Swanand Mokashi]

One option is to change the SQL query used to populate the dropdownlist to
use DISTINCT


--
Swanand Mokashi
Microsoft Certified Solution Developer (.NET) - Early Achiever
Microsoft Certified Application Developer (.NET)

http://www.dotnetgenerics.com/
DotNetGenerics.com -- anything and everything about Microsoft .NET
technology ...

http://www.swanandmokashi.com/
http://www.swanandmokashi.com/HomePage/WebServices/
Home of the Stock Quotes, Quote of the day and Horoscope web services