I'm trying to create a table/sheet that will display an employer's job schdeule for the week. Most of the information will come from several tables within a database. This table/sheet will consists of the following columns:
Comments-> These 3 columns/fields represent actual colums within the database
7 columns representing days of the week, with the first column representing Today's date, the next column representing the next day...-> The 7 columns for the dates will not come from the database itself (as opposed to the other columns). These will be updated daily to represent the employer's schedule for the week. MY ISSUE IS THIS: One of the DB tables holds a column "StartDate" (which represents the start date of a phase within a particular job). I need to check whether this "StartDate" is equal to the date column (the image will make this more clear). Obviously, 1 job has MANY phases.
An example of a such table would as follows (for the employee whose D_ID is = '555'):
Any ideas how I can create such a table?? Should it be done in recursive html? Or gridlist? repeater??...
Thanks for any info
BTW, I posted this in the "Web forms" section, but I guess it is more suited to be posted here, as it is a databound issue.
View Complete Post