asp:DropDownList Error: 'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items
<p>I have a asp.net 2.0 web site with numerous asp:DropDownList controls.
The DropDownList control contains the standard info city, state, county etc... info.
In addition to the standard codes the site also has custom codes that the users can configure themselves.
For example a animal dropdown may contain the values Dog, Cat, Fish, ect...</p>

<p>I am popluating the DropDownList from a SQL 2005 table that I created e.g. tblCodes</p>

<p>Everything works great and users are able to add orders using the numerous DropDownList controls to choose items from the list.</p>

<p>The problem occurrs if a user wants to change one of their custom dropdowns. For example a user would like to change the verbage
on a animal type control from Dog to K9. This is where the problem starts.</p>

<p>For all new orders the drop down works fine. When the user retrieved an old order
I get the following error in the C# codebehind
"'DropDownList1' has a SelectedValue which is invalid because it does not exist in the list of items."</p>

<p>What's happening is the old order has a database field value of Dog and the DropDownList no longer has Dog in its list since the user changed it to K9.</p>

<p>Any ideas on a workaround?<br />
Is there a way to make the asp:DropDownList accept items not seeded in its list?
Is there another control I could use?</p>
