Solved

dynamic classic asp form

Posted on 2015-01-27
5
119 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Why Bundles is not working on certain files - ASP MVC 3 65
ASP Button to clear text 4 67
jquery to restrict certain words from input in form 11 45
Validating Date 4 28
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

679 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