Update ItemsSource Linq to SQL WPF

Question

0.00/5 (No votes)

See more:

I have a treeview in a WPF application that links to a SQL Express DB using Linq to SQL and a data provider. Simple and it works.

treeMovies.ItemsSource = dataProvider.GetCollection_Movies();

My problem is that I can find no way to refresh the treeview after a new record is added to the DB with out killing the itemsource and re-adding it. Is there a way to refresh the treeview to show the new records with out reloading the entire DB?
thanks
Scott

Posted 10-Dec-10 11:41am

ScottRadel

Add a Solution

1 solution

Add a Solution

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

AspDotNetDev · Accepted Answer · 2010-12-10T13:19:00

Solution 1

Use an ObservableCollection (OC) as your ItemsSource. When you add something to the DB, add it to the OC. When you delete from the DB, delete from the OC. When you modify a record in the DB, either replace or modify the item in the OC. If you modify the item (e.g., change properties on it), then you'll want to make sure that item is observable as well (one way to do this is to implement the INotifyPropertyChanged interface).

Posted 10-Dec-10 13:19pm

AspDotNetDev

Comments

ScottRadel 11-Dec-10 10:57am

I have not taken a look at the observablecollection yet as I am pretty new to WPF. As I want to change the query in the treeview at runtime I assume I will need to use it in code behind. I will see what I can find on the internet, but if anyone knows of a good tutorial please post it.
thanks
Scott

AspDotNetDev 11-Dec-10 19:06pm

Check out this article: http://www.codeproject.com/KB/silverlight/SLListVsOCollections.aspx . That is Silverlight specific, but Silverlight and WPF share most of their technologies, including ObservableCollection and INotifyPropertyChanged.

Update ItemsSource Linq to SQL WPF

1 solution

Solution 1

Add your solution here

Preview 0

Update ItemsSource Linq to SQL WPF

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us