Click here to Skip to main content
15,895,142 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear Friends,

I need design for class time table: rows as weeks and hours as columns..

I have some problem in grid. for eg. i fixed 7 hours in columns, client asked 8 hours so again need to change that design..

what is the solution for that.. any other without grid.. any other concepts.

i want to add hours dynamically..

What I have tried:

I tried 7 columns created in grid view by constantly.
Posted
Updated 26-Feb-16 0:57am
v2

1 solution

Store your data in a table like;

SQL
Row   Col   Value
-----------------
1     1     6
1     2     9
...
1     8     3
2     1     5
....


That way you can change the number of columns without needing to change the schema.
 
Share this answer
 
v2
Comments
Vivek.anand34 26-Feb-16 7:07am    
i stored like this then.. how i show like

Weeks 1 2 3 4 5 6
-------------------------------------
Monday Eng Sci Maths Social Biology
F-ES Sitecore 26-Feb-16 7:53am    
You'll need to select add data for a given row and then in code build a collection of columns programmatically.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900