CODEWITHSUNDEEP
c#winformscombobox
DPM
DPM

Reputation: 67

Searching letter or word in combo box

In my combo box theses following items are there

Edward
Isaac Maria
tony Samuel
Vikram Singh
Natasha raghav
krishh
Rahul Krishna

When I enter kr combo will list all matching words that contains 'kr' in any position i.e., combo will list vikram, krishh, rahul Krishna . In combo box Auto Complete Mode is Suggest and Auto Complete Source is Custom Source but when I enter kr in combo box it only shows the word that starts with kr. In combo box 100s of names are there.

Upvotes: 1

Views: 1003

Answers (1)

Nilupul Heshan
Nilupul Heshan

Reputation: 728

In your sql command you have to input code as followsselect custname,dob from Customer where custname like '%kr%'; you have to remember that to add "%" in the both side of the Text **what you have want to search

Upvotes: 1

Related Questions