ComboBox有50,000个？ [英] 50,000 in ComboBox?

问题描述

大家好，


是否有可能在ComboBox中列出大量商品并快速上手？

喜欢50,000件商品？我的客户在访问之前和使用MS Access时，他可以使用来自datagrid的comboBox（数据表视图中的
）来选择项目。 Access with Autocomplete的速度很快。

现在在我们的新项目中，

他仍然希望我们能够在vb.net中实现它。我们尝试了很多方法，但

速度仍然令人失望。


任何人都知道怎么做？任何建议都非常受欢迎。

Thanx，

Hao

Hi, all,

Is it possible to list a huge number of items in ComboBox and make it quick?
Like 50,000 items? My customer use MS Access before and in Access, he can
use ComboBox from datagrid(datasheet view
in Access) to select item. The speed is good in Access with Autocomplete.
Now in our new project,
he still wish we can make it possible in vb.net. We tried a lot of ways but
the speed is still disppointed.

Anyone know how to do it? Any suggest is very very welcome.
Thanx,
Hao

推荐答案

*"豪" < pH值****** @ hotmail.com.discuss> scripsit：

* "hao" <ph******@hotmail.com.discuss> scripsit:

是否可以在ComboBox中列出大量项目并快速完成？
类似50,000项？我的客户在访问之前和使用MS Access时，他可以使用来自datagrid的ComboBox（Access中的数据表视图）来选择项目。在自动完成访问权限方面速度很快。
现在在我们的新项目中，他仍然希望我们能够在vb.net中实现这一目标。我们尝试了很多方法，但速度仍然令人失望。

Is it possible to list a huge number of items in ComboBox and make it quick?
Like 50,000 items? My customer use MS Access before and in Access, he can
use ComboBox from datagrid(datasheet view
in Access) to select item. The speed is good in Access with Autocomplete.
Now in our new project,
he still wish we can make it possible in vb.net. We tried a lot of ways but
the speed is still disppointed.

您确定用户可以从50,000种商品中进行选择吗？


-

Herfried K. Wagner [MVP]

< http://www.mvps.org/dotnet>

Are you sure a user will be able to select from 50,000 items?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

*" hao" < pH值****** @ hotmail.com.discuss> scripsit：

* "hao" <ph******@hotmail.com.discuss> scripsit:

是否可以在ComboBox中列出大量项目并快速完成？
类似50,000项？我的客户在访问之前和使用MS Access时，他可以使用来自datagrid的ComboBox（Access中的数据表视图）来选择项目。在自动完成访问权限方面速度很快。
现在在我们的新项目中，他仍然希望我们能够在vb.net中实现这一目标。我们尝试了很多方法，但速度仍然令人失望。

Is it possible to list a huge number of items in ComboBox and make it quick?
Like 50,000 items? My customer use MS Access before and in Access, he can
use ComboBox from datagrid(datasheet view
in Access) to select item. The speed is good in Access with Autocomplete.
Now in our new project,
he still wish we can make it possible in vb.net. We tried a lot of ways but
the speed is still disppointed.

您确定用户可以从50,000种商品中进行选择吗？


-

Herfried K. Wagner [MVP]

< http://www.mvps.org/dotnet>

Are you sure a user will be able to select from 50,000 items?

--
Herfried K. Wagner [MVP]
<http://www.mvps.org/dotnet>

组合框中的50,000个项目。 - 糟糕的决定。你需要重新考虑你的

设计，这实在太多了。


（一种可能的方式）

而不是这个，为什么不将数据转换为数据集然后

创建一个视图。您可以将Cobmbo框绑定到DataView，然后

使用组合框中的textchanged事件来选择第一个字母或

秒，这将至少缩小范围您希望在组合框中找到的数据量为更实际的数字，连续击键

可以进一步缩小此范围。


HTH - 关于OHM

hao写道：

50,000 items in a combo box. - Bad descision. You need to re-think your
design, this is far too many to be of practical use.

(One possible way)
Instead of this, why dont you retreive the data into a dataset and then
create a view of this. You can bind the Cobmbo box to the DataView and then
use the textchanged event in the combo box to select the first letter or
second , that will at least narrow down the volume of data you would want to
find in the combo box to a more realistic number, successive keystrokes
could narrow this down further.

HTH - regards OHM
hao wrote:

全部，

是否可以列出大量的项目ComboBox让它快速？像50,000件物品？我的客户在访问之前和之后使用MS Access，他可以使用来自datagrid的ComboBox（Access中的数据表视图）来选择项目。使用
自动完成功能，Access的速度很快。现在，在我们的新项目中，他仍然希望我们能够在vb.net中实现这一目标。我们尝试了很多方法，但速度仍然令人失望。

任何人都知道如何做到这一点？任何建议都非常受欢迎。

Thanx，
Hao

Hi, all,

Is it possible to list a huge number of items in ComboBox and make it
quick? Like 50,000 items? My customer use MS Access before and in
Access, he can use ComboBox from datagrid(datasheet view
in Access) to select item. The speed is good in Access with
Autocomplete. Now in our new project,
he still wish we can make it possible in vb.net. We tried a lot of
ways but the speed is still disppointed.

Anyone know how to do it? Any suggest is very very welcome.
Thanx,
Hao

-

最好的问候 - OHM


O_H_M {at} BTInternet {dot} com

--
Best Regards - OHM

O_H_M{at}BTInternet{dot}com

这篇关于ComboBox有50,000个？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！