Click here to Skip to main content
15,883,834 members
Articles / Desktop Programming / WPF
Article

Introduction to the WPF DataGrid

Rate me:
Please Sign up or sign in to vote.
2.68/5 (45 votes)
12 Aug 2008CPOL2 min read 346.5K   4.3K   54   33
A article show how to use the new DataGrid in WPF

Introduction

After WPF was released without a DataGrid, Microsoft received loads of criticism! Thy have finally released the highly anticipated DataGrid (CTP)! Here is a short introduction on how to use the DataGrid

Required

Download the WPFToolkit here

To run my sample application, also install the Northwind database

Getting started

Create a blank WPF application and add a new item (LINQ-to-SQL Class). Drag the required tables from the Northwind database onto the design surface

LINQ2SQL.jpg

Now that we have a simple database to work from, lets add the DataGrid to our project. Add a refrence to WPFToolkit.dll and add the namespace to your main window's XAML

xmlns:dg="clr-namespace:Microsoft.Windows.Controls;assembly=WpfToolkit"

The simples DataGrid we can create is by adding the DataGrid in our window and setting the AutoGenerateColumns to True! This will automatically generate a column for each field in the table. I also gave the DataGrid a name so I can access it in my code-behind

<dg:DataGrid 
    x:Name="NorthwindDataGrid"
    AutoGenerateColumns="True" />

All that is now left to do is get the table from the database (using my created LINQ-to-SQL class) and setting the DataGrid's ItemSource (The DataGrid inherits from ItemsControl)

private void Window_Loaded(object sender, RoutedEventArgs e)
{
    using (NorthwindDataContext dc = new NorthwindDataContext())
    {
        NorthwindDataGrid.ItemsSource = dc.Customers.ToList();
    }
}

And here is the DataGrid in its full glory…

DataGrid.jpg

That was easy, what else can this baby do?

By default, the DataGrid supports resizing, reordering, sorting, adding and removing. This behavior can be controlled with the following properties:

  • CanUserAddRows
  • CanUserDeleteRows
  • CanUserResizeColumns
  • CanUserReorderColumns
  • CanUserSortColumns

On editing a cell, the following events gets fired...

  • PreparingCellForEdit
  • BeginningEdit
  • CommitingEdit
  • CancelingEdit

The DataGrid derives from MultiSelector allowing true multi row selection scenarios. The selection mode is controlled by setting SelectionMode to Single or Extended

The SelectionUnit can also be changed to only select a cell (DataGridSelectionUnit.Cell), row (DataGridSelectionUnit.FullRow) or cell/row (DataGridSelectionUnit.CellOrRowHeader)

The DataGrid also fully support clipboard copy/past

More Resources

  • Read more about the full feature list of the DataGrid here
  • Vincent Sibal also has some excellent content on his blog about the subject

As always, please vote for the article (And if you thought it sucked, please leave a comment telling me how to make it better in the future)

Rudi Grobler

http://dotnet.org.za/rudi

History

12-Aug-2008 - Initial version released

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
South Africa South Africa
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
Question[My vote of 1] not great Pin
BillW3321-Jul-15 3:41
professionalBillW3321-Jul-15 3:41 
Questionxfcbv Pin
xjie3-Sep-12 23:52
xjie3-Sep-12 23:52 
GeneralMy vote of 2 Pin
SinisaRuzin28-Jun-12 2:57
SinisaRuzin28-Jun-12 2:57 
GeneralMy vote of 2 Pin
akjoshi27-Jun-12 1:49
akjoshi27-Jun-12 1:49 
GeneralMy vote of 2 Pin
Bohdan Kuts22-Dec-11 2:57
Bohdan Kuts22-Dec-11 2:57 
GeneralMy vote of 1 Pin
XtErMiNaToR10221-Aug-11 0:58
XtErMiNaToR10221-Aug-11 0:58 
GeneralMy vote of 1 Pin
rmbsrichard23-Jun-11 15:00
rmbsrichard23-Jun-11 15:00 
GeneralGreat for us beginners, but could be clearer Pin
reihtec28-Jan-11 6:35
reihtec28-Jan-11 6:35 
GeneralMy vote of 3 Pin
reihtec28-Jan-11 6:34
reihtec28-Jan-11 6:34 
GeneralMy vote of 2 Pin
StewBob18-Oct-10 9:04
StewBob18-Oct-10 9:04 
General"An unhandled exception of type 'System.Security.SecurityException' occurred in Unknown Module." Pin
Mike Gledhill30-May-10 22:55
Mike Gledhill30-May-10 22:55 
GeneralMy vote of 1 Pin
AlexanderO227-May-10 2:41
AlexanderO227-May-10 2:41 
GeneralMy vote of 1 Pin
ivix4u12-May-10 23:11
ivix4u12-May-10 23:11 
GeneralAnother interesting article about the WPF DataGrid Pin
Christian Moser1-Mar-10 9:03
Christian Moser1-Mar-10 9:03 
GeneralMy vote of 1 Pin
Ali BaderEddin22-Feb-10 13:02
Ali BaderEddin22-Feb-10 13:02 
This information is already out there.. Nothing new.
Generalit sucks. Pin
kelx3922-Feb-10 4:24
kelx3922-Feb-10 4:24 
GeneralMy vote of 1 PinPopular
vikramjb15-Dec-09 1:49
vikramjb15-Dec-09 1:49 
GeneralErrors when running sample: Columns not found - LastEditDate and CreationDate Pin
realvasche1-Oct-09 11:39
realvasche1-Oct-09 11:39 
GeneralMy vote of 2 Pin
Riaan Hanekom7-May-09 8:38
Riaan Hanekom7-May-09 8:38 
GeneralMy vote of 2 Pin
Charith Jayasundara25-Nov-08 3:34
Charith Jayasundara25-Nov-08 3:34 
QuestionHow do you update the database? Pin
PbLarry499-Nov-08 7:56
PbLarry499-Nov-08 7:56 
AnswerRe: How do you update the database? Pin
Colin Eberhardt12-Nov-08 6:08
Colin Eberhardt12-Nov-08 6:08 
GeneralCalendar Control Pin
sashdude4-Oct-08 17:16
sashdude4-Oct-08 17:16 
Generaldoesnt work Pin
jesuscheung2-Oct-08 8:45
jesuscheung2-Oct-08 8:45 
QuestionHow to add data into DataGrid with out using Data Binding Pin
Harsha Vardhan K23-Sep-08 1:22
Harsha Vardhan K23-Sep-08 1:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.