Loading

How to shorting in DataTable if value 1 to 10 and above

sameer thakur

Is it possible to change the way DataTable sorts items numerically? For example: By default, numerical sorting in DT is set like this: 1, 10, 2, 3, 4, 5, 6, 7, 8, 9 My question is, how can I get DT to sort like this: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 If, the value is 1 to 9 then code is working.If you add 10, then code not work.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P8y ago
this is because you are using nvarchar or varchar as datatype(string), thats why its coming like that, you can either change your column datatype to int or numeric(18,0)
or as @ mayur Patel said, in your query in order by you can convert your column as in datatype to int or numeric(18,0)
Mayur Patel8y ago
If you are using MS SQL Server:

ORDER_BY cast(column_name as int) ASC

please visit below link
https://stackoverflow.com/questions/16519648/sql-for-ordering-by-number-1-2-3-4-etc-instead-of-1-10-11-12