Comparing value with value in Database

Question

Hi everybody,

 

I want to compare value in database with a textfield. And if it exists then not add to the textfield. So the value can only be once in the textfield. I have it like this:

 

If (txtOpmerking.Text.Contains("CompJobFicheRemarks").ToString) Then

txtOpmerking.Text = ""

Else

txtOpmerking.Text = objComp.GetVal("CompJobFicheRemarks") & vbCrLf & txtOpmerking.Text

End If

End If

End Sub

 

THank you