I have several gridviews where I've tried to implement a dropdown list filled with values from other tables in my database. The dropdown list is in the EditItemTemplate of the gridview. When I add the dropdownlist via the designer the dropdownlist works as expected. However, at some point I've yet to determine all dropdown list stop functioning as expected. When I hit the edit button I get the following error:

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

I've double and triple checked the values and as I stated previously it works for a while but ultimatly stops working.

Below is an example of how I set up all the dropdownlists:

<EditItemTemplate>
<asp:DropDownList ID="BorConsultDDL" runat="server" DataSourceID="ConsultantSQLDS" AutoPostBack="true" DataTextField="Name" DataValueField="Name" AppendDataBoundItems="true" SelectedValue='<%# Bind("BorConsult") %>'>
<asp:ListItem Value="Select Value" Text="--(Select Value)--"></asp:ListItem>
</asp:DropDownList><asp:SqlDataSource ID="ConsultantSQLDS" runat="server" ConnectionString="<%$ ConnectionStrings:APARConnectionString %>"
SelectCommand="SELECT [Name] FROM [lutConsultant]">
</asp:SqlDataSource>
</EditItemTemplate>

I've searched all over the internet looking for someone who has experienced and resolved this problem with no avail. Hopefully, someone can point out the err of my ways.

I appreciate this is an awful question, but when does it stop working? I'm not familiar with the error and "it works for a while but ultimatly stops working." leaves open large numbers of issues. It could be a control problem, database problem, settings problem, etc. We need to narrow it down. If it stops working something has changed, hopefully something you touched because then we can fix it. Did you upload new pages. Make changes to the DB?

-------------------------

Whatever you can do or dream you can, begin it. Boldness has genius, power and magic in it. Begin it now.
-Johann von Goethe

When Two Hearts Race... Both Win.
-Dove Chocolate Wrapper

Chroniclemaster1, Founder of www.EarthChronicle.com
A Growing History of our Planet, by our Planet, for our Planet.