http://forums.asp.net/t/1806754.aspx/1?+Results+as+you+type+search+web+page+using+SQL+ServerThu, 24 May 2012 12:43:31 -040018067544994206http://forums.asp.net/p/1806754/4994206.aspx/1?+Results+as+you+type+search+web+page+using+SQL+Server <p>What is the easiest way to create a web page that searches the data in a sql server table and displays the results as you type?&nbsp; Updating the search results live after each letter or number is entered.</p> 2012-05-23T15:31:19-04:004994223http://forums.asp.net/p/1806754/4994223.aspx/1?Re+Results+as+you+type+search+web+page+using+SQL+Server <p>searching after each charater would not be recommended because it would make the servers very busy and not be very helpful to the users as if i type A and want to search and And but server would returned complete list of A in sorted way so wait for atleast 3 characters&nbsp;</p> <p>implement caching so that DB server is not always busy and take more time to return the result</p> <p>easiet way is to use Ajax Autocomplete&nbsp;</p> 2012-05-23T15:41:45-04:004995797http://forums.asp.net/p/1806754/4995797.aspx/1?Re+Results+as+you+type+search+web+page+using+SQL+Server <p>You could look at the AutoComplete from the Ajax Toolkit.</p> 2012-05-24T12:43:31-04:00