Quick Search for:  in language:    
HTML,version,available,part,commercial,produc
   Code/Articles » |  Newest/Best » |  Community » |  Jobs » |  Other » |  Goto » | 
CategoriesSearch Newest CodeCoding ContestCode of the DayAsk A ProJobsUpload
Visual Basic Stats

 Code: 3,011,557. lines
 Jobs: 115. postings

 How to support the site

 
Sponsored by:

 

You are in:

 
Login



Latest Code Ticker for Visual Basic.
Click here to see a screenshot of this code!A#vb Undernet suczs
By Xasan on 6/30

(Screen Shot)

CAPS Trigger
By Trevor Burley on 6/30


Auto clip picture
By Kenneth. Jakobsen on 6/30


Click here to see a screenshot of this code!Game of life clone (cool math)
By Johannes B on 6/30

(Screen Shot)

String to CHR()
By Nikhil Raj on 6/30


Encryption Decryption Demo
By Nikhil Raj on 6/30


Click here to see a screenshot of this code!Serial Registration
By Christian (eXonite Team) on 6/30

(Screen Shot)

Click here to see a screenshot of this code!Danger:Can pc kill me? interesting article
By Xasan on 6/30

(Screen Shot)

AniViewer
By Jerrame Hertz on 6/30


Click here to put this ticker on your site!


Add this ticker to your desktop!


Daily Code Email
To join the 'Code of the Day' Mailing List click here!





Affiliate Sites



 
 
   

Publish recordset(s) 2 HTML using template(s)

Print
Email
 
winzip icon
Submitted on: 6/1/2001 4:27:00 AM
By: Edwin Vermeer  
Level: Advanced
User Rating: By 26 Users
Compatibility:VB 6.0

Users have accessed this code 9857 times.
 

(About the author)
 
     A new version is now available as part of a commercial product. See http://siteskinner.com With this code it is very easy to publish database information as HTML. Customizing such a publication is very easy because of the use of templates. This is the second version of this code. All the votes for the previous version inspired me to make some big improvements. Thanks for the votes! :-) The screenshot below and the demo project will show you most of the possibilities of this code. New features are: . Converted the module to a class module. . Added 3 events for next record, next page and error. . It is now possible to include other templates. (subforms!) . . These templates can have their own recordset. (don’t have to) . . A 'subform' can be bound to the mainform by linking a field from the main recordset to a field in the sub recordset. (don’t have to) . . You can include multiple templates and these templates can also include multiple templates. So you can create a sub of a sub. . I added a couple of system parameters that can be used in the templates (record number, line number inside a group, even/odd line, greenbar) You can use this to give every other line a different colour. . You can put in ‘<none>’ as the page grouping and you will get one big HTML file with all the data. Features that already existed: . You can put all fields from the recordset anywhere in the template. (even within HTML tags) . You can create multiple (nested) grouping levels. Each level will have its own header, footer and detail section. . There are a lot of system parameters and it is easy to add you own. Almost all App properties can be used. This code can be useful: . When you are not able to access your database dynamically from your web server. You can use this to publish database information. . When you need an easy to use and customizable data reporting tool. . When the number of data updates is much lower than the web traffic you have. In this case static WebPages will probably give a much smaller server load. . If you created your own web server in VB. You can use this to give it functionality to access a database . When ...?

 
winzip iconDownload code

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. Afterdownloading it, you will need a program like Winzipto decompress it.

Virus note:All files are scanned once-a-day by Planet Source Code for viruses,but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:
1)Re-scan downloaded files using your personal virus checker before using it.
2)NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.
3)Scan the source code with Minnow's Project Scanner

If you don't have a virus scanner, you can get one at many places on the net including:McAfee.com

 
Terms of Agreement:   
By using this code, you agree to the following terms...   
1) You may use this code in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.   
2) You MAY NOT redistribute this code (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.   
3) You may link to this code from another website, but ONLY if it is not wrapped in a frame. 
4) You will abide by any additional copyright restrictions which the author may have placed in the code or code's description.


Other 8 submission(s) by this author

 

 
Report Bad Submission
Use this form to notify us if this entry should be deleted (i.e contains no code, is a virus, etc.).
Reason:
 
Your Vote!

