Bind the WPF Data Grid to a Local Database

• Aug 22, 2023
• 2 minutes to read

This topic demonstrates how to bind the GridControl to a local database:

1. Connect your project to a local database.

2. Create a ViewModel template that implements ViewModelBase:

3. Build the solution to make the ViewModel class visible in the window’s Quick Actions.

4. Open the ThemedWindow‘s Quick Actions and define the window’s data context:

5. Open the GridControl‘s Quick Actions and invoke the Items Source Wizard.

6. Select the data source.

7. Run the project. The GridControl generates columns for all fields from a bound data source:

Note

For information on how to post changes to a database, refer to the following help topic: Post Changes to a Database.

GitHub Example

View Example: WPF Data Grid - Getting Started .NET

More Examples

The following example shows how to bind the WPF Data Grid to different data sources.

View Example: Bind the WPF Data Grid to Data

This example includes multiple solutions that demonstrate:

• How to bind the Data Grid to Entity Framework, EF Core, and XPO.
• Different binding mechanisms: virtual sources, server mode sources, and local data.
• MVVM and code-behind patterns.

After you bind the Data Grid to a database, you can implement CRUD operations (create, read update, delete). Refer to the following topic for more information: CRUD Operations in a Data-Bound Grid.

View Example: Implement CRUD Operations in the WPF Data Grid

See Also

Lesson 1 - Add a GridControl to a Project and Bind it to Data

Create Columns and Bind Them to Data Properties