[RESOLVED] [2005] Find within the string.

[LuxCoder]

I am using the following code for finding the customer name as and when i type in the Combobox.

Private Sub combobox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox2.TextChanged
        If btnact = "S" Then
            CUSTOMERBindingSource.Filter = "name like '" & ComboBox2.Text & "%'"
        End If
    End Sub

I want to look for the string anywhere within the name. For eg. i want to find 'Jack' from the names of the customers then it should give me the result matching 'Jack' in the 1st name or middle name or last name. However the names of the customer are stored as a single string only. Suppose i have three names in my database containing the word 'Jack' within the string then it should give me the following results
1. Jack Brown
2. Michael Jackson
3. Phill Jack Robinson

What changes do i have to make to my code ?

[koolprasad2003]

I am using the following code for finding the customer name as and when i type in the Combobox.

Private Sub combobox2_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox2.TextChanged
        If btnact = "S" Then
            CUSTOMERBindingSource.Filter = "name like '" & ComboBox2.Text & "%'"
        End If
    End Sub

I want to look for the string anywhere within the name. For eg. i want to find 'Jack' from the names of the customers then it should give me the result matching 'Jack' in the 1st name or middle name or last name. However the names of the customer are stored as a single string only. Suppose i have three names in my database containing the word 'Jack' within the string then it should give me the following results
1. Jack Brown
2. Michael Jackson
3. Phill Jack Robinson

What changes do i have to make to my code ?

just use
if string name.Contains("Jack/whatever") then
//add this name in arraylist
end if

thankx
Koolprasad2003

[LuxCoder]

i dint get u.... plz explain where should i use it ?

[jmcilhinney]

You've got a wildcard AFTER your string value, so that's only going to find matches that START with that value. If you want to find matches anywhere in the string then you need a wildcard BEFORE the string too.

[LuxCoder]

U mean like this:

CUSTOMERBindingSource.Filter = "name like '%" & ComboBox2.Text & "%'"

[LuxCoder]

thanks that worked !