Last post Apr 11, 2011 08:51 AM by jiten.negi
Jun 27, 2007 02:50 AM|ravindran.vasudevan|LINK
Am trying to use the autocomplete extender to suggest the users when they type data.Basically the data gets fetched from database through a web service.
This is my autocompleteextender properties
and this is my web method
Now i have specified my CompletionSetCount to be 10 but still when the results are getting displayed its very much more than 10.The number of records in my table is huge and i just want to restrict the number of entries getting displayed in the UI.Kinldy
let me know how to do this.
Also can anyone tell me how to improve performance with this.Since the data is huge when i start typing it takes little time to get me the results.I basically use a stored procedure to get the results.
Jun 27, 2007 03:18 PM|kirtid|LINK
The CompletionSetCount is a parameter passed the webservice method or pagemethod and it needs to respect that. You should trim your number of results to be equal to count and then return them.
Jun 28, 2007 01:05 AM|ravindran.vasudevan|LINK
Kindly can you let me know how to trim my results to that count.The web method does not seem to respect the count value and i need to resolve this.
Jun 28, 2007 01:44 AM|kirtid|LINK
You need to change it to return the number of results equal to count.
Aug 30, 2008 11:40 AM|YairNevet|LINK
Your sql query should look like this example(notice to the TOP clause):
Apr 11, 2011 03:01 AM|jiten.negi|LINK
I am facing the same problem, i have used CompletionSetCount = "10" but its showing all values in textbox and therefore its taking too much time... how to resolve that issue, plz help me and let me know...
Apr 11, 2011 08:51 AM|jiten.negi|LINK
i got my output.. thank you so much, your code gave my direction...
Thanks for all who replied in my questions..