Listview - Simple code but sorts in different format

[Vbbeginner07]

The following code is for sorting,but that works in a different format:

 Private Sub ListView1_ColumnClick(ByVal ColumnHeader As   MSComctlLib.ColumnHeader)
 With ListView1  '// change to the name of the list view
 Static iLast As Integer, iCur As Integer
     .Sorted = True
      iCur = ColumnHeader.Index - 1
      If iCur = iLast Then .SortOrder = IIf(.SortOrder = 1, 0, 1)
     .SortKey = iCur
      iLast = iCur
     End With
   End Sub

This works as in alist view as:
num
1
12
2
23
2111
3
356

What wrong with the code???
THanks in advance:

[debasisdas]

What is wrong with the output? It is showing as per code. Sorting is done as per ascending sort considering as character not numbers.

[Vbbeginner07]

What is wrong with the output? It is showing as per code. Sorting is done as per ascending sort considering as character not numbers.

But I have to sort like
1
2
3
11
21
32
356
as if in the correct order, but the output is the one which is in #1, please go through.

[debasisdas]

it is sorting considering the items as character strings not numbers

[Vbbeginner07]

it is sorting considering the items as character strings not numbers

Please help me to sort a list view including characters and numbers
Thanks in advance

[debasisdas]

If a list view is sorted including characters and numbers ,that will be sorted as per character only. So it will consider numbers as characters also.

[Killer42]

The basic problem here is that the sort functionality of the Listview control is treating the values as strings. If you consider the values to be strings, "2" is certainly a higher value than "15", simply because the "2" (ASCII code 50) is higher than the "1" (ASCII code 49). I imagine things might be more complex if dealing with Unicode.

This confusion between numbers and strings has been around for many years, and there are various ways in which one might work around it. These include (but are not limited to):

• If possible, use your own code to do the sort, converting all values either to numbers, or two strings of the same length (such as "00015" and "00002"). I don't know whether the Listview control provides any way to customise the sorting, or not.
• If the Listview control supports it, store the values in it as numbers rather than strings.
• Add a hidden column and sort on that. In other words, if supported, add another column which is not possible to the user, and copy the values from the problematic column in a "sortable" format. For example, with leading zeroes as described in the first bullet point.
• Sort the data before placing it in the listview. If it's coming form a database, this might mean including an ORDER BY clause in your SQL. If not, you might need to sort an array first, or simply change the order in which you add them to the ListView.

.