ADO saralash
Recordset’dagi ma’lumotlarni qanday saralashni belgilash uchun SQL’dan foydalanishimiz mumkin.
Ma’lumotlarni saralash
Bu yerda "Customers" jadvalidagi "Companyname" va "Contactname" maydonlarini "Companyname" bo‘yicha saralab ko‘rsatmoqchimiz (faylni .asp kengaytmasi bilan saqlashni unutmang):
<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>
Bu yerda "Customers" jadvalidagi "Companyname" va "Contactname" maydonlarini "Companyname" bo‘yicha kamayish tartibida saralab ko‘rsatmoqchimiz (faylni .asp kengaytmasi bilan saqlashni unutmang):
<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 DESC"
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>
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!