Click here to Skip to main content
Click here to Skip to main content
Go to top

Simple Project Management with ASP

, 18 Apr 2005
Rate this:
Please Sign up or sign in to vote.
A simple, easy to use and setup project management with asp and ms access.

Sample Image - asp-project.gif

ASP Project

Download Full Source for ASP Project

A very simple online project management tool. I was looking for an easy way to keep track of things I was working on, everything else was way over complicated. I quickly created this simple task management solution with ASP and MS Access.

Copy all the files to your web server. The database path is set using the mappath statement, so if you would like to place your database in a different place, then edit line 55 in common.asp.

from:
dbPath = Server.MapPath("projectdb.mdb")
to your path (example):
dbPath = "C:\inetpub\data\projectdb.mdb"

Once setup, the defaut login is "admin", with a password of "1234".

project list

You will see the project list, each heading is sortable desc or asc by clicking on the title, easily change the order of the projects by changing the number and clicking "update order", this will loop through each project and update the sort value. Sample code below.

trFormList = Request.Form("projorder")
strIDList = request.form("id")
if strFormList = "" then
    Response.Write "<p>Error</p>"
    response.redirect("projects.asp?order=error")
Else

    'on Error resume next
    FormList = split(strFormList, ",")
    IDList = split(strIDList, ",")

    For iLoop = LBound(FormList) to UBound(FormList)

        pageorder = Trim(FormList(iLoop))
        'make sure value is a number
            if not IsNumeric(pageorder) then
            pageorder = "1"
            end if

        id = Trim(IDList(iLoop))
            'make sure value is a number
            if not IsNumeric(id) then
            response.write "<p>Error, not a valid number</p>"
            response.end
            end if

        if pageorder > 0 then
        set Conn = server.createobject("adodb.connection")
        Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath
        mySQL = "UPDATE tblproj SET projorder = " & pageorder & " WHERE ID = " & ID & ";"
        conn.execute(mySQL)
        end if

    Next

end if

Simply click on the project name to view and edit the project details

project details

Categories and status values can be edited easily to match your needs.

project category

edit category

project status

Users can also me added and changed as needed.

project users

That's it, nothing fancy, but if you need a quick and simple way to keep track of tasks/projects, then give it a try.

Download all files and full source here. ASP Project

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

aa2max

United States United States
Live in Michigan, USA

Comments and Discussions

 
GeneralWhere can I download the code of this project Pinmemberraedazab22-Dec-05 8:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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 | Mobile
Web04 | 2.8.140916.1 | Last Updated 18 Apr 2005
Article Copyright 2005 by aa2max
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid