In my Asp.net app, I have a Gridview Control and bind it on code behind.

And on client side I use Jquery DataTable version 1.9.4 for better Sorting,Searching functionality, Here i got one problem Numeric value not sorting properly.

I googled and come to knw by using sType: numeric will solved, but when i use this my whole working stoped my Column is at 9 position so i set aTragets 9

Here's the JS FIDDLE

Javascript:

$(document).ready(function () {

    $('#ctl00_ContentPlaceHolder1_GridView3').dataTable({

        bJQueryUI: true,

        sPaginationType: full_numbers

       // aoColumnDefs: [{ sType: numeric, aTargets: [9] }]



       });

  }); 

Code nehind:
On Page_PreRender

if (GridView3.Rows.Count > 0)

        {

            GridView3.UseAccessibleHeader = true;

            GridView3.HeaderRow.TableSection = TableRowSection.TableHeader;

        }

On pageLoad :

GridView3.DataSource = sortedDT;

GridView3.DataBind();