Solved

dynamic classic asp form

Posted on 2015-01-27
5
118 Views
Last Modified: 2015-01-29
Team - I am creating project management application in classic asp. since the milestones will be different from project to project, I created a Template table to save milestones with milestone id and template id as primary and foreign key. I also have a project master table with project id  being primary key. I am facing problem to call the milestones dynamically and saving them to ms sql.

Ex: project id is 5000
template Id is 2000 which has milestone id from 1 to 10.

In the dynamic form I would like to display milestone name, start date, end date, resource name and allocated hours and save them to sql. Kindly help
0
Comment
Question by:Manju
  • 3
  • 2
5 Comments
 
LVL 6

Author Comment

by:Manju
ID: 40574492
To Add:

Tables in SQL:
1. Project Master (ProjectID)
2. Resource Master (ResourceID, ProjectID)
3. Template Master (TemplateID, MilestoneID, MilestoneName)

How do I want my front end to look:
ProjectID (Hidden)
TemplateID (Hidden)
MilestoneId (Hidden)
MilestoneName (Visible)
StartDate (Visible - should be a datepicker)
EndDate (Visible - should be a datepicker)
ResourceName (Visible - drop down from Resourcemaster for this projectid)
Hours (visible - textbox)
Upon "Save" button, it should save the below in "Milestone Master" Table
ProjectID
TemplateID
MilestoneID
MilestoneName
MilestoneStartDate
MilestoneEndDate
ResourceName
AllocatedHours
Status ("New")

Kindly help pls
0
 
LVL 33

Expert Comment

by:Big Monty
ID: 40575525
i'm unclear on what you're asking here, can you be more specific? are you looking for someone to write this out for you? i highly doubt you'll find anyone on EE who'll do that. have you written any code yet and are stuck at a specific point?

also, is there a specific reason why you're writing out your own project management app? There are countless ones out there, doing a quick google search for "project management application" yields tons of results. would none of those work for you?
0
 
LVL 6

Author Comment

by:Manju
ID: 40575625
I need help in logic. I am able to dynamically display fields that I want but need help in logic so that I can save them correctly in sql. Any help or guide to that direction would be helpful.  Pls
0
 
LVL 33

Accepted Solution

by:
Big Monty earned 500 total points
ID: 40575831
You need a way to tie the Templates table to the Projects table, right? I would do this by adding a ProjectID to your Templates table, or if you only have a fixed amount of Templates, create a cross reference table that contains both ProjectID and TemplateID, that way you can properly retrieve your data.

For saving everything, I would created a stored procedure and pass all of the data as parameters into it, then do your INSERT or UPDATE statements there
0
 
LVL 6

Author Closing Comment

by:Manju
ID: 40578012
Thanks for pointing me to the right direction. I was able to fix the problem.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question