Click here to Skip to main content
14,934,216 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hi there,

I am creating an asp.net application in VB.net I have a database connected to it. The database contains a lot of information for example users, vendors etc. Currently I have a dropdown menu which is just too long to be doing through it just to find the vendor you want. Now I want to create a search box so that when I want to get a specific vendor (I already have all the vendors details on the database such as address and contacts) I want to start typing the vendors name and I want it to look in the database then start giving me matching data to what I m typing to what already exists.

For example, when you do a search on google, normally it will start giving you matches to what you typing in or something similar to what you have already searched for. I wonder if anyone knows how to do it in VB.net and MySQL that would be helpful.


Thanks in advance!
Posted

jQuery has a lot of plug-ins available for doing autocomplete searches. Just search google for jQuery autocomplete or you can use the jQuery autocomplete at http://jqueryui.com/demos/autocomplete/[^]
   
Jquery plugins available for this.

you can use $.autocomplete() to searching records.
link : http://jqueryui.com/demos/autocomplete/

AJAX autocomplete for JQUERY
link : http://www.devbridge.com/projects/autocomplete/jquery/

another way is Autocomplete Extender of AJAX.

link : http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx
   
try following this link...

make a web service for this..if you cant then contact me..I will send you the sample code


http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx[^]
   
Comments
Geofferz 16-Apr-12 6:01am
   
Hey, thanks for your help. I would really appreciate a sample code if you can please! At the moment I just have a text box and I want that to be linked to my database so when user starts typing name of a customer it searches what already exists in the database and provide what matches to what they typing. Thanks again!
AshishChaudha 16-Apr-12 6:13am
   
please provide me your email id
Geofferz 17-Apr-12 5:00am
   
my email id is geoffreymk@hotmail.com thanks

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