DatagridviewComboboxColumn

1 Feb 2006 3:39 PM

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 !

1 Feb 2006 3:43 PM

philip

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

2 Feb 2006 1:05 AM

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.

Show quoteHide quote

"philip" <p***@philippe.com> wrote in message
news:43e0d653$0$20159$8fcfb975@news.wanadoo.fr...
>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 !
>
>

3 Feb 2006 9:50 AM

philip

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

Philipe

"CMM" <cmm@nospam.com> a écrit dans le message de news:

evsR8S5JGHA.***@TK2MSFTNGP11.phx.gbl...
Show quoteHide quote

> 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" <p***@philippe.com> wrote in message
> news:43e0d653$0$20159$8fcfb975@news.wanadoo.fr...
>>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 !
>>
>>
>
>