[RESOLVED] Combo box binding to different table

[gmcconville]

Hey, I have searched for ages on this but cannot get it working.

I have two tables, one called Fields and another called Sections.

There is a relationship between the two table for a field called section.

I have a binding navigator on the form that is used to cycle through the different records in Fields.

I have a bunch of text boxes that properly display the information of the Fields correctly

I also have a combo box that I cannot get working, I need it to display the items on from the Sections table.

I am trying to code everything, so no wizards used.

This is what I have been trying so far

            BSource = new BindingSource();
            BSource.DataSource = DbDataSet.Tables["Fields"];
            Navigator.BindingSource = BSource;
 
            BSource2 = new BindingSource();
            BSource2.DataSource = DbDataSet.Tables["Sections"];

            // CbSections is the combobox
            CbSections.DataSource = BSource2;
            CbSections.DataBindings.Add("Text", BSource, "Section");
            CbSections.DisplayMember = "Sections.Section";

Also. Can sombody please recommend a good ADO.NET book.

I am looking at buying Sams Teach Youself ADO.NET in 21 days, however it is expensive and I don't want to get it only to find it is not any good.

Thanks for all help.

[gmcconville]

WOOOHOOOO!!!!!!

After two weeks of researching this I figured it out.

I use one binding source for all controls, and I needed to add a value member

            BSource = new BindingSource();
            BSource.DataSource = DbDataSet.Tables["Fields"];
            Navigator.BindingSource = BSource;
            TbProductType.DataBindings.Add("Text", BSource, "ProductType");

            CbSections.DataSource = DbDataSet;
            CbSections.DisplayMember = "Sections.Section";
            CbSections.ValueMember = "Sections.key";
            CbSections.DataBindings.Add("SelectedValue", BSource, "Section");

            TbField01.DataBindings.Add("Text", BSource, "Field01");