Search DropDownList

  • Thread starter Thread starter Andre
  • Start date Start date
A

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
 
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]
 
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 said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top