ASP DataSource Select Ordering
<p>The following ASP code is displaying the data in assending order by the field Principal_ID, I would like to do it in an alphbetical order by SchoolName. Does anyone know how I can achieve this</p>

<pre><code>&lt;asp:Panel ID="show_pnl" runat="server" runat="server"  GroupingText="Show Principal" Width="100%" Font-Names="verdana"
            Font-Size="Small" BackColor="white" align=center" BorderColor="white" BorderPadding="0" BorderStyle="none" BorderWidth="0px"&gt;&gt;
            &lt;asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="ShowPrincipals_DS"
                DataKeyNames="SchoolName" CssClass="mGrid" PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt"
                Font-Size="Small" Font-Names="verdana" Height="100%" Width="100%" AutoGenerateDeleteButton="True"&gt;
                &lt;Columns&gt;
                    &lt;asp:BoundField DataField="Principal_ID" HeaderText="Principal ID" SortExpression="Principal_ID" /&gt;
                    &lt;asp:BoundField DataField="FirstName" HeaderText="First Name" SortExpression="FirstName" /&gt;
                    &lt;asp:BoundField DataField="LastName" HeaderText="Last Name" SortExpression="LastName" /&gt;
                    &lt;asp:BoundField DataField="UserName" HeaderText="User Name" SortExpression="UserName" /&gt;
                    &lt;asp:BoundField DataField="Email" HeaderText="Email" SortExpression="Email" /&gt;
                    &lt;asp:BoundField DataField="SchoolName" HeaderText="School Name" SortExpression="SchoolName" /&gt;
                &lt;/Columns&gt;
                &lt;PagerStyle CssClass="pgr" /&gt;
                &lt;EmptyDataTemplate&gt;
                    No Data Available
                &lt;/EmptyDataTemplate&gt;
                &lt;AlternatingRowStyle CssClass="alt" /&gt;
            &lt;/asp:GridView&gt;
            &lt;asp:AccessDataSource ID="ShowPrincipals_DS" runat="server" DataFile="~/App_Data/MockCourt_db.mdb"
                SelectCommand="SELECT tbl_Principal.Principal_ID, tbl_Principal.FirstName, tbl_Principal.LastName, tbl_Principal.UserName, tbl_Principal.Email, tbl_school.SchoolName FROM (tbl_Principal INNER JOIN tbl_school ON tbl_Principal.School_ID = tbl_school.School_ID)"
                DeleteCommand="DELETE FROM [tbl_Principal] WHERE ([Principal_ID] = @Principal_Id)"&gt;
                &lt;DeleteParameters&gt;
                    &lt;asp:Parameter Name="Principal_ID" Type="int32" /&gt;
                &lt;/DeleteParameters&gt;
            &lt;/asp:AccessDataSource&gt;
        &lt;/asp:Panel&gt;
</code></pre>
