DropDownList selected value error

[David C]

I have a DropDownList control that is bound to a string data field
(varchar(3)) that contains Null, 'yes', 'no', or 'n/a'. One of the records
in the database had a value of Yes and it gave an error

Message: 'ddlOriginalDocument' has a SelectedValue which is invalid because
it does not exist in the list of items.
Parameter name: value

I take it a capital Y is considered different than a lower case y. Is there
a workaround short of me updating all of the columns to lower case? Thanks.

David

 

[Guest]

I have a DropDownList control that is bound to a string data field
(varchar(3)) that contains Null, 'yes', 'no', or 'n/a'. One of the records
in the database had a value of Yes and it gave an error

Message: 'ddlOriginalDocument' has a SelectedValue which is invalid because
it does not exist in the list of items.
Parameter name: value

I take it a capital Y is considered different than a lower case y. Is there
a workaround short of me updating all of the columns to lower case? Thanks.

David

Hi, David

to return a string in lowercase letters you could use

in SQL: select LOWER(datafield)....
in .NET: stringvalue.ToLower()

Hope this helps