Member Avatar for cardin94

Hi, I'm using a MDB database that i would like to filter based on selections made in 2 comboboxes.

say: cmbBase and cmbMix.
cmbBase connects to "Base"
cmbMix connects to "Mix"
I have use the automated database method in C#
Click Here

 private void BaseMixBindingNavigatorSaveItem_Click(object sender, EventArgs e)
        {
            this.Validate();
            this.BaseMixBindingSource.EndEdit();
            this.tableAdapterManager.UpdateAll(this.DSBaseMixDataSet);

        }

        private void frmImport_Load(object sender, EventArgs e)
        {
//filter out doubles

                    cmbBase.DataSource = DSBaseMixDataSet.BaseMix.Select(x => x.Base).Distinct().ToList();


        }

The problem is that i have no idea how i can filter the other combobox in such a way that it only shows the data in the next row of the selcted combobox.

So if i select "A" in cmbBase, cmbMix should only show the values "A+1; A+3; A+6" if there were only a few values i could use an if function, but this is a database with a lot of numbers. I tried many of the solutions i found, but none of them work as i expected. Anyone that can help me out here?

ID	Base	Mix
1	A	A+1
2	A	A+3
3	A	A+6
4	B 	B+A+1
5	B 	B+4
6	B	B+9
7	B	B+12
8	C	C1
9	C	C4
10	C	C6
11	D	D7
12	D	D+B+1
13	D	D+B+2
14	D	D12
  • 1 Contributor
  • 1 Reply
  • 53 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by cardin94
Member Avatar for cardin94

I tried the following code with no luck.

  private void cmbBase_SelectedIndexChanged(object sender, EventArgs e)
        {

            DSBaseMixDataSet.BaseMix.DefaultView.RowFilter = "Mix<> '" + cmbBase.Text + "'";
          cmbMix.DataSource = DSBaseMixDataSet.BaseMix;
          cmbMix.ValueMember = "Mix";
            cmbMix.DisplayMember = "Mix";
            cmbMix.SelectedIndex = -1;
           cmbMix.SelectedIndexChanged += cmbBase_SelectedIndexChanged;

        }
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.