-- Learning not just technology, but dreams!
Home HTML JAVASCRIPT CSS VUE REACT PYTHON3 JAVA C C++ C# AI GO SQL LINUX VS CODE BOOTSTRAP GIT Local Bookmarks
ADO Tutorial
ADO Tutorial
ADO Introduction
ADO Database Connection
ADO ADO Recordset
ADO Display
ADO Query
ADO Sort
ADO Add Records
ADO Update Records
ADO Delete Records
ADO Speed Up Scripts
ADO Command Object
ADO Connection Object
ADO Error Object
ADO Field Object
ADO Parameter Object
ADO Property Object
ADO Record Object
ADO Recordset Object
ADO Stream Object
ADO Data Types
ADO Summary
ADO Examples
ADO ADO Recordset
ADO Query
Deep Dive
Software
Data Management
Computer Science
Programming
Web Applications & Online Tools
AI Tools, Chatbots & Virtual Assistants
Web Design & Development
Web Service
Web Services
ADO Display
The most common way to display data from a recordset is to display the data in an HTML table.
Display Field Names and Field Values
We have a database named "Northwind", and we want to display data from the "Customers" table (remember to save this file with the .asp extension):
Example
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM Customers", conn
do until rs.EOF
for each x in rs.Fields
Response.Write(x.name)
Response.Write(" = ")
Response.Write(x.value & "
")
next
Response.Write("
")
rs.MoveNext
loop
rs.close
conn.close
%>
Run Example »
Display Field Names and Field Values in an HTML Table
We can also display the data from the "Customers" table in an HTML table using the following code:
Example
Run Example »
Add Headers to the HTML Table
Add headers to the HTML table to make it more readable. (Keep the file extension as .html):
Example
<%for each x in rs.Fields
response.write("| " & x.name & " | ")
next%>
|
Run Example »
More Examples
Add Color to HTML Table
How to add color to an HTML table to make it more attractive.
ADO ADO Recordset
ADO Query
ByteArk Coding Plan
Supports mainstream large models like Doubao, GLM, DeepSeek, Kimi, MiniMax, officially supplied, stable and reliable.
Configuration Guide
¥9.9
/ Month
Subscribe Now
Xunfei Star Coding Plan
Includes free model call quota, DeepSeek, GLM, Kimi, MiniMax, one-stop experience and deployment platform.
Configuration Guide
¥3.9
/ Month
Subscribe Now
Click to Share Notes
Category Navigation
Python / Data Science
AI / Intelligent Development
Front-end Development
Back-end Development
Database
Mobile Development
DevOps / Engineering
Programming Languages
Computer Fundamentals
XML / Web Service
.NET
Website Building
Advertisement
ADO Tutorial
ADO Tutorial
ADO Introduction
ADO Database Connection
ADO ADO Recordset
ADO Display
ADO Query
ADO Sort
ADO Add Records
ADO Update Records
ADO Delete Records
ADO Speed Up Scripts
ADO Command Object
ADO Connection Object
ADO Error Object
ADO Field Object
ADO Parameter Object
ADO Property Object
ADO Record Object
ADO Recordset Object
ADO Stream Object
ADO Data Types
ADO Summary
ADO Examples
Online Examples
·HTML Examples
·CSS Examples
·JavaScript Examples
·Ajax Examples
·jQuery Examples
·XML Examples
·Java Examples
Character Sets & Tools
· HTML Character Set Settings
· HTML ASCII Character Set
· JS Obfuscation/Encryption
· PNG/JPEG Image Compression
· HTML Color Picker
· JSON Formatter
· Random Number Generator
Latest Updates
· Codex Advanced Configuration
· AI Agent Terminology
· ZCode Getting Started Tutorial
· Loop Engineerin...
· Claude Code Us...
· Claude Code Us...
· docker compose ...
Site Information
· Feedback
· Disclaimer
· About Us
· Article Archive
Follow WeChat
My Favorites
Mark Article
Browsing History
Clear All
No Records
YouTip