Simple Project Management with ASP

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.

dbPath = Server.MapPath("projectdb.mdb")

dbPath = "C:\inetpub\data\projectdb.mdb"

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

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

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

Users can also me added and changed as needed.

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

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