DatagridviewComboboxColumn

[philip]

I have a datagridview with some columns.
One of them has been declared as a DatagridviewComboboxColumn

The datasource of this column is a table of an Access Database. There is
13000 lines in this table, but only 3 fields.

In runtime, when I click on this column, the combobox is very long to open,
and each time I click on the combo box on another row, I must wait for a too
long time to see list..

Is it possible to avoid that ?

The datasource seems to fill itself each time I click on the combo box of a
different row.

I use to program in Access, and it is difficult to accept a such waiting
time ! In Access the same thing is instantaneous !

 

[philip]

I have forgotten to say 'thank you' by advance to this one who answers me !

 

[CMM]

Keep in mind that Access implements "virtual" lists to speed things up. That
list box in Access does NOT load up 13,000 items... it loads a few and then
fetches "out-of-view" items as you scroll through the list. You may be able
to contruct your own "virtual" combobox cleverly (I think the control
exposes all the events you would need)... or you can see if someone has
already done it for you- do a search on Google or Codeproject or something
like that.
Maybe you can adapt this code for a listbox
(http://www.vbaccelerator.com/home/net/Code/Controls/ListBox_and_ComboBox/VListBox/article.asp)

The DataGridView itself I think has a "virtual" mode I think... I don't know
how that applies to the combo. Sounds like an interesting problem.

 

[philip]

Thank you very sincerely for your response.
I try to study virtual mode features.

Philipe