Creating Batch Attendance

Hi,

I need to develop a batch attendance page.

For that, I am planning to create a table in my Sqlserver db which contains columns with client names, status (which states whether the client is present or absent).

I need to display all the ClientNames in X-axis on the top, and weekdays (say, monday, tuesday, and so on) on y-axis on the left. The status should be displayed as present or absent in the respective client column for respective client.

I don't know which control to use for this kind of scenario (which i didn't do anytime).

Can anyone suggest how to get my task done?

Re: Creating Batch Attendance

Hi,

In my opinion the best format to display attendence would be:

Client Name | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Abc         | Yes | No  | No  | Yes | Yes | No  | Yes
Xyz         | Yes | Yes | Yes | No  | Yes | No  | No

In this case, you can use any control Like GridView. I am sure you would be saving week days in your table also.

Alternatively, if you want to use your format, you can use <asp:Table> control incapsulated with Label control. Then you can bind Label controls to db table's columns