CRUD Operation in DataGrid in WPF

In this article you will learn how to use 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.

image1.gif

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

image2.gif

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

image3.gif

We would change the table names as follows:

image4.gif

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

image5.gif

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:

image6.gif

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.

image7.gif

Create and Update Operation

The following code describes the Create and Delete Operation.

image8.gif

Delete Operation

The following code represents the Delete Operation.

image9.gif

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.