firstly i want compare id in two table and if id is available then data is insert i'm using this logic-
If s = "select AR.EmplID from AtdRecord AR ,HrEmployee HR where AR.EmplID= HR.EmplID " Then
Dim sql As String = "Insert into AtdRecord(EmplID,RecDate,RecTime,OperId,OperDate)Values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','0','0')"
Try
-------
End Try
but this is not working and it always run else condition data is not exist...