Want to do sort in MS Flex Grid ?

[chander]

I want to do sorting on single coulumn data in MsFlexgrid.
I don't bother whether it is numeric,character or string .
But by using sort property of MSFlex grid control all other columns having data got unordered means , my selected column
is sorted but other coulumns get unordered.I set the Row ,Col , Rowsel and Colsel property by values for which i want sorting before sorting it . but still all other columns
data disperse .

Or any other idea of sorting in VB , if I have a list of strings ( it may be numeric , string , alphabet as in Excel)
I can put sorted values later in grid if i sort them externally thru any other technique .

I would appreciate and thankful if any one helps me on this.

Chander

[Berthil]

Try to sort the stuff before adding to flex grid and re-read when choosing another sort column.

I like to use the LisView Control, it lets you sort on every column if you click on the header with just a few lines of code. Numbers and dates are treated as text though

Private Sub pnlResult_ColumnClick(ByVal ColumnHeader As MSComctlLib.ColumnHeader)
    If pnlResult.Sorted = False Then pnlResult.Sorted = True
    If pnlResult.SortOrder = lvwAscending Then pnlResult.SortOrder = lvwDescending Else pnlResult.SortOrder = lvwAscending
    pnlResult.SortKey = ColumnHeader.Index - 1
End Sub

I also store column positions and widths on exit, very easy. You could use a hidden listview to sort columns as you like and refresh the grid with it.

On http://vbaccelerator.com is a free Outlook style OCX which is very fast, small and much more cunstomizable then the Listview. It's more a combination between grid and listview control

[chander]

thanks for suggestion , though i have written my own code for sorting in Flex Grid , yet i will try using list view ot other OCX on vbaccelerator.com if it sort efficiently.
if it clicks then my sorting time will be reduce.

thanks

Chander