This is a migrated thread and some comments may be shown as answers.

Autocomplete with many items

3 Answers 23 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Slavcho
Top achievements
Rank 1
Slavcho asked on 13 Mar 2014, 02:08 PM
Hi,
I’m  just evaluating your great gridview control and plan to use it in my future project as grid with a list of products. It must have a insert product functionality, so I need to replace the editor of standard text column with dropdown or another editor with autocomplete functionality.
The problem is that the products in selection are more than 30000 and there is some problems with performance when a text is typed in the editor and the control do the autocomplete operation. Another problem is that I must reload the editor datasorce every time on EditorRequired/EditorInitialized event although actually there is no changes in the datasource.
So my two questions are:
Is there a better approach to achieve autocomplete with lot of (30-50k) items without so many lag when typing?
And
Is there a way to use a editor without loading the datasource every time when the editor is required?

Thanks in Advance!
Slavcho

3 Answers, 1 is accepted

Sort by
0
Tom
Top achievements
Rank 1
answered on 13 Mar 2014, 07:11 PM
In my opinion, autocomplete is only good when return less than 20 items, you have to limit the number of return records and let user keep typing to filter down the list.
And I think autocomplete is for web version, you are in winform forum.

Regards.
0
Tom
Top achievements
Rank 1
answered on 13 Mar 2014, 07:15 PM
sorry, I found the autocomplete in Editor section of Winform.
0
Dimitar
Telerik team
answered on 18 Mar 2014, 09:59 AM
Hello Slavcho,

Thank you for writing.

In this case there is no need to bind the column in the EditorInitialized event. In the following article you can find out how you can bind the GridViewComboBoxColumn: GridViewComboBoxColumn. 

Currently, there is no way to limit the number of items in the drop down and speed up the filtering. However you can check the solution for such cases provided in the following article and see how it fits in your case: Performance Boots with Virtual RadMultiColumnComboBox - Quick Loading and Fast Filtering using Trie

I hope this information helps. Should you have any other questions, I will be glad to assist you.
 
Regards,
Dimitar
Telerik
 

DevCraft Q1'14 is here! Watch the online conference to see how this release solves your top-5 .NET challenges. Watch on demand now.

 
Tags
GridView
Asked by
Slavcho
Top achievements
Rank 1
Answers by
Tom
Top achievements
Rank 1
Dimitar
Telerik team
Share this question
or