Show Monthly attendance in ASP.Net

[arti]

Pl tell me how to show monthly attendance using ASP.Net. Weekly offs in different colour & holidays in different colour.

[kenobewan]

What method are you using to record visits?

[arti]

What method are you using to record visits?

I am getting data from a swiping machine & populating a datatable 'tblDailyAttendance' in Sqlserver which has following columns- Date, Cardid, TimeIn, TimeOut. From this I will populate a monthlyattendanceTable which will have columns cardid1 column for each day i.e. 31 days. If duration of employee in office (TimeOut -TimeIn) was more than 6 hrs put 'P' for that day else 'H' . Tables will be filled by a windows service or aindows application run by task schedular. I want to show data from MonthlyAttendance table in a webform in ASP.net. Extra days like 30 Feb should not appear etc. How to do it?

[kenobewan]

Sounds like you need to bind the datatable to a control, like a datagrid.

[arti]

Sounds like you need to bind the datatable to a control, like a datagrid.

Thanx. But how to hide or not show the columns ( 30 Feb, 31April etc) if they have dbnull values in all rows?

[jayvaishnav82]

I am getting data from a swiping machine & populating a datatable 'tblDailyAttendance' in Sqlserver which has following columns- Date, Cardid, TimeIn, TimeOut. From this I will populate a monthlyattendanceTable which will have columns cardid1 column for each day i.e. 31 days. If duration of employee in office (TimeOut -TimeIn) was more than 6 hrs put 'P' for that day else 'H' . Tables will be filled by a windows service or aindows application run by task schedular. I want to show data from MonthlyAttendance table in a webform in ASP.net. Extra days like 30 Feb should not appear etc. How to do it?

if you got solution of that problem than please give me solution of that problem because i am also facing that problem.

Thanks

Jayant