Images in ASP

Now lets create the database connection

set conntemp=server.createobject(“adodb.connection”)
Set con =
Server.CreateObject(“ADODB.Connection”)

Now lets open the database connection,
create the SQL Statement and open the result set,  my
ODBC name here is image and the table i am
going to query is called image

con.Open
“DSN=image;”
Set rs =
server.createobject(“adodb.recordset”)
rs.Open “select *
from image”, con
do While not rs.EOF
%>

The code so far
was pretty standard, creating a connection, opening recordset
and run the query. Now lets go to te interesting part, how to
add the images 🙂

First we need to add a bit
HTML code for the table display

Now lets finish the rest
of the code and close the HTML tags.

rs.moveNext
loop
%>