Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Windows Forms / WinForm Data Binding / July 2004

Tip: Looking for answers? Try searching our database.

Limitation to combobox items

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DCraig - 21 Jun 2004 18:52 GMT
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

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.