Order by desc is not working in sqldatasource

See more:

ASP.NET

SQL

i'm using repeaters to show data in webform. but i have a problem with this code. when i select * data from BidTAble it shows in Desc order but when i use INNER JOIN , Desc doesn't work.! :/

What I have tried:

 <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:CONN %>" SelectCommand="SELECT BidTable.BidID,BidTable.RegID,BidTable.CarID,Reg.username,BidTable.BidAmount  FROM [BidTable] INNER JOIN Reg ON BidTable.RegID=Reg.ID  WHERE ([CarID] = @CarID) ORDER BY [BidAmount] DESC">
         <SelectParameters>
                <asp:QueryStringParameter Name="CarID" 

QueryStringField="id" Type="Int32" />
            </SelectParameters>

        </asp:SqlDataSource>