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();
}
