Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,153,436 members, 7,819,595 topics. Date: Monday, 06 May 2024 at 06:45 PM

How To Sorting Tables With Vb.6 - Programming - Nairaland

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
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.