Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,153,436 members, 7,819,595 topics. Date: Monday, 06 May 2024 at 06:45 PM |
Nairaland Forum / Science/Technology / Programming / How To Sorting Tables With Vb.6 (942 Views)
Sorting List Of Numbers And Strings: Simple Puzzle / Vb 6.0/vb .NET & Intranet/internet Application Development / Post Ur Vb 6.0 Questions Here (2) (3) (4)
(1) (Reply)
How To Sorting Tables With Vb.6 by RuuDie(m): 12:46pm On Apr 27, 2007 |
who has any idea on hw to sort the fields of a Database table in VB.6? |
Re: How To Sorting Tables With Vb.6 by Fdeveloper(m): 4:20pm On Apr 27, 2007 |
I'm assuming you're talking about sorting the result of a query on the database in which case I would think your best bet is to use an ORDER BY clause in your SQL so the data is sorted before you load it into a recordset. If what you mean is sorting the data after it has been loaded into a grid for example (i.e. Giving the end user the ability to sort), then depending on the amount of data involved, I would still consider reloading it from the database with a suitably modified query. The database server will in almost all cases be capable of executing a much more optimised sort than you can do in code which is why it's almost always best to delegate such tasks to the server. |
(1) (Reply)
Make Your Jframe Irresizable / Help Solve My VMWARE Problem / How To Install And Run Multiple Whatsapp Accounts On Android
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 10 |