📄 showcode.asp@source=demo_sort_1

📁 W3Schools tutorial..web designing

💻 ASP@SOURCE=DEMO_SORT_1

字号:



<HTML>
<HEAD></HEAD>
<FONT FACE="Verdana, Arial, Helvetica" SIZE=2>
&lt;html><br />&lt;body><br /><br /><FONT COLOR=#ff0000>&lt;%<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 CompanyName"<br />rs.Open sql, conn<br />%&gt;</FONT><br /><br />&lt;table border="1" width="100%"><br />&lt;tr><br /><FONT COLOR=#ff0000>&lt;%for each x in rs.Fields<br />&nbsp;&nbsp;&nbsp;   response.write("&lt;th>" & x.name & "&lt;/th>")<br />next%&gt;</FONT><br />&lt;/tr><br /><FONT COLOR=#ff0000>&lt;%do until rs.EOF%&gt;</FONT><br />&nbsp;&nbsp;&nbsp;   &lt;tr><br />&nbsp;&nbsp;&nbsp;   <FONT COLOR=#ff0000>&lt;%for each x in rs.Fields%&gt;</FONT><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      &lt;td><FONT COLOR=#ff0000>&lt;%Response.Write(x.value)%&gt;</FONT>&lt;/td><br />&nbsp;&nbsp;&nbsp;   <FONT COLOR=#ff0000>&lt;%next<br />&nbsp;&nbsp;&nbsp;   rs.MoveNext%&gt;</FONT><br />&nbsp;&nbsp;&nbsp;   &lt;/tr><br /><FONT COLOR=#ff0000>&lt;%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 + -