Searchfield autocomplete ASP.NET and database

Question

AutoFill Search Field

I would like to create an autocomplete search field, so when you write as 2 or 3 letters, it will display a drop-down list with the results that match the column from the table in the database.

I read all over the internet and I found out that this can be done using jQuery and the AJAX Control Toolkit. But I don’t know how to do this to compare the search text box and the database and show the results that match?

UPDATE:

I tried to get it to work with Autocomplete extender from the Ajax management toolkit, but I don't know how to make Webservice with SQL.

UPDATE2

Cannot get webservice to work, so browse through the jQuery user interface, which can autocomplete but does not know how to get this working with the database ..: p

Update3

I still stick with this, so if anyone knows how to create a data source (webservice) that works with the Autocomplete or jQuery UI extension, please help me.

I want autocomplete displayed: SELECT * FROM TABEL WHERE Title LIKE + '%' @Search + '%'And its MSSQL database

Answer 1

Watching this video and watching, although the comments answered my question :)

http://www.asp.net/learn/AJAX-videos/video-122.aspx

Answer 2

-, . SO .

jQuery autocomplete - ASP.NET?

Answer 3

Asp.net Ajax.

http://www.asp.net/ajax/ajaxcontroltoolkit/Samples/AutoComplete/AutoComplete.aspx

, .

select * from tbl_Country where countryName like '%xxx%'

sql . -.

<ajaxToolkit:AutoCompleteExtender 
    runat="server" 
    ID="autoComplete1" 
    TargetControlID="myTextBox"
    ServiceMethod="GetCompletionList"
    ServicePath="AutoComplete.asmx"
</ajaxToolkit:AutoCompleteExtender>

- asmx - AutoComplete.asmx. - GetCompletionList. System.Data.SqlClient .