I have a requirement where i have to filter search based on the input. I have a textbox where the user enters a value[search]. I have a stored procedure that will take 1 parameter as input [from textbox] and display the result. I want the same textbox to populate the values based on the entered search like dropdown.
The stored procedure is used only to display top 10 results as the number of records is pretty much high in the table.
1. is there a way to accomplish match and fill in the same textbox?
2. Is there a way to filter and display top 10 records as suggestions after search. I tried and couldn't find out a solution.
can anyone Help me to solve this ?