Computer Science Canada

Sorting records
Author:  alpesh [ Tue Jan 27, 2004 10:37 pm ]
Post subject:  Sorting records
Sad Sad Sad Sad Sad Sad
Any body have any idea ...
how to sort record in database through VB

Embarassed Embarassed
Author:  McKenzie [ Tue Jan 27, 2004 10:57 pm ]
Post subject: 
1. Add ListBox, Data Contol, CommandButton
2. Attach Data control
3. Set ListBox sorted property to true
code:
Do While Not Data1.Recordset.EOF
    List1.AddItem Label1
    Data1.Recordset.MoveNext
Loop
Author:  Acid [ Tue Jan 27, 2004 11:07 pm ]
Post subject: 
Well that's what I'd have suggested, if I knew just a little bit more about VB Wink
Author:  Tony [ Tue Jan 27, 2004 11:33 pm ]
Post subject: 
or if you're accessing your database using DAO method (my personal preference over DB linked elements) you can just have sort=accending/deccending in your SQL statement.
Author:  McKenzie [ Wed Jan 28, 2004 12:05 am ]
Post subject: 
you can use DAO and ADO either way. MS is pushing ADO but DAO is still easier to start with.

:


You can syndicate this boards posts using the file backend.php or view the topic map using sitemap.php.

Terms of Use | Privacy Policy