📄 ado_sort.asp@output=print
字号:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html lang="en-US" xml:lang="en-US" xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>ADO Sort</title>
<link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="Keywords" content="xml,tutorial,html,dhtml,css,xsl,xhtml,javascript,asp,ado,vbscript,dom,sql,colors,soap,php,authoring,programming,training,learning,beginner's guide,primer,lessons,school,howto,reference,examples,samples,source code,tags,demos,tips,links,FAQ,tag list,forms,frames,color table,w3c,cascading style sheets,active server pages,dynamic html,internet,database,development,Web building,Webmaster,html guide" />
<meta name="Description" content="Free HTML XHTML CSS JavaScript DHTML XML DOM XSL XSLT RSS AJAX ASP ADO PHP SQL tutorials, references, examples for web building." />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "../../https@ssl./default.htm" : "../../www./default.htm");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3855518-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
</head>
<body>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
<h1>ADO Sort</h1>
<a href="ado_query.asp"><img border="0" src="../images/btn_previous.gif" alt="prev" width="100" height="20" /></a>
<a href="ado_add.asp"><img border="0" src="../images/btn_next.gif" alt="next" width="100" height="20" /></a>
<hr />
<p class="intro">We may use SQL to specify how to sort the data in the record
set. </p>
<hr />
<h2>Examples</h2>
<p>
<a target="_blank" href="showasp.asp@filename=demo_sort_1">Sort the records on a specified fieldname
ascending</a><br />
How to sort the data on a specified fieldname.</p>
<p>
<a target="_blank" href="showasp.asp@filename=demo_sort_2">Sort the records on a specified fieldname
descending</a><br />
How to sort the data on a specified fieldname.
</p>
<p>
<a target="_blank" href="showasp.asp@filename=demo_sort_3">Let the user choose what column to sort on</a><br />
Let the user choose what column to sort on.
</p>
<hr />
<h2>Sort the Data</h2>
<p>We want to display the "Companyname" and "Contactname" fields from the "Customers"
table, ordered by "Companyname" (remember to save the file with an .asp extension):</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<td>
<pre><html>
<body></pre>
<pre><%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"</pre>
<pre>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></pre>
<pre></body>
</html></pre>
</td>
</tr>
</table>
<p>Here is the result:</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr>
<th>Companyname</th>
<th>Contactname</th>
</tr>
<tr>
<td>Alfreds Futterkiste</td>
<td>Maria Anders</td>
</tr>
<tr>
<td>Berglunds snabbk鰌</td>
<td>Christina Berglund</td>
</tr>
<tr>
<td>Centro comercial Moctezuma</td>
<td>Francisco Chang</td>
</tr>
<tr>
<td>Ernst Handel</td>
<td>Roland Mendel</td>
</tr>
<tr>
<td>FISSA Fabrica Inter. Salchichas S.A.</td>
<td>Diego Roel</td>
</tr>
<tr>
<td>Galer韆 del gastr髇omo</td>
<td>Eduardo Saavedra</td>
</tr>
<tr>
<td>Island Trading</td>
<td>Helen Bennett</td>
</tr>
<tr>
<td>K鰊iglich Essen</td>
<td>Philip Cramer</td>
</tr>
<tr>
<td>Laughing Bacchus Wine Cellars</td>
<td>Yoshi Tannamuri</td>
</tr>
<tr>
<td>Magazzini Alimentari Riuniti</td>
<td>Giovanni Rovelli</td>
</tr>
<tr>
<td>North/South</td>
<td>Simon Crowther</td>
</tr>
<tr>
<td>Paris sp閏ialit閟</td>
<td>Marie Bertrand</td>
</tr>
<tr>
<td>Rattlesnake Canyon Grocery</td>
<td>Paula Wilson</td>
</tr>
<tr>
<td>Simons bistro</td>
<td>Jytte Petersen</td>
</tr>
<tr>
<td>The Big Cheese</td>
<td>Liz Nixon</td>
</tr>
<tr>
<td>Vaffeljernet</td>
<td>Palle Ibsen</td>
</tr>
<tr>
<td>Wolski Zajazd</td>
<td>Zbyszek Piestrzeniewicz</td>
</tr>
</table>
<br />
<hr />
<a href="ado_query.asp"><img border="0" src="../images/btn_previous.gif" alt="prev" width="100" height="20" /></a>
<a href="ado_add.asp"><img border="0" src="../images/btn_next.gif" alt="next" width="100" height="20" /></a>
<p>From <b>http://www.w3schools.com</b> (Copyright Refsnes Data)</p>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -