Click here to Skip to main content
16,016,882 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
my actual application is a list of vehicle numbers WITHOUT duplicates from a mysql database. to speedup vehicle parking system collection process, operator may enter the last 3 or 4 digits of the vehicle number. the proposed control should display all the vehicle numbers containing the entered numbers.

Which control to be used, text box or combo for with autocomplete. I have not yet written any code for and waiting for a solution.

My requirement is :
LIST FROM MYSQL TABLE CONTAINS
1) TN07CC9841
2) TN08AD5781
3) TN22AA4687
4) DL16AC9841
5) KL16AC9916
6) KK18DD4687
7) TN20AC4684

if operator enters in the control "9841" the control should display item no.1 and 4. If "468" then item number 3, 6 and 7.

please help, i want to complete the project at the earliest

What I have tried:

Tried autocomplete text box and auto complete combo boxes
Posted
Updated 8-Sep-24 19:14pm
v4

1 solution

There's a lot of context missing from your question. Which AutoComplete box is it? What is the datasource for the data? Let's take it that you are using a SQL database at the backend, then searching inside a string is as simple as using a like statement with a wildcard lookup. Provide more context and we will be able to offer more advice.

If you show us the code you currently have here, it will make it a lot easier for us to tell you what to adjust.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900