Question How to display / edit MS Access DB in WPF application

[vabatta]

Hi all,
after HOURS and HOURS to try understanding how to display or how to use a MS Access DB in a WPF application as a ItemsSource or DataSource, I'm asking you if someone know a DETAILED guide or really help me, because it's impossible...

Thanks all.

 

[jmcilhinney]

You don't use an Access database as a data source for any controls ever, so there goes that idea. Data access in WPF is no different to data access in Windows Forms. Ignoring other options like Entity Framework, you would simply use a DataAdapter or TableAdapter to populate a DataTable. Once you have finished making changes to the data in the DataTable then you use the same adapter to save the changes back to the database. Any tutorial on ADO.NET will cover that part.

As for how to bind the DataTable to the DataGrid, information on that is a Google search away.

https://www.google.com.au/search?q=...s=org.mozilla:en-GB:official&client=firefox-a