private void ListBox2_SelectionChanged(object sender, SelectionChangedEventArgs e) { order = (Order)ListBox2.SelectedItem; using (var db = new NorthwindEntities2()) { ODList = db.Order_Details.Where(od => od.OrderID == order.OrderID).ToList(); ListBox3.DisplayMemberPath = "ProductID"; ListBox3.ItemsSource = ODList; } }
private void Products_Click(object sender, RoutedEventArgs e) { CustomersButton = false; EmployeeButton = false; ProductButton = true; SupplierButton = false; ListBox1.ItemsSource = null; ListBox2.ItemsSource = null; ListBox3.ItemsSource = null; using (var db = new NorthwindEntities2()) { ProductList = db.Products.ToList(); ListBox1.DisplayMemberPath = "ProductName"; ListBox1.ItemsSource = ProductList; } }
private void ListBox1_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (CustomersButton == true) { customer = (Customer)ListBox1.SelectedItem; using (var db = new NorthwindEntities2()) { OrderList = db.Orders.Where(o => o.CustomerID == customer.CustomerID).ToList(); ListBox2.DisplayMemberPath = "OrderID"; ListBox2.ItemsSource = OrderList; } } else { ListBox2.ItemsSource = null; } }