private void ExecuteButton_Click(object sender, EventArgs e) { using (var context = new NorthWindAccessContext()) { var customerData = (from customer in context.Customers join country in context.Countries on customer.CountryIdentifier equals country.CountryIdentifier select new CustomerEntity { CustomerIdentifier = customer.CustomerIdentifier, CustomerName = customer.CompanyName, CountryIdentifier = customer.CountryIdentifier, Country = country.Name }).ToList(); var countryId = ((Countries)CountryComboBox.SelectedItem).CountryIdentifier; if (countryId > -1) { customerData = customerData.Where(customer => customer.CountryIdentifier == countryId).ToList(); } if (!string.IsNullOrWhiteSpace(CustomerNameStartsWithTextBox.Text)) { customerData = customerData.Where(customer => EF.Functions.Like(customer.CustomerName, "La%")).ToList(); } _customersView = new BindingListView <CustomerEntity>(customerData); _customersBindingSource.DataSource = _customersView; dataGridView1.DataSource = _customersBindingSource; } }
private void Form1_Shown(object sender, EventArgs e) { dataGridView1.AutoGenerateColumns = false; using (var context = new NorthWindAccessContext()) { var countries = context.Countries.ToList(); countries.Insert(0, new Countries() { Name = "Select", CountryIdentifier = -1 }); CountryComboBox.DataSource = countries; var customerData = (from customer in context.Customers join country in context.Countries on customer.CountryIdentifier equals country.CountryIdentifier select new CustomerEntity { CustomerIdentifier = customer.CustomerIdentifier, CustomerName = customer.CompanyName, CountryIdentifier = customer.CountryIdentifier, Country = country.Name }).ToList(); _customersView = new BindingListView <CustomerEntity>(customerData); _customersBindingSource.DataSource = _customersView; dataGridView1.DataSource = _customersBindingSource; } }