Creating a search box using results already on database

Question

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 7-Apr-12 21:08pm

Geofferz

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

ZurdoDev · Answer 1 · 2012-04-09T04:41:00

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/[^]

Posted 9-Apr-12 4:41am

ZurdoDev

Angel1320 · Answer 2 · 2012-04-09T20:03:00

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

AshishChaudha · Answer 3 · 2012-04-09T20:12:00

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[^]

Posted 9-Apr-12 20:12pm

AshishChaudha

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