ADO实例向 HTML 表格添加颜色
<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("/db/northwind.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
sql="SELECT Companyname, Contactname FROM Customers"
rs.Open sql, conn
%>
<table border="1" width="100%" bgcolor="#fff5ee">
<tr>
<%for each x in rs.Fields
response.write("<th align='left' bgcolor='#b0c4de'>" & 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>
| Companyname | Contactname |
|---|---|
| Nokia Corporation | Olli-Pekka Kallasvuo |
| Google, Inc. | Larry Page |
| Sony Corporation of America | Kazuo Hirai |
| Apple Computer, Inc. | Steven Jobs |
| BAIDU, Inc | Li YanHong |
| Canon USA, Inc. | Tsuneji Uchida |
发表评论 取消回复