473,569 Members | 2,691 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Show Monthly attendance in ASP.Net

13 New Member
Pl tell me how to show monthly attendance using ASP.Net. Weekly offs in different colour & holidays in different colour.
May 14 '07 #1
5 3309
kenobewan
4,871 Recognized Expert Specialist
What method are you using to record visits?
May 14 '07 #2
arti
13 New Member
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?
May 15 '07 #3
kenobewan
4,871 Recognized Expert Specialist
Sounds like you need to bind the datatable to a control, like a datagrid.
May 15 '07 #4
arti
13 New Member
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?
May 16 '07 #5
jayvaishnav82
1 New Member
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
May 26 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

15
2277
by: Paul T. Rong | last post by:
Hi everybody, This time a very very difficult case: I have a table "tblStudent", there are 50 students, I also made a form "frmStudent" based on "tblStudent", now if I don't want to show all the students in a classical (vertically, from top to bottom) way, but make them "sitting" in 50 text boxes, 5 rows 10 columns, how to do it? ...
2
2038
by: Richard Williamson | last post by:
Hi all, I have tables set up something like: Member(MEMBER_ID, name, etc) Event(EVENT_ID, eventname, place, time) Attendance(MEMBER_ID, EVENT_ID, present) I am trying to bring up a form which shows an event with a subform with all the members names displayed, along with the check box for 'present'. However, I cannot get it to show ALL...
1
3885
by: Kevin | last post by:
Hi, I have an attendance database that tracks when employees are present during the week. I have a two tables that have the following information: EmployeeTable with Fields EmployeeID, First Name and Last Name. The Second table called Attendance has an AttendanceID, EmployeeID, Date and Attendance Type Field (Present, Sick etc.) I am...
2
2842
by: crier_67 | last post by:
Hello all, I'm relatively new to Access and could use some direction on this task. I have a group with a FoxPro 2.6 for DOS membership & attendance database with about 200 member records. The group operates on a 28 week schedule, with meetings once each week. At the end of 6 months they create a new 28 week schedule, but preserve the...
1
2556
by: Shun | last post by:
Hello, My requirement is to develop an Employee Attendance Register. For ex: I am in some X country and my office is in Y country. now my requirement is i want to check the employees present and also there previous days attendance(i.e complete Month employee Attendance). I am farwarding in 2 ways, 1. By searching in Google for any...
2
2868
by: timgeitz | last post by:
I would like to design a drop down option box on a form which gives me several choices for putting in an attendance date to record church attendance. Typically, a church secretary would record a member's attendance sometime after the date of attendance (eg. Monday or Tuesday after the Sunday's attendance). On my attendance form, I need to have an...
1
4398
by: azimid | last post by:
Hello everyone, I need your help with a query. Currently I display the data in a daily format. I have a form that the users submits the date range (from say 20061224 to 20070530) and the data is displayed daily. I like to know how I can show the data in weekly and monthly way.so that for the range shown above I would have the monthly...
18
3528
by: yashumrhsn | last post by:
can anyone help me to get userid and password from access database..then it compares the userid and password and opens a new from that shows the details from the database for that user..
5
8899
by: Lindie | last post by:
We use a spreadsheet to record attendance for pupils with special needs. They live-in so we need 365/365 attendance details. The spreadsheet is getting too cumbersome, a Db is needed. I would like to turn the spreadsheet into a database. In the spreadsheet we have every day listed and then simply enter an attendance code. for the Db I have...
0
7612
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7922
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8119
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6281
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5509
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5218
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3653
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
2111
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1209
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.