Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


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

Create an HTML Report From a SQL Server Database

Question:
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?

Answer:

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.

 

 

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