What do you think of this code(in the Advanced category)?
(The code with your highest vote will win this month's coding contest!)
Excellent  Good  Average  Below Average  Poor See Voting Log
 
Other User Comments
6/1/2001 5:29:26 AM:Thushan Fernando
Inspiration Technology... Welcome to 
the new IT. (Compaq's biz tag). 5 
globes man.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/1/2001 10:24:18 AM:M@
Excellent work. Clean code, 
professional layout, great comments. 
This is a winner all around. 
BTW...you have it listed as working 
with VB5, but it doesn't. There are 
some VB6-specific functions in there 
(split, etc.)..just fyi.
You get the 
big 5 from me.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/1/2001 1:09:56 PM:Elias from NY
Cool code. It looks very professional. 
I will learn a lot by studying your 
source code. 
There is a little 
annoyance, though. You probably have 
your computer set with resolution of 
1024x768 or above because your forms 
were huge! I had to resize all objects 
to fit in my monitor set with the mere 
800x600 resolution. 
Remember that 
there are, still, people with small 
monitors (640x480 
resolution)!
Regardless of this and 
the fact that any programmer will have 
to spend allot of time to customize it 
for o their specific use (The code is 
not very portable), your code 
rules!
I am giving you 5 planets. 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/1/2001 1:15:06 PM:Bill Peek
Very Professional. The Layout is easy 
to understand. You Habe Got 5 From ME.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/2/2001 5:26:43 AM:Candido Sibon
Hoi Edwin,
Je code is deze keer ook 
zeker goed, maar nog steeds hij kan 
niet een dynamische recordset van 
andere databases omzetten in HTML die 
je de LAYOUT kan bepalen met sjablonen… 
Het is heel simpel en eenvoudig, na de 
SQL select statement moet je de column 
uit de recorset halen en columns in de 
HTML genereren vanaf die recordset 
array, en dan vul je gewoon de rest. 
Dat zou pas een goed Export to HTML 
zijn. Ik heb nog eentje gebouwd maar 
die was voor een klant van mijn dus die 
mag ik niet verstreken. In ieder geval 
je krijgt nogmaals een dikke ‘5 globes 
vote’  van me. Keep coding!
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/2/2001 8:19:28 AM:Coyote
Once again, Excellent! This is really 
nice, and is of real value and will be 
Extremely useful. Guess I can't vote 
twice, but I think the application 
should get 5 globes and your code 
should get 5 globes. Thanks for sharing 
this !
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/4/2001 8:10:50 PM:joel
nice work. very nice work... i have 
writting something similar, but more 
for interacting with the data instead 
of displaying it 
(www.intratelligent.com). i like your 
focus though ;)... watch out crystal 
reports hey? 5 stars...
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/5/2001 2:40:40 AM:DOJSYS
great code!
Kinda make another 
submission for this stuff that fit to 
600*800 resolution. 
And it would be 
great. 
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/5/2001 3:05:00 AM:Edwin Vermeer
Sorry for the resolution thing. I'm 
such a fortunate developer that has a 
dual screen setup of twice a 19" 
monitor. Next time I will make sure 
everything will fit on even a 640*480. 
My next publication (hopefully my 
3rd PSC award ;-) will be published 
within a month.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
5/25/2002 12:39:13 AM:Alain GUERIN
NICE ! Thanks for sharing, 5g.
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
6/27/2002 9:14:13 AM:Robin Schuil
Why not use XSL(T) as template? It 
provides much more functionality..
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
7/8/2002 2:39:55 AM:Edwin Vermeer
Hi, I do not use XSL(T) or anything 
else because I want to have full 
control over what happens. At this 
moment I'm adding functionality to it 
like wizards and email functionality. 
For more info see 
http://siteskinner.com
Keep the Planet clean! If this comment was disrespectful, please report it:
Reason:

 
Add Your Feedback!
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.

NOTICE: The author of this code has been kind enough to share it with you.  If you have a criticism, please state it politely or it will be deleted.

For feedback not related to this particular code, please click here.
 
Name:
Comment:

 

Categories | Articles and Tutorials | Advanced Search | Recommended Reading | Upload | Newest Code | Code of the Month | Code of the Day | All Time Hall of Fame | Coding Contest | Search for a job | Post a Job | Ask a Pro Discussion Forum | Live Chat | Feedback | Customize | Visual Basic Home | Site Home | Other Sites | About the Site | Feedback | Link to the Site | Awards | Advertising | Privacy

Copyright© 1997 by Exhedra Solutions, Inc. All Rights Reserved.  By using this site you agree to its Terms and Conditions.  Planet Source Code (tm) and the phrase "Dream It. Code It" (tm) are trademarks of Exhedra Solutions, Inc.