How to show database values in order wise using c#

Question

Hai  In my project  I want to display all the database values of serialno in one textbox . For an example I don't want to display like this below serios Serial No : 1 10 11 12 13 2 20 21 22 3 4 I want to display this serialno order in : This is what I want to display this number Serial no: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 . . . 20 21 22 . . .30 . .n How can I do this in my project  Please somebody help me to overcome this problem.

Rajeev Punhani · Answer

Hi Pavithra I think you have put serial number column as varchar instead of numeric.Either you change the datatype of the column in table or use following query while fetching records. SELECT * FROM MyTable ORDER BY CAST( serialno AS Numeric(100)) If the above solution is helpful then accept the answer.

Pavithra L · Answer

Hai Rajeev Thankm you Am using your code and got my answer.

Tom Mohan · Answer

You question is not clear for me. As per my understanding If you want to sort to do this c# the write a linq query with order by condition.