Attendance time wise and count late C# Windows application

Mohammad Imran

I have attendance database, i want to call this database in gridview and count late(show in lablel text) if (from CLOCKIN table) time exceeded 9:30 am,also show me 1 leave if count 3 late.. so on and on.. Please help i'm new.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mohammad Imran9y ago
Another question.. I have attendance machine, i have fetched monthly attendance in xl sheet now i want to insert all excel sheet data in database existing table.

Column based like if excel sheet have Clock In column then must be insert in database Clock In in existing table.
Mohammad Imran9y ago
CREATE TABLE [dbo].[tbl_Register](
[Emp No#] [nvarchar](255) NULL,
[AC-No#] [nvarchar](255) NULL,
[Name] [nvarchar](255) NULL,
[Date] [date] NOT NULL,
[Clock In] [datetime] NULL,
[Clock Out] [datetime] NULL,
[Normal] [nvarchar](255) NULL,
[Late] [nvarchar](255) NULL,
[Early] [nvarchar](255) NULL,
[Absent] [nvarchar](255) NULL,
[OT Time] [nvarchar](255) NULL,
[Work Time] [nvarchar](255) NULL,
[Must C/In] [nvarchar](255) NULL,
[Must C/Out] [nvarchar](255) NULL,
[Department] [nvarchar](255) NULL,
[Holiday] [nvarchar](255) NULL,
[WeekEnd_OT] [nvarchar](255) NULL
) ON [PRIMARY]

GO
Shakti Singh Dulawat9y ago
Please send SQL scripts of your tables with data
Mohammad Imran9y ago
Shakti Singh Dulawat How?? Please help me? im new
Shakti Singh Dulawat9y ago
Are you able to Join attendance and CLOCKIN table? if yes than please do and create a view for it.
Once you have view you will able to able to use both tables in the grid.
For time exceeded 9:30 am,also show me 1 leave if count 3 late
You need to create a functions in SQL and for each row you can call that functions.