I have two tables Employee Details and EmpAttendance.
Employee Details has EmployeeID ,EmployeeNAME, EMailID columns.
EmpAttendance has c_Date , Eid, Intime, Outtime,Count columns.
i have a form in windows app, when we type employeeID and press Submit Button, I need to display
S.NO c_Date EmployeeID EmployeeNAME EMailID Intime Outime Count TotalWorkingHours
where TotalWorkingHours is the difference between outtime and intime.
suggest me how to do this.