I have about 50,000 records in a dataset
I obviously can't retreive them all in a webdropdown but can I setup Autocomplete/filtering so I can bring back about 50 results at a time when the user types ahead in the dropdown? I tried setting EnableLoadOnDemand to true but it doesn't work on Autocomplete (just filters the first 50 or so records in the dataset)
Is this possible at all or does it have to be done on the database level?
Hi,
There is a property called AutoFilterResultSize, you can set it to 50, and it will only return the top 50 records when you have server-side filtering.
Hope it helps,
Angel
Even set to 50 it is really slow.
Are there any code samples available on Autocomplete with a large recordset?