Comments by Member 13810830 (Top 7 by date)

Where this codes will go? if TimeIn > 3 Then
GetTimeout
Else if TimeIn < 3 Then
Messagebox.Show("UNABLE TO TIME OUT")

I tried using this code
Dim getQuery As String = "SELECT dtr.time_out, dtr.date FROM dtr WHERE dtr.employee_id = @Id AND dtr.rfid = @rfid AND dtr.date = @date;"
Using cmd As New MySqlCommand(getQuery, MySQLConnection)
cmd.Parameters.Add("@Id", MySqlDbType.Int32).Value = empid.Text
cmd.Parameters.Add("@rfid", MySqlDbType.Int32).Value = RFID.Text
cmd.Parameters.Add("@date", MySqlDbType.VarChar).Value = Date.Now.ToString("yyyy-MM-dd")
Using dr As MySqlDataReader = cmd.ExecuteReader
If dr.Read Then
TimeOUT = dr.Item("time_out").ToString
getDate = dr.Item("date")
getTimeOUT()
End If
End Using
End Using

But i still don't know what i will do next and how will i do it

Can you give me an example of it? That is pretty close to fix my problem?

in my database timein = time and timeout = time

I've been trying to fix this for days.. and i still can't get it right ..
i get confused a lot ..

Sorry i'm just new i don't know what is good code or bad code as long it works it's good for me