Hi,
I'm trying to search through a database with a GUI that I've made, and it searches just fine when I do it in a specific order like:
John Joseph Smith
However when I look for something like
John Smith
without the middle name it seems to just go blank and can't seem to do it. Is there a way to do this??
The code for search is:
Code:
Private Sub FullNameTextBox_Enter(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click
Try
Me.ContactsTableAdapter.Search(Me.Linkedcontacttbls.Contacts, FullNameTextBox.Text)
LBSearch.Update() 'LbSearch is the listbox
Catch op As System.InvalidOperationException
System.Windows.Forms.MessageBox.Show(op.Message)
Finally
End Try
End Sub
Any help would be appreciated!
Also VB version is: VB 2010