how to search a entry from database using input box and combobox.

[vijay4781]

how to search a entry from database using input box and combobox. when we enter a name starting with 'A' in inputbox in under it a combobox displays all the names starting with 'A' . what is the code ...

[bule]

Here is a query:

"SELECT id,name FROM users WHERE name LIKE '"..Input.GetText("Input1").."%'; LIMIT 600"

Polulate the results to the combobox.

[RizlaUK]

yeah, it took me a while to understand how to search a database but its actually very easy

where blue points out, the key word is "LIKE"

[vijay4781]

plz post a project with this code ..please...

[bule]

You can not learn anything if you do it like that. Try making it yourself and then, if stuck, post the code that you can not make to work. Which part of the problem you do not understand? I'm sure you can place Input and ComboBox on the pane. You need to put the code on the Input's OnKey event. Also, you need to firstly open or connect to the database.