private void button10_Click(object sender, EventArgs e) { Medicine_Data data = new Medicine_Data(); MedicineContext context = new MedicineContext(); GlobalVar gl = new GlobalVar(); if (comboBox3.Text != "") { int _med_id = Convert.ToInt32(context.Preparations.Where(c => c.med_name == comboBox3.Text).Select(c => c.med_id).FirstOrDefault()); data.Create_Medication_Record(GlobalVar.selected_reception_ID, _med_id, Convert.ToInt32(numericUpDown2.Value)); } dataGridView7.Rows.Clear(); if (context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).Count() > 0) { foreach (var r in context.Medications.Where(c => c.reception_id == GlobalVar.selected_reception_ID).ToList()) { string _med_name = context.Preparations.Where(c => c.med_id == r.med_id).Select(c => c.med_name).FirstOrDefault().ToString(); string _med_days = context.Medications.Where(c => c.med_id == r.med_id).Select(c => c.med_days).FirstOrDefault().ToString(); dataGridView7.Rows.Add(r.selected_med_id, _med_name, _med_days); } gl.SetContextMenu_Collumns(dataGridView7, id_context); } }