Easy Tutorial
Ado Ref Error Ado Sort Ado Ref Record Ado Display Ado Command Index Ado Ref Stream Ado Tutorial Ado Connect Ado Intro Ado Query Ado Examples Ado Summary Ado Datatypes Ado Ref Recordset Ado Ref Field Ado Getstring Ado Add Ado Recordset Ado Ref Connection Ado Ref Parameter Ado Ref Property Ado Delete Ado Update
❮ Ado Ref Error Ado Ref Record ❯

ADO Sorting

We can use SQL to specify how to sort the data in a recordset.

Sorting Data

We want to display the "Companyname" and "Contactname" fields from the "Customers" table and sort them by "Companyname" (remember to save with the .asp suffix):

Example

More Examples

Sort records in descending order by a specified field name

Allow the user to choose which column to sort by

❮ Ado Ref Error Ado Ref Record ❯