Searchfield with autocomplete ASP.NET and Database

Posted by Fogh on Stack Overflow See other posts from Stack Overflow or by Fogh
Published on 2010-03-28T22:14:04Z Indexed on 2010/03/28 22:23 UTC
Read the original article Hit count: 310

Filed under:

ASP.NET

|

autocomplete

|

jQuery

|

search

|

database

Searchfield with autocomplete

I would like to make a searchfield with autocomplete, so when you write like 2 or 3 letters it will show a dropdownlist with results that match a column from a table in the database.

I have been reading all over the internet, and i have found out that it can be done with jQuery and AJAX Control Toolkit. But i don't know how to make it compare the search textbox and the database and show results that match?

© Stack Overflow or respective owner

Related posts about ASP.NET

Migrating ASP.NET MVC 1.0 applications to ASP.NET MVC 2 RTM

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Note: ASP.NET MVC 2 RTM isn’t yet released! But this tool will help you get your ASP.NET MVC 1.0 applications ready for when it is! I have updated the MVC App Converter to convert projects from ASP.NET MVC 1.0 to ASP.NET MVC 2 RTM. This should be last the last major change to the MVC App Converter… >>> More
April 14th Links: ASP.NET, ASP.NET MVC, ASP.NET Web API and Visual Studio

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Here is the latest in my link-listing blog series: ASP.NET Easily overlooked features in VS 11 Express for Web: Good post by Scott Hanselman that highlights a bunch of easily overlooked improvements that are coming to VS 11 (and specifically the free express editions) for web development: unit… >>> More
Use ASP.NET 4 Browser Definitions with ASP.NET 3.5

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
We updated the browser definitions files included with ASP.NET 4 to include information on recent browsers and devices such as Google Chrome and the iPhone. You can use these browser definition files with earlier versions of ASP.NET such as ASP.NET 3 Read More......(read more) >>> More
ASP.NET webforms + ASP.NET Ajax versus ASP.NET MVC and Ajax framework freedom

as seen on Stack Overflow - Search for 'Stack Overflow'
If given the choice, which path would you take? ASP.NET Webforms + ASP.NET AJAX or ASP.NET MVC + JavaScript Framework of your Choice Are there any limitations that ASP.NET Webforms / ASP.NET AJAX has vis-a-vis MVC? >>> More
ASP.NET MVC 2 Released

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I’m happy to announce that the final release of ASP.NET MVC 2 is now available for VS 2008/Visual Web Developer 2008 Express with ASP.NET 3.5. You can download and install it from the following locations: Download ASP.NET MVC 2 using the Microsoft Web Platform Installer Download… >>> More

Related posts about autocomplete

jQuery autocomplete disabled makes autocomplete partially transparent, not disabled

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using the jQuery UI's "autocomplete" function on a search on my site. When you change a radio button from 'area search" to "name search" I want it to disable the autocomplete, and re-enable it when you switch back. However, when you disable the autocomplete it doesn't hide the dropdown, it just… >>> More
jquery Autocomplete : autocomplete does not stop if string does not match

as seen on Stack Overflow - Search for 'Stack Overflow'
I used the auto-complete function in jquery. It's data source are the results from a php-back-end. $("#ice_id").autocomplete("ice-ver.php", { extraParams : { flavour_id: $("#flavour_id").val() } }); Let us take following example: We type in the flavour ID 3992 ...(and 3992 exists in the database… >>> More
autocomplete on dynamic textbox using jquey+autocomplete plugin

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I am using a form which has dynamic textboxes I want autocomplete functionality to be implemented on them and I am using Autocomplete Plugin and I want to bind them using live(). Can anyone help me out on how to implement it. Thanks in advance. >>> More
Jsf RichFaces autocomplete : get the String for autocomplete- method()

as seen on Stack Overflow - Search for 'Stack Overflow'
Part of my xhmtl-Page: <rich:autocomplete autocompleteMethod="#{autocompletMit.searchbyName()}" mode="cachedAjax" fetchValue="#{controller.mitarbeiter.mitarbeiterName}" autocompleteList="#{autocompletMit.autocompleteList}" minChars="1" autofill="true" var="it" >… >>> More
Is there more than one jQuery Autocomplete widget?

as seen on Stack Overflow - Search for 'Stack Overflow'
I thought there was only one - included in jQuery UI and documented here. I know there are third-party autocomplete widgets that plug-in to jQuery, like the one from devbridge. But I would describe that as an autocomplete widget for jQuery, rather than the jQuery autocomplete widget. But on… >>> More