Click here to Skip to main content
11,438,636 members (71,423 online)
Click here to Skip to main content

Display records in a table using ASP

, 2 Jun 2002
Rate this:
Please Sign up or sign in to vote.
A beginners guide to displaying records from a database in a table using ASP

Introduction

The following code will allow you to display the contents of a database table in an HTML table. The HTML table is built dynamically as the records are pulled out of the database. Minimal changes are necessary if you copy and paste this code - basically just change the DSN, table and field names. Note this example has an inner table for formatting purposes, but it is not necessary.

Code

<%@ Language="VBScript%">
<html>
<head>
<title>Display all Records</title>
</head>
<body>
<%
strSQL = "Select * from TableName;" 'create SQL string (where clauses etc 
'should be added according to what you would like displayed)
SET DbObj = Server.CreateObject("ADODB.Connection") 'set up the 
'ADO connection
DbObj.Open "DSN=DSNName","username","password" 'open the connection to 
'the database, using DSN - set up the DSN in your control panel

SET oRs = DbObj.Execute(strSQL) 'Execute the SQL statement
%>
<center>
<%
DO WHILE NOT oRs.EOF
on error resume next
%>
<table border="1" width="100%" bordercolor="#00FFFF">
<tr>
<td width="35%">
<table border="0" width="96%">
<tr>
<td width="100%"><font color="#000080" size="4">
Display field description here: <% = oRs.Fields("FieldName") %></td>
</tr>
</table>
</td>
<font color="#000080" size="4">
<td width="65%">  <% = oRs.Fields("FieldName") %></td></font>
</tr>
</table>
<% oRs.MoveNext %>
<% Loop %> 'Go to the next record if not end of file
</center>
<% DbObj.Close 'Close the database connection
SET DbObj = Nothing 'Clean up after yourself
%>
</body>
</html>

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Megan Forbes
Web Developer
Australia Australia
I am a South African web / SQL developer currently spending my time as a mum. My other passion is photography and have put a small portfolio up here[^]

Comments and Discussions

 
Questionweb based search Application Pin
Mailk Kashif Zulfiqar20-Apr-07 2:01
memberMailk Kashif Zulfiqar20-Apr-07 2:01 
Generaldb connection Pin
benet fernandes18-Mar-07 0:10
memberbenet fernandes18-Mar-07 0:10 
QuestionPlease give me a way for display pictures which store in DB Access 2003 by &quot;OLE object&quot;? Pin
tuyenhnp25-Sep-05 17:50
membertuyenhnp25-Sep-05 17:50 
GeneralHandy Article, Megan! Pin
Roger Wright26-Jul-04 5:23
memberRoger Wright26-Jul-04 5:23 
GeneralCode won't work using SunOne asp Pin
Anonymous10-Mar-04 23:31
sussAnonymous10-Mar-04 23:31 
GeneralNewB suggestion from a NewB Pin
paxtonk24-Nov-03 12:23
memberpaxtonk24-Nov-03 12:23 
GeneralJust a suggestion..... Pin
Christian Graus3-Jun-02 13:02
memberChristian Graus3-Jun-02 13:02 
GeneralRe: Just a suggestion..... Pin
Nish - Native CPian4-Jun-02 1:01
memberNish - Native CPian4-Jun-02 1:01 
GeneralRe: Just a suggestion..... Pin
Jon Sagara4-Jun-02 2:43
memberJon Sagara4-Jun-02 2:43 
GeneralRe: Just a suggestion..... Pin
Nish - Native CPian4-Jun-02 18:32
memberNish - Native CPian4-Jun-02 18:32 
GeneralRe: Just a suggestion..... Pin
Megan Forbes24-Sep-02 2:19
memberMegan Forbes24-Sep-02 2:19 
GeneralRe: Just a suggestion..... Pin
Nishant S13-Oct-03 20:44
staffNishant S13-Oct-03 20:44 
JokeRe: Just a suggestion..... Pin
uk_rain_sky11-Mar-06 4:03
memberuk_rain_sky11-Mar-06 4:03 
GeneralRe: Just a suggestion..... Pin
Nishant Sivakumar12-Mar-06 13:21
staffNishant Sivakumar12-Mar-06 13:21 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.150506.1 | Last Updated 3 Jun 2002
Article Copyright 2002 by Megan Forbes
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid