Click here to Skip to main content
14,212,594 members
Click here to Skip to main content
Article
Posted 20 Jan 2000

Stats

836.3K views
1.7K downloads
44 bookmarked

ASP Guestbook Application

,
Rate this:
4.33 (8 votes)
Please Sign up or sign in to vote.
4.33 (8 votes)
17 Oct 2000     CPOL    
A simple guestbook application using ASP and an Access database
  • Download source files - 15 Kb

    Overview

    This is a small ASP (Microsoft Active Server Pages) application that implements a guestbook.

    The guestbook has the following main-functionality:

    • Display entries with author-name, e-mail, date and text
    • Administration mode: delete entries
    • Navigation: jump to first page, last page, previous page, next page, discrete pages

    The sample is ready-to-use. As-few-as-possible HTML-formating (e.g. fonts) is done in order to keep it clear. You could modify the following things:

    • Change the language of the texts
    • Adjust the design to your needs
    • Extend the functionality (please e-mail me, if you improved it, since I'm very interested in any improvements)

    Details

    The guestbook stores its entries in a Microsoft Access 2000 database (Access 97 works quite well, too - just convert the database) and accesses the database using ADO (Microsoft ActiveX Data Objects, see http://www.microsoft.com/data/ado/). To use the Access 2000 database, you probably need the latest version of the Microsoft Data Access Components (MDAC, also from http://www.microsoft.com/data/ado/).

    I tried to comment the ASP code as well as I can. When you look through it with a syntax-coloring editor, you should find the comments quite easily. I also tryied to minimize the allways-present problem of having code mixed with design/content be separating ASP from HTML as much as I can. Still I wanted to keep all things in one file to make it compact. So the ASP pages became a bit longer than it normally would.

    I'm running this guestbook under a german version of NT 4.0 server, service pack 6a (the 'a' is very important). Altough, SP 4 or 5 should be no problem, too.

    A last tip for editing ASP files: I tried a lot of editors (including Frontpage, InterDev, etc.), I found the most usable program is EditPlus, which you can find on http://www.editplus.com/.

    Please feel free to ask any questions you have by e-mail: keim@zeta-software.de.

    History

    18 Oct 2000 - updated script.

  • License

    This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Share

    About the Author

    Uwe Keim
    Chief Technology Officer Zeta Producer Desktop CMS
    Germany Germany
    Uwe does programming since 1989 with experiences in Assembler, C++, MFC and lots of web- and database stuff and now uses ASP.NET and C# extensively, too. He has also teached programming to students at the local university.

    In his free time, he does climbing, running and mountain biking. Recently he became a father of a cute boy.

    Some cool, free software from us:

    Deutschsprachiges Forum zu Elektromobilität und Tesla  
    Windows 10 Ereignisanzeige  
    German Developer Community  
    Free Test Management Software - Intuitive, competitive, Test Plans. Download now!  
    Homepage erstellen - Intuitive, very easy to use. Download now!  
    Send large Files online for free by Email
    Offline-Homepage-Baukasten

    Comments and Discussions

     
    GeneralWow Pin
    5-Dec-00 3:05
    suss5-Dec-00 3:05 
    Generalquestion: Pin
    19-Nov-00 22:26
    suss19-Nov-00 22:26 
    GeneralRe: question: Pin
    17-Mar-01 5:53
    suss17-Mar-01 5:53 
    Generaltest 123 Pin
    Tester28-Oct-00 21:43
    memberTester28-Oct-00 21:43 
    GeneralGuestbook example not accessible Pin
    Thomas Freudenberg18-Oct-00 22:16
    memberThomas Freudenberg18-Oct-00 22:16 
    GeneralRe: Guestbook example not accessible Pin
    Uwe Keim19-Oct-00 20:37
    sitebuilderUwe Keim19-Oct-00 20:37 
    GeneralRe: Guestbook example not accessible Pin
    8-Jan-01 20:46
    suss8-Jan-01 20:46 
    Generalcool guestbook Pin
    DanS5-Oct-00 10:45
    memberDanS5-Oct-00 10:45 
    GeneralRe: cool guestbook Pin
    9-Jun-01 2:01
    suss9-Jun-01 2:01 
    GeneralTesting 1234 Pin
    Mr. Johann Montague Test4-Oct-00 4:45
    sussMr. Johann Montague Test4-Oct-00 4:45 
    Generalwhy not Pin
    Double A2-Oct-00 19:09
    memberDouble A2-Oct-00 19:09 
    GeneralHelp with guestbook Pin
    Jake Groshong2-Oct-00 10:20
    sussJake Groshong2-Oct-00 10:20 
    GeneralRe: Help with guestbook Pin
    Cello15-Oct-00 20:03
    memberCello15-Oct-00 20:03 
    GeneralRe: Help with guestbook Pin
    Uwe Keim15-Oct-00 20:10
    sitebuilderUwe Keim15-Oct-00 20:10 
    GeneralRe: Help with guestbook Pin
    Cello18-Oct-00 1:41
    memberCello18-Oct-00 1:41 
    GeneralRe: Help with guestbook Pin
    Uwe Keim18-Oct-00 1:48
    sitebuilderUwe Keim18-Oct-00 1:48 
    GeneralOK - welcome Pin
    Mike18-Sep-00 4:49
    memberMike18-Sep-00 4:49 
    GeneralRe: OK - welcome Pin
    27-Sep-01 0:32
    suss27-Sep-01 0:32 
    Generalio Pin
    Mario9-Sep-00 3:49
    memberMario9-Sep-00 3:49 
    GeneralRe: io Pin
    test20-Sep-00 1:23
    membertest20-Sep-00 1:23 
    Generalteste Pin
    teste1-Sep-00 16:31
    memberteste1-Sep-00 16:31 
    QuestionWhat have I done to deserve this? Pin
    Uwe Keim30-Aug-00 20:33
    sitebuilderUwe Keim30-Aug-00 20:33 
    AnswerRe: What have I done to deserve this? Pin
    Jon Sagara7-Nov-01 19:24
    memberJon Sagara7-Nov-01 19:24 
    GeneralRe: What have I done to deserve this? Pin
    Nish Nishant7-Nov-01 19:32
    sitebuilderNish Nishant7-Nov-01 19:32 
    Generaltestbook Pin
    ab30-Aug-00 14:20
    memberab30-Aug-00 14:20 

    General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

    Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

    Layout: fixed | fluid

    Article Copyright 2000 by Uwe Keim
    Everything else Copyright © CodeProject, 1999-2019

    Server Web01
    Version 2.8.190619.2