Implementing Search as we type on a Textbox in .Net (For Address search)

I am using .Net and want to implement a textbox that searches addresses and displays suggestions on a textbox.

The  user should be able to select a relevant address from the suggestions displayed and then use this address for some query further.

We have a table called "ADDRESSES" in the back end on SQL Server (We have 2008-R2 and 2016 available for use)
I think there can be caching or database based method..........

What is the best way to do this?
ArikkanAsked:
Who is Participating?
 
Ramkisan JagtapConnect With a Mentor Lead DeveloperCommented:
1
 
ArikkanAuthor Commented:
Thanks Ram. I found the documentation for the extender at this site as well:
http://www.ajaxcontroltoolkit.com/AutoComplete/AutoComplete.aspx
0
 
ArikkanAuthor Commented:
Is there any other way to implement this ?
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Ramkisan JagtapConnect With a Mentor Lead DeveloperCommented:
Hello SHANCHAT972,

Other way could be using JQuery  and a webservice to get the values from the database.
Please refer the following URL:
http://www.aspsnippets.com/Articles/Populate-jQuery-AutoComplete-TextBox-from-Database-using-Web-Service-in-ASPNet.aspx
1
 
ArikkanAuthor Commented:
0
 
ArikkanAuthor Commented:
This is a good resource to return and select the ID of the selected information in the Textbox.

http://stackoverflow.com/questions/17349875/ajax-autocomplete-extender-and-get-id-of-selected-item
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.