I am trying to populate a list box control for an application that has two tables with a many-to-many relationship (authors and titles). The idea is to select an author from a list and show all titles for that author. In addition to the author and titles tables, there is a join table that has the primary key for author as well as primary key for titles. Any ideas on how to make this happen through the controls
Joining Tables in database controls
Hot Topic
VS Express Editions
- VB.NET express really different from VB.net 2003
- Visual C# Keeps asking for Registration
- MFC in Visual C++ Beta 2?
- connect to sql express
- Apps for Pocket PC 2003
- Registration Benefits
- Updating multiple tables using DetailsView
- HOW TO capture a previously loaded form in MDI application
- microsoft.visualbasic.compatibility 8.0.0.0. ????
- Login control failing
Joining Tables in database controls
papaoso
you can use Windows Forms Databinding. If you have two datasets you can bind one control to the dataset of the authors. And the others to a Relation to the second table with the tables.
I think they are doing what you aim about:
http://msdn.microsoft.com/msdnmag/issues/02/02/cutting/