Edit and Delete Operation in Data Grid Using Context Menu, Pop Up Window

</ContextMenu>

</DataGrid.ContextM

</DataGrid>

When you right-click on the selected row in a Data Grid the context menu will appear. The following snapshot will show how the context menu will look in the Data Grid.



Edit Operation

When you click on Edit, the selected item details of the Data Grid will be added to the pop-up window.You can Edit Data then click Ok to update the data.

This is the code behind for edit click:

private void Edit_Click(object sender, RoutedEventArgs e)

{

popup.IsOpen = true; //Pop up window will open

Database DB = new Database();

Employee emp = new Employee();

int pid = ((Employee)dataGrid1.SelectedItem).Id;

var query = (from t in DB.employees

where t.Id == pid

select t).First();

txtName.Text = query.Name;

txtAge.Text = query.Age.ToString();

txtGender.Text = query.Gender;

txtMobile.Text = query.MobileNo.ToString();

txtAddress.Text = query.Address;

}

The following snapshot shows how the pop-up window looks when you click on edit menu item.



To learn more about the pop-up window click here.

Delete Operation

When you click the delete option then the selected row from the Datagrid will be deleted from the database.

This is the code behind for the delete menu item.

private void Delete_Click(object sender, RoutedEventArgs e)

{

Employee emp = new Employee();

Database DB = new Database();

int pid = ((Employee)dataGrid1.SelectedItem).Id;

var query = (from t in DB.employees

where t.Id == pid

select t).First();

DB.employees.Remove(query);

DB.SaveChanges();

MessageBox.Show("Selected Row Deleted Successfully ");

dataGrid1.ItemsSource = DB.employees.ToList();

}

Summary

In this article I have shown how to create a context menu for a Data Grid. Using that we saw how an edit and delete operation can be done. If you have any queries then please do comment. Thank you for reading my article.