-
June 29th, 2010, 10:13 PM
#1
Need to Find the Best Way to Accomplish this task.
I have a SQL database that has two tables, one is the employee table, and the other is the schedule table. The employee table has employee ID (key), Employee Name. The schedule table has Employee ID (linked to employee table), Date, StartTime (time that an employee starts), EndTime (time that an employee ends). I would like to display (and allow editing) of this table, based upon these two tables:
Employee ID Date1 Date2 Date3 ... (one for each day of week)
John Smith StartTime: StartTime: StartTime:
EndTime: EndTime: EndTime:
Michael Berg StartTime: StartTime: StartTime:
EndTime: EndTime: EndTime:
... (for all employees)
Each cell represents the starting time and ending time of the employee for that date (it varies daily).
What is the best way to acomplish this? Is a nested gridview possible to implement this? Thank you in advance for your help.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|