I have a ASP.NET page that need to show a dropdown list for user to select. The table for the dropdown list is about 250,000+ rows. It is too big to load, I tried some type ahead method but the performance is not great either and it is hit-and-miss on
the returned results. Any suggestions? Currently, I have this column as free text and return with hits and suggestions. User really want the dropdown so they can pick and choose. I am open for any solutions.
Thanks,
Go to the complete details ...