Readdy Write  
0,00 €
Your View Money
Views: Count
Self 20% 0
Your Content 60% 0

Users by Links 0
u1*(Content+Views) 10% 0
Follow-Follower 0
s2*(Income) 5% 0

Followers 0
Login Register as User

WPF: Display data in a DataGrid

06.08.2018 (👁1500)


This example shows how to display data from a database in a DataGrid.


A table from an existing local database is dragged and dropped into the WPF application.


In the first step, drag a DataGrid into the WPF application under Toos-> DataGrid


Then select from Database (Database, Service, Object)


Then choose the Database Model.

The database model later displays the structure of the database as a dataset.


As selection existing data connections are displayed. The local database (service based) is suggested as default.

.mdf files are sql server databases.


Afterwards one selects all tables and views, which one wants to take over in the project


Data sources

Then, under Data Sources, the database is displayed as a DataSet with the individual tables


DataSource: compile project.

In order for the DataSource to be displayed and integrated, you first have to compile the project



Now you just have to pull from the area: DataSources-> the table into the DataGrid


design view

After dragging the Datasource table into Design-> Datagrid, the structure of the table is displayed at design time



F5 running time

During the compiled start with F5, an executable data grid table is created in the form where the data is directly linked to the table and equipped with the standard functions of a grid.

You can delete new data in the bottom line, change it.



Code for loading

The c # code for loading the data grid can be found under the load event of the MainWindows


Standard code under MainWindow.xal.cs


To load the DataSource into the data grid while loading the form

private void Window_Loaded(object sender, RoutedEventArgs e)



    wpf_demo_Datagrid_Db.dbGridTestDataSet dbGridTestDataSet = ((wpf_demo_Datagrid_Db.dbGridTestDataSet)(this.FindResource("dbGridTestDataSet")));

    // Load data into the table tbl_GridTest. You can modify this code as needed.

    wpf_demo_Datagrid_Db.dbGridTestDataSetTableAdapters.tbl_GridTestTableAdapter dbGridTestDataSettbl_GridTestTableAdapter = new wpf_demo_Datagrid_Db.dbGridTestDataSetTableAdapters.tbl_GridTestTableAdapter();



    System.Windows.Data.CollectionViewSource tbl_GridTestViewSource = ((System.Windows.Data.CollectionViewSource)(this.FindResource("tbl_GridTestViewSource")));