Copy the ASP code below to a text editor:
<html>
<head>
<title>emp_table.asp</title>
</head>
<body bgcolor="#FFFFFF">
<%
' This is how to talk to a
database
set conntemp=server.createobject("adodb.connection")
conntemp.open "DSN=employee"
p1=request.querystring("ID")
temp="select * from emp_general_info"
set rstemp=conntemp.execute(temp)
howmanyfields=rstemp.fields.count -1%>
<table border="1">
<tr>
<% This is a way to put headings on the table of field names
for i=0 to howmanyfields %>
<td><b><%=rstemp(i).name %></b></td>
<% next %>
</tr>
<% ' This is a way
to grab the records from the table
do while not rstemp.eof %>
<tr>
<% for i = 0 to howmanyfields%>
<td valign="top"><% = rstemp(i) %>
</td>
<% next %>
</tr>
<% rstemp.movenext
loop
rstemp.close
set rstemp=nothing
conntemp.close
set conntemp=nothing%>
</table>
</body>
</html>
Save your file as 'emp_table.asp' onto your IIS Server.
