📄 ado_display.asp@output=print

📁 W3Schools tutorial..web designing
💻 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 Display</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 Display</h1>
<a href="ado_recordset.asp"><img border="0" src="../images/btn_previous.gif" alt="prev" width="100" height="20" /></a>
<a href="ado_query.asp"><img border="0" src="../images/btn_next.gif" alt="next" width="100" height="20" /></a>
<hr />

<p class="intro">The most common way to display data from a recordset, is to
display the data in an HTML table.&nbsp;</p>
<hr />
<h2>Examples</h2>
<p><a target="_blank" href="showasp.asp@filename=demo_display1">Display records</a><br />
How to first create a database connection, then 
a recordset, and
then display the data in HTML.</p>
<p><a target="_blank" href="showasp.asp@filename=demo_display2">Display records in an HTML table</a><br />
How to display the data from the database table in an
HTML table.</p>
<p><a target="_blank" href="showasp.asp@filename=demo_display3">Add headers to the 
HTML table</a><br />
How to add headers to the HTML table to make it more
readable.</p>
<p><a target="_blank" href="showasp.asp@filename=demo_display4">Add colors to the HTML table</a><br />
How to add colors to the HTML table to make it look nice.</p>
<hr />

<h2>Display the Field Names and Field Values</h2>
<p>We have a database named &quot;Northwind&quot; and we want to display the
data from the &quot;Customers&quot; table (remember to save the file with an 
.asp extension):</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
  <tr>
    <td>
      <pre>&lt;html&gt;
&lt;body&gt;</pre>
      <pre>&lt;%
set conn=Server.CreateObject(&quot;ADODB.Connection&quot;)
conn.Provider=&quot;Microsoft.Jet.OLEDB.4.0&quot;
conn.Open &quot;c:/webdata/northwind.mdb&quot;</pre>
      <pre>set rs = Server.CreateObject(&quot;ADODB.recordset&quot;)
rs.Open &quot;SELECT * FROM Customers&quot;, conn</pre>
      <pre>do until rs.EOF
  for each x in rs.Fields
    Response.Write(x.name)
    Response.Write(&quot; = &quot;)
    Response.Write(x.value &amp; &quot;&lt;br /&gt;&quot;) 
  next
  Response.Write(&quot;&lt;br /&gt;&quot;)
  rs.MoveNext
loop</pre>
      <pre>rs.close
conn.close
%&gt;</pre>
      <pre>&lt;/body&gt;
&lt;/html&gt;</pre>
    </td>
  </tr>
</table>
<p>Here is the result:</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
  <tr>
    <td>
      CustomerID = ALFKI<br />
      CompanyName = Alfreds Futterkiste<br />
      ContactName = Maria Anders<br />
      ContactTitle = Sales Representative<br />
      Address = Obere Str. 57<br />
      City = Berlin<br />
      PostalCode = 12209<br />
      Country = Germany<p>CustomerID = BERGS<br />
      CompanyName = Berglunds snabbk鰌<br />
      ContactName = Christina Berglund<br />
      ContactTitle = Order Administrator<br />
      Address = Berguvsv鋑en 8<br />
      City = Lule
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -