<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META NAME="description" CONTENT="Insert page description here">
<META NAME="keywords" CONTENT="Insert page keywords here">
<META HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-1">
<TITLE>Page Title</TITLE>
<SCRIPT LANGUAGE="JavaScript">
<!--
function LoadPage()
{
//timevalue=setTimeout("document.CustInfoForm.submit()", 2000);
}
-->
</SCRIPT>
</HEAD>
<BODY bgcolor="black" text="white" onload="LoadPage()">
<!-- BODY bgcolor="black" text="white" -->
ASP
<br>
<%
set connNW = server.createobject("ADODB.Connection")
connNW.open "northwind"
Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = connNW
cmdDC.CommandText = "SELECT customerid,companyname,contactname,city,phone,fax FROM Customers;"
cmdDC.CommandType = 1
Set rsDC = Server.CreateObject("ADODB.Recordset")
rsDC.Open cmdDC, , 0, 1
%>
<table border=1>
<TR>
<TH>customerid</TH>
<TH>companyname</TH>
<TH>contactname</TH>
<TH>city</TH>
<TH>phone</TH>
<TH>fax</TH>
</TR>
<% do while not rsDC.eof %>
<tr>
<td><%= rsDC.Fields(0) %></td>
<td><%= rsDC.Fields(1) %></td>
<td><%= rsDC.Fields(2) %></td>
<td><%= rsDC.Fields(3) %></td>
<td><%= rsDC.Fields(4) %></td>
<td><%= rsDC.Fields(5) %></td>
</tr>
<% rsDC.movenext
loop
%>
</table>
<% rsDC.Close
Set rsDC = Nothing
connNW.close
set connNW = Nothing
%>
<form method="post" name="CustInfoForm" action="northwind.asp">
<input type="submit" value = "rerun">
</form>
</body>
</html>