|
Steve D.
Average Member
USA
640 Posts |
 Posted - 27 January 2004 : 22:44:40
|
The end result of what I want to do is here http://www.TeaPartySwings.com/workshops.aspx
So I was able to fudge what I wanted to do, but i don't think it's the most elegant approach.
Essentially I have 5 database tables that I'm pulling the necessary information with three different queries.
the db tables (unnecessary info not listed below)
EventDays (daysID, day) stores the different days
ClassTimes (timeID, startTime, day) store class start time and day
Workshops (classID, className, classDescription, instructorID, timeID, roomID)
Instructors (instructorID, instructorName)
Ballrooms (roomID, roomName)
Essentially there are 4 days for the event. Each day has a different number of time slots which workshops are offered. There are 5 workshops offered per timeslot.
What I did was create 3 queries and looped through each of them.
The first query was to retrieve all of the days.
As I loop through each day, the day is passed in to the next query to retrieve all of the time slots for the day.
As I loop through each timeslot the timeslot is passed in to the next query to retrieve all of the classes for that day.
I then manually build the table.
Like I said it works, but I don't think it's the best solution especially using .NET
I've tried to use a Repeater, Datalist, & Datagrid but the problem I run in to is I need not only a header but a column on the left hand side to indicate the class time and then I need to iterate through 5 classes etc...
Any ideas I'd love to hear them. Thanks
|
Swing Dancing Video Clips - It's All Swing! Forum |
Edited by - Steve D. on 27 January 2004 22:49:05 |
|
Topic Locked
