从Combobox获取数据并使用它以将数据获取Onother Combobox

Question

我的应用中有两个组合。其中一个cmb1与一个称为分支的表结合，另一个是cmb2，与另一个名为teachers的表绑定。它们之间的关系与称为subjectteachers的表中的许多相对于许多。我需要知道如何获取选定的cmb1的ID并在表subjectteachers中搜索该ID，然后从表teachers获取名称将其放入cmb2

中

CollegeContext cd = new CollegeContext();
        Branch SectionCB = CBTypeOfSection.SelectedItem as Branch;
        var query = from b in cd.Branches
                    where (from st in cd.SubjectTeachers
                           where (st.IdBranch == SectionCB.Id &&
                          (from t in cd.Teachers
                           where
                           (t.Id == st.IdTeacher)
                           select t.Name) select st))
                           select b;
        TeachersComboBox.ItemsSource = query.ToList();

Answer 1

这称为lambda，它确实有帮助您喜欢它。

   var query = cd.Subjectteachers.Where(x=>x.IdBranch==SectionCB.Id).Select(x=>x.Teacher);
    TeachersComboBox.DisplayMemberPath = "idwork";