We can use SQL to specify how to sort the data in the recordset. We want to display the “Companyname” and “Contactname” fields in the “Customers” table and sort them by “Companyname” (please remember to usethe Sort records in descending order based on the specified field name How to sort data according to a specified field name Allow users to choose which column to sort based on Let the user choose which column to sortSort the data ¶
.asp
save for suffix):Example ¶
<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>
More Instance ¶