Searching a database in a random order

[mhmm]

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:

 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