title: Jquery DataTable Sorting Numeric value column not working properly
body: <p>In my Asp.net app, I have a Gridview Control and bind it on code behind.<br>
  And on client side I use <code>Jquery DataTable version 1.9.4</code> for better Sorting,Searching functionality, Here i got one problem Numeric value not sorting properly.</p>
  
  <p>I googled and come to knw by using <code>sType": "numeric"</code>  will solved, but when i use this my whole working stoped my Column is at 9 position so i set <code>aTragets</code> 9    </p>
  
  <p>Here's the <strong><a href="http://jsfiddle.net/6Pxwy/" rel="nofollow noreferrer">JS FIDDLE</a></strong></p>
  
  <p>Javascript:</p>
  
  <pre><code>$(document).ready(function () {
      $('#ctl00_ContentPlaceHolder1_GridView3').dataTable({
          "bJQueryUI": true,
          "sPaginationType": "full_numbers"
         // "aoColumnDefs": [{ "sType": "numeric", "aTargets": [9] }]
  
         });
    }); 
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/hwPWi.jpg" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/OvjPg.png" alt="enter image description here"></p>
  
  <p>Code nehind:
  On Page_PreRender </p>
  
  <pre><code>if (GridView3.Rows.Count &gt; 0)
          {
              GridView3.UseAccessibleHeader = true;
              GridView3.HeaderRow.TableSection = TableRowSection.TableHeader;
          }
  </code></pre>
  
  <p>On pageLoad :</p>
  
  <pre><code>GridView3.DataSource = sortedDT;
  GridView3.DataBind();
  </code></pre>