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

albert albert · Answer

Hi Thanks for your answare. I have solved with Indexof. Greetings Savant

SUNIL GUTTA · Answer

no need of additional to string in if statement becoz textbox.text returns string only but issue may be with else statement or db error info plz ? compile or runtime with description will be appreciated Regards

albert albert · Answer

I also triied like this: If (txtOpmerking.Text.Equals((CompJobFicheRemarks).ToString)) Then txtOpmerking.Text =  Else txtOpmerking.Text = objComp.GetVal(CompJobFicheRemarks) & vbCrLf & txtOpmerking.Text End If