title: Order List(Of DataRow) by Columntype String as Integer, VB
body: <p>I have a <code>list(of DataRow)</code> (each contained row is from the same table).</p>
  
  <p>Each row contains the <code>.item("number")</code> as a <code>String</code>.
  This item represents a <code>Number</code>.</p>
  
  <p>What i need is a fast function, that <code>orders the rows</code> inside the List by the <code>.item("number")</code> <code>Ascending</code> (1->2->3->4->5)</p>
  
  <p><strong>EDIT</strong> The following is a response by me to a question asked about my question under this question! (Wow, thats a lot of questions..)</p>
  
  <pre><code>  grpname | grpID | LocationID | info1 | info 2 | Info 3
    yaya    | 2     | 4          | asd   | asd     | dasd
    yaya    | 2     | 2          | asd   | asd     | dasd
    yaya    | 2     | 3          | asd   | asd     | dasd
    yaya    | 2     | 1          | asd   | asd     | dasd
    yaya    | 2     | 5          | asd   | asd     | dasd
    yo      | 6     | 4          | asd   | asd     | dasd
    yo      | 6     | 1          | asd   | asd     | dasd
    yo      | 6     | DBNULL     | asd   | asd     | dasd
    yo      | 6     | 2          | asd   | asd     | dasd
    yo      | 6     | 6          | asd   | asd     | dasd 
  </code></pre>
  
  <p>Basicly thats what I have.
  I get the information above by reading the Database of a 3rd party Application. My task is to put these into a nice looking word table in the order the user set in the mentioned 3rd Party tool. 
  <code>LocationID</code> belongs to the <code>grpID</code>, so there is a specific order of the Rows inside the group while staying in the same <code>Datatable</code>. 
  I was able to order the <code>DataRows</code> in the correct groups. To solve the Problem of putting the rows into the correct position in the groups i programmatically put all the rows of a group into a <code>list(of Datarow)</code> which is put into a <code>List(of List(of DataRow))</code>As soon as I have all the Rows ordered correctly inside the <code>Lists</code> i will reorder them inside the <code>DataTable</code></p>
  
  <p><strong>EDIT</strong>
  I finally found a solution myself using an additional Column with the following Content (describing as Text)</p>
  
  <pre><code> Try to put CInt(LocationID) -&gt; if Catch happens (DBNULL): Put 999
   After thats done: Use DataView to Order DataTable by grpID, newColumn
  </code></pre>
  
  <p>Primary it trys to order by grp, and when there are more than one rows of the same group it orders by newColumn.</p>