Prev Next

ADO Display

Displaying data retrieved using ADO allows you to present query results dynamically in your ASP pages. This section focuses on formatting and outputting data effectively.

Key Topics

Basic Data Display

Example

<%
    Dim conn, rs
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;User ID=myUser;Password=myPassword;"

    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open "SELECT EmployeeName FROM Employees", conn

    Do Until rs.EOF
        Response.Write(rs("EmployeeName") & "<br>")
        rs.MoveNext
    Loop

    rs.Close
    conn.Close
    Set rs = Nothing
    Set conn = Nothing
%>

Explanation: This example retrieves and displays all employee names from the Employees table in a basic format.

Formatted Data Display

Example

<html>
<body>
<table border="1">
    <tr>
        <th>Employee Name</th>
    </tr>
    <%
        Do Until rs.EOF
            Response.Write("<tr><td>" & rs("EmployeeName") & "</td></tr>")
            rs.MoveNext
        Loop
    %>
</table>
</body>
</html>

Explanation: This example demonstrates how to display query results in a formatted HTML table for better readability.

Key Takeaways

  • ADO enables dynamic data display on web pages.
  • Formatted output improves data readability and user experience.
  • Always iterate through the Recordset to display multiple rows of data.
Prev Next