Adding Value to databound DropDownlist (asp.net)
<p>I am creating a website which has 1 dropdownlist that bound to Northwind database, Customers table. This Drop downlist will list all the countries from the tables. I have tried to add "Japan" (which was not in the list) to this dropdownlist. It was added but it always appear at the top (or default value). My question is: Is it possible to add Japan and not make it appear at the top, so it will follow the alphabetical order?</p>

<p>This is my code:</p>

<pre><code>&lt;asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True" 
            AutoPostBack="True" DataSourceID="SqlDataSource1" DataTextField="Country" 
            DataValueField="Country"&gt;&lt;asp:ListItem Text ="Japan" /&gt;
        &lt;/asp:DropDownList&gt;
        &lt;asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="&lt;%$ ConnectionStrings:NorthwindConnectionString2 %&gt;" 

            SelectCommand="SELECT Country FROM Customers GROUP BY Country ORDER BY Country"&gt;
        &lt;/asp:SqlDataSource&gt;
</code></pre>
