?
Solved

VB.Net: Populating comboboxes from data source

Posted on 2013-01-08
5
Medium Priority
?
234 Views
Last Modified: 2013-04-16
I have a couple of instances where I have a comboboxes menu in VB.Net, and I've bound it to a Binding source, which, in turn, is bound to an ".xsd" file, which defines a SQL-Server-based dataset.

I have two adjacent comboboxes, both with virtually the same arrangement of data bindings, and one populates, the other does not.  From the dataset designer, both queries work perfectly, giving me the results I expect.  As an experiment, I unchecked the box on both comboboxes that says "Use Databound items" and then re-established the datasets on both.  As before, the first resumed working and other resumed providing me with an empty list.  

I thought it time to get some advice on this.  Dropdowns have been a headache for me for a while.  Thanks, ~Peter Ferber
0
Comment
Question by:PeterFrb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 38759442
Are both bound to same dataset and binding source or separate?
0
 
LVL 20

Expert Comment

by:ElrondCT
ID: 38767756
If you stop the application with the debugger, does the dataset for the empty combobox have data, or is it empty?
0
 
LVL 9

Expert Comment

by:sognoct
ID: 38768032
without your code is impossible to give some help, can you attach here the form source ?
0
 

Accepted Solution

by:
PeterFrb earned 0 total points
ID: 38772762
Thanks for your comments.  I was able to solve the problem myself, on my office computer.  I don't have that in front of me at the moment, but I can describe what I did to solve the problem.  When I get back to the office, I can post some code.

The problem had to do with using the combobox itself as a data source instead of the data file.  Also the form needs a "Fill" statement to feed the control from the data source.  Those pieces were in place for one control, but not the other.  When I got through this, my dropdowns worked perfectly.

~Peter
0
 

Author Closing Comment

by:PeterFrb
ID: 39083417
I ended up solving the problem myself.  Thanks for the help, though.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question