private void filter_tb_TextChanged(object sender, EventArgs e) { using (PublishingHouseEntities db = new PublishingHouseEntities()) { if (fn_radio.Checked) { var filtered = db.Books.Where(b => b.Authors.FirstName.Contains(filter_tb.Text)).ToList(); BindingSource bs = new BindingSource(); bs.DataSource = filtered.Select(b => new { b.ID_Book, b.NameBook, b.Authors.FirstName, b.Authors.LastName, b.Price }).ToList(); dataGridView1.DataSource = bs; } else if (ln_radio.Checked) { var filtered = db.Books.Where(b => b.Authors.LastName.Contains(filter_tb.Text)).ToList(); BindingSource bs = new BindingSource(); bs.DataSource = filtered.Select(b => new { b.ID_Book, b.NameBook, b.Authors.FirstName, b.Authors.LastName, b.Price }).ToList(); dataGridView1.DataSource = bs; } else if (nb_radio.Checked) { var filtered = db.Books.Where(b => b.NameBook.Contains(filter_tb.Text)).ToList(); BindingSource bs = new BindingSource(); bs.DataSource = filtered.Select(b => new { b.ID_Book, b.NameBook, b.Authors.FirstName, b.Authors.LastName, b.Price }).ToList(); dataGridView1.DataSource = bs; } } }
private void Form1_Load(object sender, EventArgs e) { using (PublishingHouseEntities db = new PublishingHouseEntities()) { BindingSource bs = new BindingSource(); bs.DataSource = db.Books.Select(b => new { b.ID_Book, b.NameBook, b.Authors.FirstName, b.Authors.LastName, b.Price }).ToList(); dataGridView1.DataSource = bs; } }
private void trackBar1_Scroll(object sender, EventArgs e) { using (PublishingHouseEntities db = new PublishingHouseEntities()) { var filtered = db.Books.Where(b => b.Price < trackBar1.Value).ToList(); BindingSource bs = new BindingSource(); bs.DataSource = filtered.Select(b => new { b.ID_Book, b.NameBook, b.Authors.FirstName, b.Authors.LastName, b.Price }).ToList(); dataGridView1.DataSource = bs; } }