Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Language: Active Server Pages (ASP)
Expertise: Beginner
Nov 19, 1999



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Create an HTML Report From a SQL Server Database

I want a simple way to get a report from a SQL server database to HTML. Then I want the report to print, nicely formatted. How do I do this? Also, should I be doing something else that's a better way to get reports on the Web?


The following sample page can be written to do just what you asked. It requires Active Server Pages (ASP) and SQL Server. Note that the value of the strConnect variable is very important. "Initial Catalog" represents the database from which the data will be extracted. "Data Source" represents the name of the server on which that database is running. Copy and paste this code into one of your own ASP pages. It should produce a simple, yet organized report.

<%@ Language=VBScript %>





 strConnect = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=Pubs;Data Source=CAISON"
 Dim conn
 set conn=Server.CreateObject("ADODB.Connection")
 conn.Open strConnect,sa, ""
  Dim rs
  set rs=Server.CreateObject("ADODB.Recordset")
  rs.Open "Select * FROM Authors",conn


Authors Report

<% do until rs.EOF %> <% rs.MoveNext loop %>
<%=rs.fields(0).name%> <%=rs.fields(1).name%> <%=rs.fields(2).name%> <%=rs.fields(3).name%>
<%=rs(0).value%> <%=rs(1).value%> <%=rs(2).value%> <%=rs(3).value%>

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date