Hi! please help me.....
i just want to know what is the code for time record using ADODB connection. im so tired to get the right code for time attendance please help me... this is for my thesis....
Here's the command:
txtEmpID --- textbox
cmdGetdata --- command Button
lbltime --- label
lbldate --- label
here's the Database name "payroll" and the table is "tblDTR"
Fields in "tblDTR": 'EmployeeID', 'TimeIn','TimeOut','Dates'
for example, I input the employeeCode int txtEmpID then after that i click the cmdGetData..
so if i click the cmdGetdata the data in EmpID, lbltime and lbldate is move to tblDTR
so that is for the TimeIn...
then after to TimeIn the TimeOut is null so if i input the same EmployeeID in txtEmpID
the data in lbltime is move to TimeOut in the same row....
so after to complete the row, another Input again and another row.. that's all...
I hope all professional programmer's wants to help me...