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 'tblDailyAttend ance' in Sqlserver which has following columns- Date, Cardid, TimeIn, TimeOut. From this I will populate a monthlyattendan ceTable 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 MonthlyAttendan ce 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 'tblDailyAttend ance' in Sqlserver which has following columns- Date, Cardid, TimeIn, TimeOut. From this I will populate a monthlyattendan ceTable 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 MonthlyAttendan ce 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