I'm working on a database interface that will use comboboxes and datagrids
extensively and I keep running into problems.
Doing a test with the combo box I have a query that selects about 150,000
records from a table but the binding fails. Limiting the results (select
10,000) or going to a smaller table shows that everything is working fine
but when I select the full number it gets to the statement:
Me.cmbAutocomplete.DataSource = dsJournals1.journal_titles
and stalls.
So my first question is: is there a limit on the number of items that the
combobox can handle and
if so, what is it? I looked in the documentation (help and several VB
books) and couldn't find anything.
My second question is about the controls that come with VB .Net in general:
are they robust enough for production work with complex interfaces or should
I stop trying to make them work and start shopping for a third party suite
of controls?
If third party controls are the way to go, can anyone recommend a quality
suite?
Any help is welcome,
Thanks;
David Craig.
ABC-CLIO
Graham Dobson - 03 Jul 2004 05:49 GMT
To answer your first question. A note on page 7 of Nick Symmonds fine book
_Data Entry and Validation with C# and VB.NET Windows Forms_ (APress 2003)
states:
" Be careful about how many items you have in your ComboBox. The .NET help
file states that the maximum is 100..."
I don't know if that's true as I'm only using ComboBox's for small lookup
lists and 100 doesn't seem to be very many to me.
Working with Windows Forms for Database front ends does seem a little rough
around the edges (and somewhat incomplete at this stage) but the exciting
and interesting thing in all this is that the architecture is extremely
extensible and there always seems to be a workaround possible for even the
thorniest problems. You are definitely not limited to the functionality
implemented out-of-the-box by Microsoft. And In my view this is much more
exciting and powerful than VB ever was. -- Graham.
> if so, what is it? I looked in the documentation (help and several VB
> books) and couldn't find anything.
[quoted text clipped - 13 lines]
> David Craig.
> ABC-CLIO