Using ListView Column headers for sorting 2

[mrdod]

I have a ListView control and am wondering if there is a way to click on the header Date Ented and have the List View sort ascending then descending. If not no big deal but right now I have two buttons at the top of my ListView for sorting by date and it might clean up the appearance a bit.

Thanks

 

[ZOR]

Don't know if these links help?

http://www.tek-tips.com/faqs.cfm?fid=5329

http://alexdyb.blogspot.com/2006_10_01_archive.html

 

[TheAceMan1]

How are ya mrdod . . .

. . . or perhaps this: Sort by Column Hearders works via mouse position! . . .

See Ya! . . . . . .

 

[ZmrAbdulla]

Listview consider all its data as string. Even the underlying data field is integer or anything else.

Here is a simple solution to sort a listview

Private Sub ListView1_ColumnClick(ByVal ColumnHeader As Object)
'   When a ColumnHeader object is clicked,
'   the ListView control is
'   sorted by the subitems of that column.
'   Set the SortKey to the Index of the ColumnHeader - 1
    Me.ListView1.SortKey = ColumnHeader.Index - 1
    ' Set Sorted to True to sort the list.
    If ListView1.SortOrder = lvwAscending Then
        ListView1.SortOrder = lvwDescending
    Else
        ListView1.SortOrder = lvwAscending
    End If
    Me.ListView1.Sorted = True
End Sub

Reload the ListView with appropriates sort order in the datasource is the best way to get the desired result.

________________________________________________________
Zameer Abdulla
Help to find Missing people