ADO Sorting
We can use SQL to specify how to sort the data in the recordset.
Example
- Sort the records in ascending order by the specified field name
- How to sort data by a specified field name
- Sort the records in descending order by the specified field name
- How to sort data by a specified field name
- Allow the user to choose which column to sort by
- Allow the user to choose which column to sort by
Sort the data
We hope to display the "Companyname" and "Contactname" fields in the "Customers" table and sort them by "Companyname" (remember to save it with the .asp extension):
<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Companyname, Contactname FROM
Customers ORDER BY CompanyName
rs.Open sql, conn
%>
<table border="1" width="100%">
<tr>
<%for each x in rs.Fields
response.write("<th>" & x.name & "</th>")
next%
</tr>
<%do until rs.EOF%
<tr>
<%for each x in rs.Fields%
<td><%Response.Write(x.value)%></td>
<%next
rs.MoveNext%
</tr>
<%loop
rs.close
conn.close%
</table>
</body>
</html>
