Database Tablecreate table Attendance
(
SLNo int IDENTITY(1,1),
EmployeeID varchar(20),
AttendanceDate date,
OfficeStartTime time,
OfficeEndTime time,
EmployeeLoginTime time,
EmployeeLogoutTime time,
WorkingHour int,
Comments varchar(10)
primary key(EmployeeID, AttendanceDate)
)
at.EmployeeLoginTime = TimeSpan.Parse(DateTime.Now.ToString("hh:mm:ss"));
In database time will store like 14:20:19
(
SLNo int IDENTITY(1,1),
EmployeeID varchar(20),
AttendanceDate date,
OfficeStartTime time,
OfficeEndTime time,
EmployeeLoginTime time,
EmployeeLogoutTime time,
WorkingHour int,
Comments varchar(10)
primary key(EmployeeID, AttendanceDate)
)
at.EmployeeLoginTime = TimeSpan.Parse(DateTime.Now.ToString("hh:mm:ss"));
In database time will store like 14:20:19