I am using Visual Web Developer 2005 and SQL Server 2005 Express to track the status of a project. I have a table called WeekObjectiveStatus. This table has 5 fields:
I am trying to get a page to have the project manager easily update the status of the project on a weekly basis.
Idealy, all Objectives (from a table called Objectives) would be displayed on a grid and the manager would update the WeekEnd, ObjectiveStatus and ObjectiveStatusComments.
Here is were my problem is.
I only want one row for each objective
The ObjectiveStatus should be a RadioButtonList (Red, Yellow and Green)
If the ObjectiveStatus is not Green, they must enter an ObjectiveStatusComment.
I am trying to figure out the best method. GridVIew, Repeater, etc. I don't think I can hardcode a table because there may be new Objectives added in the future. Any help getting started will be appreciated.