Hi, i have a column in datagridview composed of numeric as well as aphanumeric. What i want is when the user sorts the column, it will be sorted according to its number value, 1,2,3,4,5,6,7,8,9,10. However it my current module, the program sorts basing the first digit of the column. like 1,10,11,12,2,3,30,31.

i was thinking of converting the type to number so that it will be arrange properly, is this possible in the datagridview to covert type? because i saw only a readonly property celltype?

i have also tried casting it in the sql query itself to INT but it did not work.

do you have any suggestion for my case? thank you. i will appreciate your help.