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 · Accepted 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(10,0)) 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.

How to show database values in order wise using c#

3 Replies

If the above solution is helpful then,accept the answer.