Show/Delete/Edit data in WPF DataGrid using LINQ to SQL Classes

Raj Kumar

LINQ to SQLLINQ to SQL ClassesBinding in WPFData grid operation in WPFdatagrid using LINQ to SQL classesdelete data in wpfedit data in wpf

21 Comments

Join the conversation! Your thoughts help the community grow.

aseman arabsorkhi4y ago
How can you edit grid row? after edit event selected row must be editable, but it is not
Bryan Lemus9y ago
Me anda bien con solo cambiar "MyDataGrid.ItemsSource = customers;" por MyDataGrid.ItemsSource = customers.ToList();
samin hajian10y ago
i have this Error "Cannot implicitly convert type 'long' to 'string' " in update function. how can i convert it line to wpf project?
- Ajay Krish6y ago
  String m = tblManagerrow.ID.ToString(); This will help U
red fun10y ago
edit is not working also delete does not working
vishal jain11y ago
Edit is not working. customRow.CompanyName gives these value System.Windows.Controls.DataGridTextColumn
Muhammad nauman khan12y ago
Thank you
diego urabayen12y ago
no anda el edit. Para que publican cosas que no funcionan?
Kris Timmerman14y ago
In MSVS 2010, I removed the "xmlns:grid=http://schemas.microsoft.com/wpf/2008/toolkit" and it was then able to find "DataGrid". How can you insert a new customer?
Pushkar Gupta14y ago
Hi, Thx for sharing this demo. Please let me know, I can i do it using MVVM Thx.
Indranil Sarkar14y ago
Hello, Raj Kumar!! I have run of your project but your editing option is not working at all. I tried doing a different one by seeing of your code but It doesn't work with Edit with save part. If you do run and get the same problem then please update your article one.
Paras Paras14y ago
good Example
marius muntean15y ago
Code throws Object not referenced to an instance of an object at the edit button function: line with var
C B15y ago
At last a decent article on how to use the datagrid and commit changes back to a database table.
Olia Tymarkin15y ago
Hi, I have a datagrid which is binded to the sql table (i am using linq to sql). when i present the grid , i want to be able to sort its columns by clicking its column header. so far i do not have this ability. on the other hand , when i bind another data grid to list of items that i take from this table , i can sort the datagrid by clicking its columns header. where do i make my mismake?
HOSSEIN ABBASZADEH15y ago
Thank u Dear!
Dharmendra Gaur16y ago
can you suggest any ebook regarding WPG Datagrid
- Syed Shakeer15y agoedited
  Hi, Very Nice Article.It helps lot....
- Mayur Dhavle12y ago
  Here is a website by which you can learn WPF in an effective manner, www.wpftutorial.net/
Dharmendra Gaur16y ago
Hello Sir Nice article that really help, Can you suggest any tutorial link for WPF Datagrid.
- Raj Kumar16y ago
  thank you dharmendra

This article will demonstrate how to Show, Delete, and Edit data in WPF Data Grid using LINQ to SQL Data Classes. What is LINQ to SQL?? When you want to use Language-Integrated Query (LINQ) to access data in a database, you do not connect directly to the database. Instead, you create classes that represent the database and its tables, and use those classes to interact with data. You can generate the classes through the Object Relational Designer or by running the SqlMetal.exe utility. For more information, see Object Relational Designer (O/R Designer) and Code Generation Tool (SqlMetal.exe).

So Let's start first of all add a new item LINQ to SQL data Classes.

WPF DataGrid

Figure 1.

Now drag and drop database table using server explorer.

Figure 2.

If you are using Visual studio 2008 then you need to add a reference of WPF Toolkit, you don't need to add this reference in visual studio 2010.

Figure 3.

Add wpf toolkit name space on your .xaml page or window whatever you using.

xmlns:grid=http://schemas.microsoft.com/wpf/2008/toolkit

This is my DataGrid.

<Grid>
<grid:DataGrid x:Name="MyDataGrid" x:Uid="MyDataGrid" AutoGenerateColumns="False"
AlternationCount="2" SelectionMode="Single" Margin="0,31,0,0">
<grid:DataGrid.Columns>
<grid:DataGridTextColumn Binding="{Binding Path=CustomerID}" IsReadOnly="True" Header="Customer ID" Width="SizeToHeader" />
<grid:DataGridTextColumn Binding="{Binding Path=CompanyName}" Header="Company" Width="SizeToHeader" />
<grid:DataGridTextColumn Binding="{Binding Path=ContactName}" Header="Name" Width="SizeToHeader" />
<grid:DataGridTextColumn Binding="{Binding Path=City}"
Header="City" Width="SizeToHeader" />
<grid:DataGridTextColumn Binding="{Binding Path=Country}" Header="Country" Width="SizeToHeader" />
<grid:DataGridTextColumn Binding="{Binding Path=Phone}"
Header="Phone" Width="SizeToHeader" />
<grid:DataGridTemplateColumn Header="Edit Row">
<grid:DataGridTemplateColumn.CellTemplate>
<DataTemplate>
<Button Content="Edit" Click="EditButton_Click" />
</DataTemplate>
</grid:DataGridTemplateColumn.CellTemplate>
</grid:DataGridTemplateColumn>
<grid:DataGridTemplateColumn Header="Delete Row">
<grid:DataGridTemplateColumn.CellTemplate>
<DataTemplate>
<Button Content="Delete" Click="DeleteButton_Click" />
</DataTemplate>
</grid:DataGridTemplateColumn.CellTemplate>
</grid:DataGridTemplateColumn>
</grid:DataGrid.Columns>
</grid:DataGrid>
<Button Height="23" Margin="12,2,0,0" Name="LoadButton" Content="Load Customers" VerticalAlignment="Top" Click="LoadButton_Click" HorizontalAlignment="Left" Width="126"></Button>
</Grid>

.XAML.CS

private void LoadButton_Click(object sender, RoutedEventArgs e)
{
LoadCustomers();
}

private void LoadCustomers()
{
CustomersDataContext cd = new CustomersDataContext();
var customers = (from p in cd.Customers
select p).Take(10);
MyDataGrid.ItemsSource = customers;
LoadButton.Content = "Customers Loaded";
}

Now run your application, you will see output like this. When you click on Load Customers button your data will display in datagrid.

WPF DataGrid

Figure 4.

Figure 5.

private void EditButton_Click(object sender, RoutedEventArgs e)
{
try
{
CustomersDataContext dataContext = new CustomersDataContext();
Customer customerRow = MyDataGrid.SelectedItem as Customer;
string m = customerRow.CustomerID;
Customer customer = (from p in dataContext.Customers
where p.CustomerID == customerRow.CustomerID
select p).Single();
customer.CompanyName = customerRow.CompanyName;
customer.ContactName = customerRow.ContactName;
customer.Country = customerRow.Country;
customer.City = customerRow.City;
customer.Phone = customerRow.Phone;
dataContext.SubmitChanges();
MessageBox.Show("Row Updated Successfully.");
LoadCustomers();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message);
return;
}
}

WPF DataGrid

Figure 6.

private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
CustomersDataContext cd = new CustomersDataContext();
Customer customerRow = MyDataGrid.SelectedItem as Customer;
var customer = (from p in cd.Customers
where p.CustomerID == customerRow.CustomerID
select p).Single();
cd.Customers.DeleteOnSubmit(customer);
cd.SubmitChanges();
MessageBox.Show("Row Deleted Successfully.");
LoadCustomers();
}

WPF DataGrid

Figure 7.