I'm trying to compare a existing with other string retriving from databse , Its not get into the if statement even there is a data retrive same as existing one...
Dim epf_no As String
Dim epf_no_frmdb As String
epf_no = "1022"
Adodc2.Refresh
With Adodc2.Recordset
Do Until Adodc2.Recordset.EOF
epf_no_frmdb = !EPFno
If epf_no = epf_no_frmdb Then
txtName.Text = !name
End If
.MoveNext
Loop
End With
can anyone please give better solution to compare strings..