ASP Dropdown list not changing the value
<p>First off, I'm still getting my web dev legs under me. I've combed through piles of SO posts, blogs, newsgroups and articles and I cannot seem to fix my problem. It's very similar to at least 10 different posts I've looked at.</p>

<p>I have an ASP gridview, which acts as a display and a select column. When you click select it throws the data into a detailsview. I have one field that needs to be a drop down box, but whenever I change the value and click update the value that is sent to the command is the original value.</p>

<p>Page Markup:
                
                    
                    </p>

<pre><code>                    &lt;asp:TemplateField HeaderText="Planner Name"&gt;
                        &lt;ItemTemplate&gt;
                        &lt;/ItemTemplate&gt;
                        &lt;EditItemTemplate&gt;
                        &lt;asp:DropDownList ID="cboCurrentPlanner" runat="server" DataSourceID="plannerDataSource" 
                        DataTextField="planner_name" DataValueField="planner_id" SelectedValue='&lt;%# Eval("planner_id") %&gt;' AutoPostBack="true" &gt;&lt;/asp:DropDownList&gt;
                        &lt;/EditItemTemplate&gt;
                    &lt;/asp:TemplateField&gt;
                &lt;asp:CommandField ShowEditButton="True" /&gt;
            &lt;/Fields&gt;

            &lt;FooterStyle BackColor="#CCCC99" ForeColor="Black" /&gt;
            &lt;HeaderStyle BackColor="#333333" Font-Bold="True" ForeColor="White" /&gt;
            &lt;PagerStyle BackColor="White" ForeColor="Black" HorizontalAlign="Right" /&gt;
        &lt;/asp:DetailsView&gt;
</code></pre>

<p>sqlDataSource:</p>

<pre><code>            SelectCommand="SELECT vendor_key, vendor, planner_name, street, city, state_country, planner_id, country FROM V_MAP_MarkerInfo WHERE (vendor_key = @vendor_key)" 
            UpdateCommand="MAP_usp_webUpdatePlanToVendor" 
            UpdateCommandType="StoredProcedure" onupdating="mapDetailSource_Updating" &gt;
            &lt;SelectParameters&gt;
                &lt;asp:ControlParameter ControlID="GridView1" Name="vendor_key" 
                    PropertyName="SelectedValue" Type="Int32" /&gt;
            &lt;/SelectParameters&gt;
            &lt;UpdateParameters&gt;
                &lt;asp:Parameter Name="vendor_key" Type="String" /&gt;
                &lt;asp:Parameter Name="planner_id" Type="Int32" /&gt;
                &lt;asp:Parameter Name = "vendor" Type="String" /&gt;
            &lt;/UpdateParameters&gt;
        &lt;/asp:SqlDataSource&gt;

        &lt;asp:SqlDataSource ID="plannerDataSource" runat="server" 
            ConnectionString="&lt;%$ ConnectionStrings:vendor_mapConnectionString %&gt;" 
            SelectCommand="SELECT [planner_id], [planner_name] FROM [MAP_planners]" 
            OldValuesParameterFormatString="original_{0}"&gt;
        &lt;/asp:SqlDataSource&gt;
</code></pre>

<p>I won't post the stored procedure code, I know that is working. The original value is the only value that makes it to the parameter.</p>

<p>I've tried all sorts of combinations of <code>&lt;%# Bind/Eval() %&gt;</code> postbacks but I can't find the right combination.</p>

<p>When I click select, I want the current planner to be selected in the dropdown list. When I select a new planner and click update I would like the planner to update. I'm not sure why this is so difficult or what I have royally screwed up to make it difficult but I am at my wits end. If at all possible, I would like an explanation of what is going on and not just the magical line of code that makes it work.</p>

<p>Flabbergasted is an understatement.</p>

<p>EDITS: <code>ViewStateEnbabled="true"</code> added to dropdownlist, the <code>selectedIndexChanged</code> event is firing. </p>

<p>EDIT AGAIN: Changed the planner_id to <code>&lt;asp:ControlParameter&gt;</code> added monitors to <code>DetailsView1_OnDataBind</code> and <code>MapDataSource1_updating</code> and the value is all over the place. but I can't see where it's being reset. </p>
