CRUD Operation in DataGrid in WPF

Introduction

I have been getting requests to write article on DataGrid CRUD operation without using any other control. So this article is for all the requestors. I have used only DataGrid for CRUD operation.

Crating WPF Application Project

Fire up Visual Studio 2008 and Create a WPF Application and name the project as CRUDDataGridWPF.



We would use Linq to SQL as our ORM. So add like below figure.



Now after adding, open the Server Explorer and add the required table, in our case EMP_BASIC_INFO.



We would change the table names as follows:



Now in Blend I have designed the WPF Application like the below figure.



The design displayed above contains a DataGrid for CRUD Operations and a TextBlock to display status messages.

It's below the DataGrid.

The following XAML code is for your reference:



We will perform the operation in below order:

1. Read
2. Create and Update
3. Delete

Read Operation

The following code describes the read operation.



Create and Update Operation

The following code describes the Create and Delete Operation.



Delete Operation

The following code represents the Delete Operation.



Now run the application and all the CRUD operations are successfully used.

Note: Code is not written for multi select delete. It can be done the same way single select, try doing it

Hope this article helps.