Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

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



Full Text Search: The Key to Better Natural Language Queries for NoSQL in Node.js

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