Results 1 to 8 of 8

Thread: Sorting Listview quickly

  1. Aug 3rd, 2002, 09:43 PM #1
    yenni
    yenni is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    usa
    Posts
    100

    Sorting Listview quickly

    Does anyone have any suggestion on how to make a listview sort quickly?
    I loaded data from an Access db, and whenever I try to sort by clicking the Option Button, it takes a while.
    Reply With Quote Reply With Quote
  2. Aug 5th, 2002, 11:09 AM #2
    Geespot
    Geespot is offline
    Fanatic Member Geespot's Avatar
    Join Date
    Oct 2001
    Location
    Birmingham, UK
    Posts
    577
    have you tried turning the listview property 'Sorted' to true?
    Reply With Quote Reply With Quote
  3. Aug 5th, 2002, 12:17 PM #3
    moinkhan
    moinkhan is offline
    Frenzied Member moinkhan's Avatar
    Join Date
    Jun 2000
    Location
    Karachi, Pakistan
    Posts
    2,011
    I can't think of any other way than you order them in Database and then load...
    Reply With Quote Reply With Quote
  4. Aug 5th, 2002, 10:01 PM #4
    yenni
    yenni is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    usa
    Posts
    100

    Sorting Listview Quickly

    Yes...Geespot, I have the Sorted property checked
    Moin, will that make it sort faster?
    Reply With Quote Reply With Quote
  6. Aug 6th, 2002, 01:31 AM #5
    moinkhan
    moinkhan is offline
    Frenzied Member moinkhan's Avatar
    Join Date
    Jun 2000
    Location
    Karachi, Pakistan
    Posts
    2,011
    Certainly it would.. but. then you could only order the things when you load them from table....so it would do bad rather than good.
    Is your listview multicolumn? and you want to sort on any column???????
    Reply With Quote Reply With Quote
  7. Aug 6th, 2002, 04:11 AM #6
    Evil_Giraffe
    Evil_Giraffe is offline
    PowerPoster Evil_Giraffe's Avatar
    Join Date
    Aug 2002
    Location
    Suffolk, UK
    Posts
    2,555
    I did something similar with a treeview. When I wanted to sort it, I just threw out all the information, did another call to the database and repopulated it. If you turn off window redraw first it helps with the speed.
    Reply With Quote Reply With Quote
  8. Aug 8th, 2002, 08:45 PM #7
    yenni
    yenni is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2000
    Location
    usa
    Posts
    100

    Sorting Listview Quickly

    Moin..I have 5 columns, and I would like to sort it on any column
    Reply With Quote Reply With Quote
  9. Aug 11th, 2002, 08:01 AM #8
    moinkhan
    moinkhan is offline
    Frenzied Member moinkhan's Avatar
    Join Date
    Jun 2000
    Location
    Karachi, Pakistan
    Posts
    2,011
    Then do it the way I mentioned earlier.. Clear the listview send a command to database to order on your desired field and re-populate...
    But I doubt about its usefulness
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width