title: How to sort a column in dataset VB.NET having multiple sort conditions
body: <p>I have a dataset in which there is a column contains various string type values like below:</p>
  
  <p>Aircraft
  Crime
  Package Total
  Apartments
  DIC - Personnel</p>
  
  <p>Now the requirement is that after applying sorting logic on this colum if there is a "Package Total"  value in it then it must come at the top position on the Dataset and after that all other values should be in alphabatically sorted order like below:</p>
  
  <p>Package Total
  Aircraft
  Apartments
  Crime
  DIC - Personnel</p>
  
  <p>We have used in Database below logic which is working fine but can't figure it out how to do it on Dataset VB.net from Fronend side:</p>
  
  <pre><code>ORDER BY 
  CASE WHEN UseCarrierAllocation = 0 THEN 
      CASE WHEN InvoiceItemLevel LIKE 'Package Total%' THEN 0 ELSE 1 
      END 
  END, InvoiceItemLevel ASC
  </code></pre>
  
  <p>Any reply/idea will be helpful!</p>