📄 showcode.asp@source=demo_sort_3

📁 W3Schools tutorial..web designing

💻 ASP@SOURCE=DEMO_SORT_3

字号:



<HTML>
<HEAD></HEAD>
<FONT FACE="Verdana, Arial, Helvetica" SIZE=2>
&lt;html><br />&lt;body><br /><br />&lt;table border="1" width="100%" bgcolor="#fff5ee"><br />&lt;tr><br />&lt;th align="left" bgcolor="#b0c4de"><br />&lt;a href="demo_sort_3.asp?sort=companyname">Company&lt;/a><br />&lt;/th><br />&lt;th align="left" bgcolor="#b0c4de"><br />&lt;a href="demo_sort_3.asp?sort=contactname">Contact&lt;/a><br />&lt;/th><br />&lt;/tr><br /><FONT COLOR=#ff0000>&lt;%<br />if request.querystring("sort")&lt;>"" then<br />&nbsp;&nbsp;  sort=request.querystring("sort")<br />else<br />&nbsp;&nbsp;  sort="companyname"<br />end if<br /><br />set conn=Server.CreateObject("ADODB.Connection")<br />conn.Provider="Microsoft.Jet.OLEDB.4.0"<br />conn.Open(Server.Mappath("/db/northwind.mdb"))<br />set rs=Server.CreateObject("ADODB.recordset")<br />sql="SELECT Companyname,Contactname FROM Customers ORDER BY " & sort<br />rs.Open sql,conn<br /><br />do until rs.EOF<br />&nbsp;&nbsp;  response.write("&lt;tr>")<br />&nbsp;&nbsp;  for each x in rs.Fields<br />&nbsp;&nbsp;&nbsp;&nbsp;    response.write("&lt;td>" & x.value & "&lt;/td>")<br />&nbsp;&nbsp;  next<br />&nbsp;&nbsp;  rs.MoveNext<br />&nbsp;&nbsp;  response.write("&lt;/tr>")<br />loop<br />rs.close<br />conn.close<br />%&gt;</FONT><br />&lt;/table><br /><br />&lt;/body><br />&lt;/html><br />

</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -