Click here to Skip to main content
11,630,144 members (77,573 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: ASP.NET MySQL VB.NET
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 7-Apr-12 21:08pm
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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/[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

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
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

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[^]
  Permalink  
Comments
Geofferz at 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 at 16-Apr-12 6:13am
   
please provide me your email id
Geofferz at 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)

  Print Answers RSS


Advertise | Privacy | Mobile
Web04 | 2.8.150723.1 | Last Updated 10 Apr 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100