Time Table of School

[KKSohaib]

I have project "Time Table of school". How it possible logically as well as visually in .NET. it contain all teachers name and their periods. when any one absent then we enter the name of teacher or course name, highlight the absent teacher periods and then generate arrange period list and print it.
when it highlight timetable we click on them and show all other teacher names who are free at this time.......


what controls are need in .NET with c#. it will be desktop application,
Please help me how it possible, I want to make as simple as possible.


thanks in advance.....

[Mikkeee]

That's like asking 'what parts do i need to build a fast car'. You need to start with a database, grid, and some C# code but what you're asking is how to build the entire project. You need to start with a more specific question.

[KKSohaib]

@Mikkeee
data desiging is almost complete... now time to develop visual design ..... how it possible in grid... any other control do you know ?

[M1kkelZU]

Well I have a sort of the same thing, except it reads a file and splits the needed area and places this in to a database.
You'll need to have a logical system with the grid and Start off with textboxes for inputs etc. after a while when this is finished go on to actually making the grid the most important part and from there on its not too hard in my opinion.

[KKSohaib]

hope so I complete in next 4 days ....
can I use datagriview ?because when any teacher is absent how it is highlight ? can I highlight programmatically ???

[M1kkelZU]

Yeah a datagridView should be fine. You can use a tabPage panel for 2 different grids, 1 for the roster and 1 for the absent/present teachers. to highlight programmatically you'll need a system where the absent or present teacher sends a message to the program and have a database behind it all to keep the system aquired.

you can set the value of a cell to 1 or 0 ( 1 meaning present and 0 meaning absent, like a true false situation ) and have a weekly view for each week.

You could make 1 datagridview and have the same concept: teacher sends a message to the server as absent or present and then the program highlights the absent teacher. if the teacher is present nothing happens.

[KKSohaib]

can use click event in dgview cell ?
when admin click on highlighted cell any control show names of teacher that are free at that time ..... which control I use for this purpose ..... selected teacher is set as arrange period in that clss.... I want to print all arrange periods list at same page ... how it possible ?

[M1kkelZU]

Yes, I'd guess the dataGridView1_CellContentClick event should be a good way to manage this.

Well the cell will be highlighted as soon as you click on this cell, so you could make a second form and use this for the functions wanted, to open a second form then would be adding it to the project and using this code in the cell content click

Form2 f2 = new Form2();
f2.Show();

Excuse me if you know how to do this, just a pointer though.
In this form you can add a function that changes the state of the teacher (Absent / Present) or change the time from Absent until <insert Time here> with a reason etc.

[KKSohaib]

I think new form option is best for free teacher list... but problem is how absent teacher cell highlight and admin click event on that cell....

[M1kkelZU]

That is where you need a second program to connect to a server OR you have someone who is a physical admin and when a teacher calls and says they are absent, the physical admin puts it in the system (your application) and then the cell is highlighted for the teacher that is absent, when you click on the cell you get a message with a reason of why they are absent etc,.

[KKSohaib]

yes I use SQL server and Physical admin for data entry...
thanks for a help ..... thanks a lot
KK Sohaib