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? Updating the search results live after each letter or number is entered.
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
implement caching so that DB server is not always busy and take more time to return the result
You could look at the AutoComplete from the Ajax Toolkit.
Superguppie.
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
When all you've got is a Hammer, Every Problem looks like a Nail. Michael Swain.
rbesman
0 Points
1 Post
"Results as you type" search web page using SQL Server
May 23, 2012 03:31 PM|LINK
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? Updating the search results live after each letter or number is entered.
Mudasir.Khan
All-Star
15346 Points
3142 Posts
Re: "Results as you type" search web page using SQL Server
May 23, 2012 03:41 PM|LINK
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
implement caching so that DB server is not always busy and take more time to return the result
easiet way is to use Ajax Autocomplete
superguppie
All-Star
48225 Points
8679 Posts
Re: "Results as you type" search web page using SQL Server
May 24, 2012 12:43 PM|LINK
You could look at the AutoComplete from the Ajax Toolkit.
Please remember to click “Mark as Answer” on the post that helps you. This can be beneficial to other community members reading the thread.
When all you've got is a Hammer, Every Problem looks like a Nail. Michael Swain.