public void Entity_Show_AllCourses(DataGridView yourDataGridView) { context = new SchoolEntities(); context.OnsiteCourse.Load(); yourDataGridView.DataSource = context.OnsiteCourse.Local.ToBindingList(); yourDataGridView.Columns[4].Visible = false; }
public void Entity_Show_SelectedCourses(DataGridView yourDataGridView) { context = new SchoolEntities(); string cell = yourDataGridView.CurrentCell.Value.ToString(); var courses = from c in context.OnsiteCourse where c.Location == cell select c; context.OnsiteCourse.Load(); yourDataGridView.DataSource = courses.ToList(); yourDataGridView.Columns[4].Visible = false; }
private void AddToDBButton_Click(object sender, EventArgs e) { try { context = new SchoolEntities(); context.OnsiteCourse.Add(OC1); context.Course.Add(C1); context.SaveChanges(); MessageBox.Show("Курс успешно добавлен!"); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ZachetForm() { InitializeComponent(); var context = new SchoolEntities(); }