title: set Order By direction using selectparameters -- ASC or DESC
body: <p>I'm trying to set the order by direction (ASC or DESC) by using SelectParameters and I get this error:  </p>
  
  <p>Incorrect syntax near '@LicenseStatusSortOrder'.  </p>
  
  <p>When I replace @LicenseStatusSortOrder with ASC or DESC then it works.  The Label_LicenseStatusSortOrder.Text does indeed contain either ASC or DESC so the value is present. See code below and thanks!  </p>
  
  <p>SelectCommand:</p>
  
  <p>SelectCommand="SELECT SoftwareLicense.Name, SoftwareLicenseByApplication.ComplianceStatus FROM UserInfo ORDER BY SoftwareLicenseByApplication.ComplianceStatus @LicenseStatusSortOrder"</p>
  
  <p>SelectParameter:</p>
  
  <pre><code>&gt; &lt;asp:ControlParameter ControlID="Label_LicenseStatusSortOrder"
  &gt; DefaultValue="ASC"  Name="LicenseStatusSortOrder"
  &gt; PropertyName="Text"/&gt; 
  </code></pre>
  
  <p>--Clark Bohs</p>