I am having trouble getting a correct response when searching through each of my datarows. While stepping through during debugging, I am seeing the boolean response is getting triggered even if one row does not match my selected string. I just want to search all of the rows and if at least one row matches(a single textbox in that row), everything will be fine and the error in dgv will not be populated. Am I missing something simple here?
Party as Boolean = False
For each eventrow as Datarow in PFC_Xpress.Tables("Event Info").rows
If Incident_Type.text = "Party" Then
For Each personrow as datarow in PFC_Xpress.Tables("Person").rows
If Event_Assoc1.text <> "Guest" then
Party = True