private void Form1_Load(object sender, EventArgs e) { dataGridView1.ColumnCount = 4; dataGridView1.Columns[0].Name = "Department ID"; dataGridView1.Columns[1].Name = "Name"; dataGridView1.Columns[2].Name = "Group Name"; dataGridView1.Columns[3].Name = "Modified Date"; Object[] rows = new Object[4]; dataGridView1.Update(); dataGridView1.Refresh(); dataGridView1.Rows.Clear(); using (var context = new AdventureWorks2017Entities()) { var queryDepartment = (from x in context.Departments orderby x.DepartmentID select x); foreach (var item in queryDepartment) { rows[0] = item.DepartmentID; rows[1] = item.Name; rows[2] = item.GroupName; rows[3] = item.ModifiedDate; dataGridView1.Rows.Add(rows); } } }
private void edit_Load(object sender, EventArgs e) { using (var context = new AdventureWorks2017Entities()) { var queryInfo = (from x in context.Departments where x.DepartmentID == dID select x).First(); departmentID.Text = dID.ToString(); nameBox.Text = queryInfo.Name; grpNameBox.Text = queryInfo.GroupName; } }
private void Delete_Click(object sender, EventArgs e) { using (var context = new AdventureWorks2017Entities()) { var rowDelete = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value); var deleting = (from x in context.Departments where x.DepartmentID == rowDelete select x).FirstOrDefault(); context.Departments.Remove(deleting); context.SaveChanges(); Form1_Load(null, null); } }
private void updateBtn_Click(object sender, EventArgs e) { using (var context = new AdventureWorks2017Entities()) { var update = (from x in context.Departments where x.DepartmentID == dID select x).First(); update.Name = nameBox.Text; update.GroupName = grpNameBox.Text; update.ModifiedDate = DateTime.Now; context.SaveChanges(); this.Hide(); Form1 form = new Form1(); form.ShowDialog(); this.Close(); } }
private void addBtn_Click(object sender, EventArgs e) { using (var context = new AdventureWorks2017Entities()) { context.Departments.Add(new Department() { DepartmentID = Convert.ToInt16(dID), Name = nameBox.Text, GroupName = grpNameBox.Text, ModifiedDate = DateTime.Now }); context.SaveChanges(); this.Hide(); Form1 form = new Form1(); form.ShowDialog(); this.Close(); } }
private void Add_Click(object sender, EventArgs e) { using (var context = new AdventureWorks2017Entities()) { var queryLast = (from x in context.Departments orderby x.DepartmentID descending select x.DepartmentID).FirstOrDefault(); if (dataGridView1.CurrentRow == null) { MessageBox.Show("Please select a department", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var newID = queryLast + 1; this.Hide(); (new add(newID)).ShowDialog(); this.Close(); } } }