Sorting showed wrongly in UI Part

Question

Dear All ,

 

In SQL I have Sorting Query in my local. In that Query showed the output in properly on db side (Like 1,3,4,5,7,21,51), but the Query write DB.cs file on dotnet. The UI Part View is sorting showed differently

in grid (Like 3,1,4,21,6,51,5).

 

Using the Same Query on both side no one changes. Please Suggest the way of Handle this type of Issues.

 

Thanks,

Dhanabalan