Step by step Perform CRUD Operations in WPF with the use of Sql server

Through-out the article we will learn step-by-step: How to perform crud operations in WPF . We will discuss crud operations with usage of WPF. I have mention the code for Save,Edit,delete given below.


Through-out the article we will learn step-by-step: How to perform crud operations in WPF. We will discuss crud operations with usage of WPF


In these days, WPF is most growing technology and as a developer, I am curious to know and learn about the new features of this framework.

From last couple of days I was wondering how can I perform CRUD operations using sql queries. For the same I have gone through various forums etc. Unfortunately, I did saw very few posts/articles for the same.

Finally, I tried and came with a solution to perform CRUD operations without the use of WPF. In this article, I am going to share my findings with all of you.

Why Step-by-Step

Ah! This question came to my mind while I was finding the solution of my problem, I jotted down few points and finally called them as a steps to perform CRUD Operations.


To implement the solution and to feel the taste of code, you should:

  • Have Visual Studio 2013 or later with the support of WPF

  • Have Basic Idea of SQL Server

  • Have Basic Idea of Sql queries

What we are waiting for?

So, what we are waiting for here, lets get started. Just following these step(s) and we will done!

Step1: Create WPF Project

Launch your visual studio and perform following action (Refer to snapshot)
File->New->Select the new project ->Wpf Application->Type the Project Name

Create Project

Selecting a template for project:

Form Design.png

Step2:Create Form and view

Right click the Project then add->New Item -> Select Window(WPF) give the form name, then drag and drop controls placed in the forms and double click the button

Step3:Bind the Records using

In your view, write or copy/paste code, mentioned in following code-snippet:

private void FillGrid()
lstemp = GetDatas();
Dtgrid1.ItemsSource = lstemp;

Following code invoke the Insert and Update Records to database.

private void Cmd_Save_Click(object sender, RoutedEventArgs e)
if (Cmd_Save.Content == "Update")
SqlCommand sqlcmd = new SqlCommand("Update TblEmp set Empno='" + TxtEmpNo.Text + "',EmpName='" + TxtName.Text + "' where id=" + editid, sqlcon);
else if (Cmd_Save.Content == "Save")
SqlCommand sqlcmd = new SqlCommand("Insert into TblEmp values('" + TxtEmpNo.Text + "','" + TxtName.Text + "')", sqlcon);
else if (Cmd_Save.Content == "Delete")
SqlCommand sqlcmd = new SqlCommand("Delete From TblEmp where id="+editid, sqlcon);


Following code-snippet defines How to select corresponding record and then to populate them.

private void Dtgrid1_SelectionChanged(object sender, SelectionChangedEventArgs e)
object item = Dtgrid1.SelectedItem;
DataTable dt1 = new DataTable();
string ID = (Dtgrid1.SelectedCells[0].Column.GetCellContent(item) as TextBlock).Text;
editid = Convert.ToInt32(ID);
SqlDataAdapter sqladpsc = new SqlDataAdapter("Select * from TblEmp where id=" + ID, sqlcon);
if (dt1.Rows.Count > 0)
TxtEmpNo.Text =dt1.DefaultView[0]["EmpNo"].ToString();
TxtName.Text =dt1.DefaultView[0]["EmpName"].ToString();
Cmd_Save.Content = "Update";

Now, Fetch the records from database by passing parameters and without parameters.

public List GetDatas()
sqladp = new SqlDataAdapter("Select * from TblEmp", sqlcon);
foreach (DataRow dr in dt.Rows)
lstemp.Add(new Employee() { EmpId = int.Parse(dr[0].ToString()), EmpNo = dr[1].ToString(), EmpName = dr[2].ToString()});
return lstemp;

public Employee GetDatasval(string Sqry)
sqladp = new SqlDataAdapter(Sqry, sqlcon);
empcls.EmpId = Convert.ToInt32(dt.DefaultView[0][0]);
empcls.EmpName = dt.DefaultView[0][1].ToString();
empcls.EmpNo = dt.DefaultView[0][2].ToString();
return empcls;

Creating Form

Write or copy/paste code to your MainWindow.xaml , mentioned in the following code-snippet:

<Window x:Class="WpfApplication3.MainWindow"
Title="MainWindow" Height="500" Width="525" WindowStartupLocation="CenterScreen">
<Label Content="Name" HorizontalAlignment="Left" Margin="168,39,0,0" VerticalAlignment="Top"/>
<TextBox Name="TxtName" HorizontalAlignment="Left" Height="23" Margin="255,39,0,0" TextWrapping="Wrap" Text="" TabIndex="1" VerticalAlignment="Top" Width="120"/>
<Label Content="EmpNo" HorizontalAlignment="Left" Margin="168,82,0,0" VerticalAlignment="Top"/>
<TextBox Name="TxtEmpNo" HorizontalAlignment="Left" Height="23" Margin="255,82,0,0" TextWrapping="Wrap" Text="" TabIndex="2" VerticalAlignment="Top" Width="120"/>
<Button Content="Save" Name="Cmd_Save" HorizontalAlignment="Left" Margin="255,125,0,0" VerticalAlignment="Top" Width="101" Height="41" Click="Cmd_Save_Click"/>
<Label Content="Crud operations in WPF" HorizontalAlignment="Left" Margin="191,8,0,0" VerticalAlignment="Top" FontFamily="Arial Black" FontSize="14"/>

<DataGrid HorizontalAlignment="Left" Margin="10,192,0,0" VerticalAlignment="Top" Height="268" Width="497" Name="Dtgrid1" SelectionChanged="Dtgrid1_SelectionChanged"/>


In this whole article, we discussed about CRUD operations using WPF.


In this whole article, we discussed about CRUD operations using WPF.
1. Create a new project
2. Choose correct Project Type
3. Add New xaml Form
4. Add Methods using CommandButton
5. Add various operations

Hope, you find this article helpful.


  • How to Create MVC5 Sample Application Step by Step (46180-1-How-to-Create-MVC5-Sample-Application-Step-by-Step.rar)
  • Comments

    Author: Gaurav Aroraa04 Jul 2015 Member Level: Gold   Points : 0

    Good start! Keep posting good contents.

  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: