I am developing a reporting system for schools in asp.net and wish to integrate Timetable generation for teachers to help them in their daily schedules
I have 3 tables that supports timetable generation. The tables are
Now I found a way to populate the Timetable table with all the required fields and even performed some validations on it without hassles. But the problem I have here is presenting the data in a table generated on an .aspx page. The number of rows in the table should be the same as the number of records in theWorkDay table and the number of columns should also match the number of records in theLecturePeriods Table while the subjects will be filled in the cells appropriately as it is in the database. Below lies the illustration I'm talking about.
9.00am – 9.30am
9.30am – 10.00am
10.00am – 10.30am
10.30am – 11.00am
11.00am – 11.30am
Monday
Tuesday
Wednesday
Thursday
Friday
I have searched the internet for a solution to this but didn't find any. I'm hoping one of you whiz-coders will help me out of this challenge. Many Thanks.