Dropdown within a DetailsView: show text based on stored value
<p>I have a database table called Employees that has an ID number, First Name, Last Name, and SupervisorID for each employee.  The SupervisorID stored for an employee equals the ID number of that employee's supervisor.</p>

<p>I want to have a DetailsView control that can edit these fields for an employee.  The Supervisor field needs to be a dropdown that stores the SupervisorID as the value, and shows the supervisor's First Name and Last Name as it's text.</p>

<p>I've looked around a lot and was able to figure out how to create the dropdown to select and show SupervisorID's.  Where I'm stuck is how do I change the code below to store the SupervisorID, but show the Supervisor's name as it's text?</p>

<p>Here's the code for the Supervisor dropdown within my DetailsList:</p>

<pre><code>&lt;asp:TemplateField HeaderText="Supervisor" SortExpression="SupervisorID"&gt;
             &lt;EditItemTemplate&gt;
                &lt;asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource3" DataTextField="SupervisorID" DataValueField="SupervisorID" SelectedValue='&lt;%# Bind("SupervisorID") %&gt;'&gt;
                &lt;/asp:DropDownList&gt;
                &lt;asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="&lt;%$ ConnectionStrings:dbConnectionString %&gt;" SelectCommand="SELECT [SupervisorID] FROM [Employees]"&gt;&lt;/asp:SqlDataSource&gt;
             &lt;/EditItemTemplate&gt;
             &lt;ItemTemplate &gt;
                &lt;asp:Label Runat="server" Text='&lt;%# Bind("SupervisorID") %&gt;' ID="Label1"&gt;&lt;/asp:Label&gt;
            &lt;/ItemTemplate&gt;
        &lt;/asp:TemplateField&gt;
</code></pre>

<p>Any ideas for what I can change to accomplish my goal?  Thanks for any help!</p>
