demo_db_list.asp
来自「W3Schools tutorial..web designing」· ASP 代码 · 共 166 行
ASP
166 行
<html>
<head><title>ADO - List Database Records</title></head>
<body>
<h2>List Database Table</h2>
<p>Click on a button to modify a record.</p>
<table border="1" width="100%">
<tr bgcolor="#b0c4de">
<th>NO</th><th>FNAME</th><th>LNAME</th><th>PHONE</th><th>EMAIL</th><th>HOMEPAGE</th><th>DATEADDED</th>
</tr>
<tr bgcolor="#f0f0f0">
<form method="post" action="demo_db_edit.asp" target="_blank">
<td><input type="submit" name="no" value="16"></td>
<td>Terje </td>
<td>Beck </td>
<td>55 66 77 99 </td>
<td>tertje@somewere.com </td>
<td>www.amazon.com </td>
<td>1/18/2001 7:45:47 AM </td>
</form>
</tr>
<tr bgcolor="#f0f0f0">
<form method="post" action="demo_db_edit.asp" target="_blank">
<td><input type="submit" name="no" value="17"></td>
<td>Jan </td>
<td>Refsnes </td>
<td>66 77 88 </td>
<td>jani@w3schools.com </td>
<td>http:/www.w3schools.com </td>
<td>7/11/2000 1:01:56 PM </td>
</form>
</tr>
<tr bgcolor="#f0f0f0">
<form method="post" action="demo_db_edit.asp" target="_blank">
<td><input type="submit" name="no" value="39"></td>
<td>Torleif </td>
<td>Rasmussen </td>
<td>77 88 99 </td>
<td>N/A </td>
<td>N/A </td>
<td>4/26/2000 3:46:41 AM </td>
</form>
</tr>
<tr bgcolor="#f0f0f0">
<form method="post" action="demo_db_edit.asp" target="_blank">
<td><input type="submit" name="no" value="46"></td>
<td>anton </td>
<td>chek </td>
<td>83833 </td>
<td>apa@kabar.com </td>
<td>www.yahoo.com </td>
<td>4/25/2000 7:17:45 AM </td>
</form>
</tr>
<tr bgcolor="#f0f0f0">
<form method="post" action="demo_db_edit.asp" target="_blank">
<td><input type="submit" name="no" value="48"></td>
<td>stale </td>
<td>refsnes </td>
<td>555-12234 </td>
<td>refsnes@hotmail.com </td>
<td>http://www.w3schools.com </td>
<td>5/31/2000 11:14:33 AM </td>
</form>
</tr>
<tr bgcolor="#f0f0f0">
<form method="post" action="demo_db_edit.asp" target="_blank">
<td><input type="submit" name="no" value="52"></td>
<td>hari </td>
<td>prawin </td>
<td>98410-95897 </td>
<td>hari@hari.com </td>
<td>www.hari.com </td>
<td>1/18/2001 7:47:58 AM </td>
</form>
</tr>
<tr bgcolor="#f0f0f0">
<form method="post" action="demo_db_edit.asp" target="_blank">
<td><input type="submit" name="no" value="53"></td>
<td>Hege </td>
<td>Refsnes </td>
<td>N/A </td>
<td>hege@somewhere.com </td>
<td>N/A </td>
<td>3/22/2001 1:35:01 PM </td>
</form>
</tr>
</table>
<p><a href="showcode.asp@source=demo_db_list">View source on how to list a database table in an HTML table</a></p>
<p><b>Note:</b> If you click on a button in the "no" column a new page will open. On the new page you may look at the source on how to create input fields based on the fields from one record in the database table.</p>
</body>
</html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?