Adding Value to databound DropDownlist (asp.net)

Question

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?

This is my code:

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

            SelectCommand="SELECT Country FROM Customers GROUP BY Country ORDER BY Country">
        </asp:SqlDataSource>

Thit Lwin Oo · Accepted Answer · 2012-02-23 01:54:37Z

2

You can try this way in your sql script.

SELECT Country
FROM
(
    SELECT Country 
    FROM Customers 
    GROUP BY Country 

    UNION ALL

    SELECT 'JAPAN'
) M
ORDER BY Country

answered Feb 23, 2012 at 1:54

Thit Lwin Oo

3,4283 gold badges22 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Danny Vo Over a year ago

Thank you so much, this is exactly what I have been looking for

Collectives™ on Stack Overflow

Adding Value to databound DropDownlist (asp.net)

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related