private void button1_Click(object sender, EventArgs e) { AdventureWorks2017Context context = new AdventureWorks2017Context(); dataGridView1.AutoGenerateColumns = true; List <Product> resultList = context.Product.Where(n => n.ListPrice > 5).ToList(); bindingSource1.DataSource = resultList; dataGridView1.DataSource = bindingSource1; }
private void dataGridView1_SelectionChanged(object sender, EventArgs e) { if (bindingSource1.Current != null) { Product selektiertesProduct = (Product)bindingSource1.Current; AdventureWorks2017Context context = new AdventureWorks2017Context(); List <BillOfMaterials> billOfMaterialsList = context.BillOfMaterials.Where(n => n.Product.ProductID == selektiertesProduct.ProductID).ToList(); if (billOfMaterialsList.Count > 0) { bindingSource2.DataSource = billOfMaterialsList; dataGridView2.DataSource = bindingSource2; } else { dataGridView2.DataSource = null; } } }