Click here to Skip to main content
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 22: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
0 OriginalGriff 304
1 Sergey Alexandrovich Kryukov 255
2 Shweta N Mishra 216
3 Maciej Los 210
4 PIEBALDconsult 184
0 OriginalGriff 7,660
1 Sergey Alexandrovich Kryukov 7,072
2 DamithSL 5,586
3 Manas Bhardwaj 4,946
4 Maciej Los 4,665


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 10 Apr 2012
Copyright © CodeProject, 1999-2014
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