hi..
what you can do is you can create one table on the left side lets say of 6*6 in which you can enter the dates from (1st-31st) or (1st-30th). each column represnt one date, you must be storing data of leave and activities of employee in some back-end, so you can fetch that data and add it to particular column.
Now catch here is that you can create this table dynamically through programming.
here is a link to add rows and its cells dynamically
http://msdn.microsoft.com/en-us/library/7bewx260.aspx[
^]
you can also add control to this table cell.
and for list of employees you can use grid or any other control for displaying data and bind the grid or control with your database...
here is a link for binding data to grid using Sql Data Source
http://msdn.microsoft.com/en-us/library/orm-9780596529567-04-07.aspx[
^]
and while binding you can give query that display details of all that employees which are absent on the date whcih is selected.. For showing dates you have calender control
I hope you've got an idea to it.
Submit an article or tip