A
Andrus
I'm creating a database Winforms application using VCS Express 2005
I have some large lookup tables (may be up to 500000 records) which
contains name and id and are stored in sql server.
I need to create single line combobox style control which:
1. Allows to type first characters in name
2. Auto-completes entered data by using first match
3. Allows to open picklist based by entered data and select name
I tried to use Combobox with lookup table.
I can set combobox autocomplete source to lookup table and autocomplete
window shows matches very well.
Lookup parts table is big, it takes a lot of time to load the
data source.
I think I need virtual combobox control with autocomplete and selection from
list.
Is is not reasonable to load whole table as combobox lookup table during
combobox
creation like ms doc sample recommends.
I have found 2 possibilities:
1. Add some code to combobox events to implement virtual mode. Is this
possible ?
2. Create textbox, selection button and use (virtual?) DataGridView to
emulate virtual dropdown list. In this case I must create UI in code
also.
Which way is better ?
Where to find more information about this ?
Andrus.
I have some large lookup tables (may be up to 500000 records) which
contains name and id and are stored in sql server.
I need to create single line combobox style control which:
1. Allows to type first characters in name
2. Auto-completes entered data by using first match
3. Allows to open picklist based by entered data and select name
I tried to use Combobox with lookup table.
I can set combobox autocomplete source to lookup table and autocomplete
window shows matches very well.
Lookup parts table is big, it takes a lot of time to load the
data source.
I think I need virtual combobox control with autocomplete and selection from
list.
Is is not reasonable to load whole table as combobox lookup table during
combobox
creation like ms doc sample recommends.
I have found 2 possibilities:
1. Add some code to combobox events to implement virtual mode. Is this
possible ?
2. Create textbox, selection button and use (virtual?) DataGridView to
emulate virtual dropdown list. In this case I must create UI in code
also.
Which way is better ?
Where to find more information about this ?
Andrus.