Prev Next

ADO Sort

ADO allows you to sort records in a Recordset object based on specified fields. Sorting helps organize and display data more effectively.

Key Topics

Simple Sorting

Example

<%
    Dim conn, rs
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;User ID=myUser;Password=myPassword;"

    Set rs = conn.Execute("SELECT * FROM Employees")
    rs.Sort = "EmployeeName ASC"

    Do Until rs.EOF
        Response.Write("Name: " & rs("EmployeeName") & "<br>")
        rs.MoveNext
    Loop

    rs.Close
    conn.Close
    Set rs = Nothing
    Set conn = Nothing
%>

Explanation: This example sorts employees alphabetically by their name using the Sort property of the Recordset.

Multi-Field Sorting

Example

<%
    rs.Sort = "Department ASC, EmployeeName DESC"
%>

Explanation: This example demonstrates sorting records by department in ascending order and then by employee name in descending order.

Key Takeaways

  • Use the Sort property to organize records in a Recordset.
  • Combine multiple fields for advanced sorting requirements.
  • Sorting enhances data readability and usability in applications.
Prev Next