How can i display timetable using sqlserver with the time appearing as headers

[Makumbi]

iam trying to use this link to create a time table but my problem is presenting it as seen in the images below
https://stackoverflow.com/questions/...able-using-sql


How can i diplay atime table like this below using sqlserver
this is what i want to display


currently my view is displaying records in this way
Attachment 192889

[jdelano]

There are some third-party data grid controls that allow for some fancy formatting. This article goes over some of the more popular options

https://visualstudiomagazine.com/art...llections.aspx

[dday9]

Essentially what you're wanting to create is a pivot table, but it's not as simple as that because you want to block some time out entirely (e.g. 10:30 - 11:30 you want to display BREAK vertically.

Leaving aside the custom time blocks, what language are you doing this in. Did you want to do this on the front-end using JavaScript (or some flavor thereof), the back-end using VB.NET or C#, or the database layer using SQL?

The concept is the same, but the implementation will vary depending on where you want the data to be manipulated.

[Makumbi]

Essentially what you're wanting to create is a pivot table, but it's not as simple as that because you want to block some time out entirely (e.g. 10:30 - 11:30 you want to display BREAK vertically.

Leaving aside the custom time blocks, what language are you doing this in. Did you want to do this on the front-end using JavaScript (or some flavor thereof), the back-end using VB.NET or C#, or the database layer using SQL?

The concept is the same, but the implementation will vary depending on where you want the data to be manipulated.

Iam currently using sqlserver and asp.net vb

[dday9]

And where would you like to perform the business logic: front-end (JavaScript), back-end (VB.NET), or database (SQL Server)?

[Zvoni]

Adding to dday:
He has "fixed" Time-Slots (=Column-Headers) and "fixed" Day-Slots (=Row-Headers).
His business-Logic (wherever he implements it) must fit the retrieved Data into its correct slot inside this 2D-Matrix.
Meaning: He has to check the retrieved record for
1) which Day to determine the Row
2) at what Time to determine which Columns (PLURAL), since the time-slots in his Query overlap the "fixed" time-slots
3) How to proceed if a time-slot in the record overlaps into a break/Lunch time-slot (Monday 10:30 - 11:20)
4) How to display "partial" time-slots (look at Monday Course INF214)