Hi,

I am doing Attendance Management application using vb.net and sql server 2005. Having fields like EmpID,EmpName,Designation,TimeIn, TimeOut and TotalHoursWorked.

Now, i need to give only EmpID and select the date(Format: mm/dd/yyyy) from DateTimePicker control,then select "Show" button.

It must show all the remaining details of an particular employee on the respective date.

For example,Date:12/15/2010(mm/dd/yyyy) and EmpID:e01,it must show Name,Desig,TimeIN,TimeOut,TotalHrs.(remaining details)-Yesterday Details

Likewise,Date:12/16/2010(mm/dd/yyyy) and EmpID:e01,it must show Name,Desig,TimeIN,TimeOut,TotalHrs.(remaining details)for the current day details.