Drop Down List in FormView

[Jeremy Olmstead]

Is there a way to convert a TextBox to a DropDownList in a FormView
control? I was able to get the DropDown box to get the "SelectedValue"
in edit mode, but the update fails. No error, it just leaves the value
as it was.

<asp:FormView ID="customerEdit" runat="server" DataKeyNames="CustomerID"
DataSourceID="billingData" DefaultMode="Edit">
<EditItemTemplate>
<table border="0" cellpadding="3" class="pageContent">
<tr>
<td align="right">
Name:</td>
<td>
<asp:TextBox ID="NameTextBox" runat="server" Text='<%# Bind
("Name") %>' Width="164px"></asp:TextBox>
<span class="error">*</span></td>
</tr>
<tr>
<td align="right">
Country:</td>
<td>
<aspropDownList ID="countryDrop" runat="server"
SelectedValue='<%# Bind("Country") %>'>
<asp:ListItem Selected="True">United States</asp:ListItem>
<asp:ListItem>Afghanistan</asp:ListItem>
....more items
</aspropDownList>
</EditItemTemplate>
</asp:FormView>

<asp:SqlDataSource ID="billingData" runat="server" ConnectionString="<%
$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName
%>" SelectCommand="SELECT * FROM [Customers] WHERE ([CustomerID] = ?)"
UpdateCommand="UPDATE [Customers] SET [Name] = ?, [CompanyName] = ?,
[Addr1] = ?, [Addr2] = ?, [City] = ?, [State] = ?, [PostalCode] = ?,
[Country] = ?, [Phone] = ?, [Fax] = ? WHERE [CustomerID] = ?">
<SelectParameters>
<asp:SessionParameter DefaultValue="0" Name="CustomerID"
SessionField="customerID"
Type="Int32" />
</SelectParameters>
<UpdateParameters>
<asparameter Name="Name" Type="String" />
<asparameter Name="CompanyName" Type="String" />
<asparameter Name="Addr1" Type="String" />
<asparameter Name="Addr2" Type="String" />
<asparameter Name="City" Type="String" />
<asparameter Name="State" Type="String" />
<asparameter Name="PostalCode" Type="String" />
<asparameter Name="Country" Type="String" />
<asparameter Name="Phone" Type="String" />
<asparameter Name="Fax" Type="String" />
<asparameter Name="CustomerID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>