title: Displaying ASP drop down list in order
body: <p>The following code is a drop down box that displays Schools from a database, is there anyway to make these Schools display in alphabetical order?</p>
  
  <pre><code>&lt;td align="right" style="text-align: right; width: 170px;"&gt;
      &lt;asp:Label ID="School_lbl" runat="server" AssociatedControlID="School" 
          Text="School:"&gt;&lt;/asp:Label&gt;
  &lt;/td&gt;
  &lt;td style="width: 206px"&gt;
      &lt;asp:DropDownList ID="School" runat="server" DataSourceID="School_DS" 
          DataTextField="SchoolName" AppendDataBoundItems="True"
          DataValueField="SchoolName" Font-Names="verdana" Width="185px" 
          AutoPostBack="True"
          OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged"&gt;
  
          &lt;asp:ListItem Selected="True"&gt;-- Select --&lt;/asp:ListItem&gt;
      &lt;/asp:DropDownList&gt;
      &lt;asp:AccessDataSource ID="School_DS" runat="server" 
          DataFile="~/App_Data/MockCourt_db.mdb"
          SelectCommand="SELECT [SchoolName] FROM [tbl_school]"&gt;
      &lt;/asp:AccessDataSource&gt;
      &amp;nbsp;&amp;nbsp;
  &lt;/td&gt;
  </code></pre>