Click here to Skip to main content
Click here to Skip to main content

Display records in a table using ASP

By , 2 Jun 2002
Rate this:
Please Sign up or sign in to vote.

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

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 PinmemberMailk Kashif Zulfiqar20-Apr-07 1:01 
Generaldb connection Pinmemberbenet fernandes17-Mar-07 23:10 
QuestionPlease give me a way for display pictures which store in DB Access 2003 by &quot;OLE object&quot;? Pinmembertuyenhnp25-Sep-05 16:50 
GeneralHandy Article, Megan! PinmemberRoger Wright26-Jul-04 4:23 
GeneralCode won't work using SunOne asp PinsussAnonymous10-Mar-04 22:31 
GeneralNewB suggestion from a NewB Pinmemberpaxtonk24-Nov-03 11:23 
GeneralJust a suggestion..... PinmemberChristian Graus3-Jun-02 12:02 
GeneralRe: Just a suggestion..... PinmemberNish - Native CPian4-Jun-02 0:01 
GeneralRe: Just a suggestion..... PinmemberJon Sagara4-Jun-02 1:43 
GeneralRe: Just a suggestion..... PinmemberNish - Native CPian4-Jun-02 17:32 
GeneralRe: Just a suggestion..... PinmemberMegan Forbes24-Sep-02 1:19 
GeneralRe: Just a suggestion..... PinstaffNishant S13-Oct-03 19:44 
JokeRe: Just a suggestion..... Pinmemberuk_rain_sky11-Mar-06 3:03 
GeneralRe: Just a suggestion..... PinstaffNishant Sivakumar12-Mar-06 12: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 | Mobile
Web04 | 2.8.140415.2 | Last Updated 3 Jun 2002
Article Copyright 2002 by Megan Forbes
Everything else Copyright © CodeProject, 1999-2014
Terms of Use
Layout: fixed | fluid