Search DropDownList

[Andre]

Hi,

I retrieve data from a SQL Server and put the data on a DropDownList, but
my problem is that sometime i have the same value more than one time, so i
want to search the DDL to see if there's already an item with the same
value.

Is there a way to search the DDL to check that the same value as not
already been entered, so i can modify it.

I've tried with FindByText, but i cannot make it work.

Thank you

[Ken Cox [Microsoft MVP]]

Salut André,

There are ways to do this in code, but is there a reason why you can't use
the SQL query to ensure unique values?

"Use DISTINCT with SELECT
This example uses DISTINCT to prevent the retrieval of duplicate author ID
numbers."

USE pubs
SELECT DISTINCT au_id
FROM authors
ORDER BY au_id
Ken
Microsoft MVP [ASP.NET]
"Andre" <we*******@cablevision.qc.ca> wrote in message
news:Oo**************@TK2MSFTNGP10.phx.gbl...

Hi,

I retrieve data from a SQL Server and put the data on a DropDownList,
but my problem is that sometime i have the same value more than one time,
so i want to search the DDL to see if there's already an item with the
same value.

Is there a way to search the DDL to check that the same value as not
already been entered, so i can modify it.

I've tried with FindByText, but i cannot make it work.

Thank you

[Andre]

Hi,

The problem is that i'm retreiving an invoice list from my database, and
in the DDL i display the month...

Ex : March 2004, February 2004 etc..

And i put the ID Number of the invoice in the value field with
FindByText.

The problem is; if i have 2 invoice or more in the same month (Ex: March
2004).. the FindByText will find the first and will always put the value
there..

Thanks.
"Ken Cox [Microsoft MVP]" <BA************@sympatico.ca> a écrit dans le
message de news: uR****************@TK2MSFTNGP14.phx.gbl...

Salut André,

There are ways to do this in code, but is there a reason why you can't use
the SQL query to ensure unique values?

"Use DISTINCT with SELECT
This example uses DISTINCT to prevent the retrieval of duplicate author ID
numbers."

USE pubs
SELECT DISTINCT au_id
FROM authors
ORDER BY au_id
Ken
Microsoft MVP [ASP.NET]
"Andre" <we*******@cablevision.qc.ca> wrote in message
news:Oo**************@TK2MSFTNGP10.phx.gbl...

Hi,

I retrieve data from a SQL Server and put the data on a DropDownList,
but my problem is that sometime i have the same value more than one time,
so i want to search the DDL to see if there's already an item with the
same value.

Is there a way to search the DDL to check that the same value as not
already been entered, so i can modify it.

I've tried with FindByText, but i cannot make it work.

Thank you