Unable to sort out the values taken from database by its price using DropDownList

See more:

C#

ASP.NET

SQL

I am trying to sort my packages according to its price from the most expensive to the cheapest using DropDownList by getting all values from the database. And by default, users can already see all the packages that i have inserted into the database. However, i still get the same output as the default seen by the user whereby it is not sorted out accordingly to the price when i select the dropdownlist. What have i done wrong here?

This is my .aspx file:

<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" AppendDataBoundItems="true" 
                onselectedindexchanged="DropDownList1_SelectedIndexChanged">
                <asp:ListItem>Choose one</asp:ListItem>
                <asp:ListItem>Price - high to low</asp:ListItem>
                <asp:ListItem>Price - low to high</asp:ListItem>
            </asp:DropDownList>

This is my .cs file:

protected void Page_Load(object sender, EventArgs e)
    {
        if (Page.IsPostBack == false)
        {
            bindDropDownList();
        }
    }

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
    
    }

    private void bindDropDownList()
    {

        DropDownList1.DataSource = getReader();
        DropDownList1.DataBind();

    }

    private SqlDataReader getReader()
    {
        
        string strConnectionString =
            ConfigurationManager.ConnectionStrings["ToysConnectionString"].ConnectionString;
        SqlConnection myConnect = new SqlConnection(strConnectionString);

        string strCommandText = "SELECT package, price, description, image1, image2 FROM catalogue WHERE catalogueID <= 10 ORDER BY price desc";

        SqlCommand cmd = new SqlCommand(strCommandText, myConnect);
        myConnect.Open();
        
        SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        return reader;
    }