Default value for dropdownlist databound control

[dizzy77]

I have a dropdownlist databound to table column with string values "n" i "y".

<asp:DropDownList ID="ddlPrivate" runat="server" SelectedValue='<%# Bind("cPrivate") %>'>
<asp:ListItem Value="n">No</asp:ListItem>
<asp:ListItem Value="y">Yes</asp:ListItem>
</asp:DropDownList>

How to handle situation when value is not "n" or "y" to avoid exception.
Is it possible to make dropdownlist select some default value when binded value does not fall in range. (e.g. "")

Danielz

[kenobewan]

Welcome to TSDN. I believe your choice is to validate it, client or server side, or to test for a null value. HTH.

[radcaesar]

Set its 'DropDownStyle' property to 'DropDownList'.

[dizzy77]

Well I wanted to make sure that if 'cPrivate' column value different than 'y' or 'n' I don't get binding exception at presentation layer. But decided that I can simply modify my sql query:
(SELECT cPrivate = CASE WHEN cPrivate = 'Y' THEN 'Y' ELSE 'N' END) AS cPrivate

This way possible wrong values in database are corrected at data layer.
Otherwise I should somehow catch binding exception (still don't know how) which would anyway require more code and effort.

Thanks
Daniel