Click here to Skip to main content
12,501,406 members (51,173 online)
Click here to Skip to main content
Add your own
alternative version

Stats

84K views
2.7K downloads
46 bookmarked
Posted

Universal generic database record maintenance (MS Access or SQL Server)

, 21 Nov 2002
Rate this:
Please Sign up or sign in to vote.
ASP.NET universal generic database application, based on one table from either an Microsoft Access2000 or SQL Server 2000 database. It comes in 2 versions: ASP Classic or ASP.NET

Sample Image

Introduction

ASP.NET universal generic database application, based on one table from either an Microsoft Access2000 or SQL Server 2000 database. It comes in 2 versions :- ASP Classic or ASP.NET

Logic and process flow is exactly the same, even to the extent of having the same program names (ie *.asp & *.aspx), except the ASP.NET version uses the Calendar control. This sample application is a good example of migrating from ASP to ASP.NET, using much of the same code, and how to make it perform better in ASP.NET.

It must be stressed that the ASP.NET version can be improved upon by using standard controls, such as datagrid, etc..

Features

  • Web Page security List
  • Records displayed in synchronization Field
  • record validation 
  • Update, Add and Delete record functionality 
  • Automatic list refresh function 
  • Calendar and Date conversion 
  • Automatic window sizing (according to monitor size) 
  • Use of multiple frames Netscape and Explorer compatability on PC & Mac 
  • Automatic list checkbox record update 
  • Use of images as buttons 
  • Extensive use of Javascript 
  • Example of a drop-down list Use of modal windows

Using the code

Below is the program flowchart associated with the application 

Program Flowchart

Points of Interest

This application is a good example of migrating from ASP Classic to ASP.NET, without making too much change to the code. The only major difference is the use of the ASP.NET Calendar Control.

History

This is Version 1.0

License

This article has no explicit license attached to it but may contain usage terms in the article text or the download files themselves. If in doubt please contact the author via the discussion board below.

A list of licenses authors might use can be found here

Share

About the Author

Kalvin Ernst
Web Developer
Australia Australia
No Biography provided

You may also be interested in...

Pro
Pro

Comments and Discussions

 
GeneralGeneric Maintenance Pin
Razor Miles23-Jul-08 21:01
memberRazor Miles23-Jul-08 21:01 
GeneralRe: Generic Maintenance Pin
kalvin ernst18-Feb-09 15:45
memberkalvin ernst18-Feb-09 15:45 
GeneralI would say that's too bad Pin
RG23-Dec-04 20:12
memberRG23-Dec-04 20:12 
GeneralFYI Pin
cespinos25-Nov-02 17:21
membercespinos25-Nov-02 17:21 
QuestionSo what's the purpose of the article? Pin
Vagif Abilov25-Nov-02 13:29
memberVagif Abilov25-Nov-02 13:29 

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.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.160919.1 | Last Updated 22 Nov 2002
Article Copyright 2002 by Kalvin Ernst
Everything else Copyright © CodeProject, 1999-2016
Layout: fixed | fluid