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?