SQL SERVER -> ObservableCollection > Datagrid

Question

0.00/5 (No votes)

See more:

Hello all,

So I have the following dataflow :
SQL SERVER Table A > C# Observable collection > XAML Binding

I know that obsverable collection implements already PropertyChange so the
C# Observable collection > XAML Binding part is not an issue.

My question is : Is it possible to update the collection when I change a value in the sql table ?

Posted 9-Dec-11 6:20am

didileouf

Add a Solution

3 solutions

Solution 1

You will need a to update the underlying datasource everytime the table changes.
Have a look at event based processing[^].

Posted 9-Dec-11 6:31am

Abhinav S

Solution 2

So I dug into the question, but even if this solution propose interesting features, it doesn't suit my needs.
It's more like a monitoring method that I need.
In here, every change in the table will trigger the event base processing and send me a notification once. But say I have multiple instance of a programs taht connects to this database, if one instance updates the table, then it won't be catch by the other instances.

I ll keep you posted if I find an answer, thanks though

Posted 9-Dec-11 9:48am

didileouf

Comments

Amir Mahfoozi 10-Dec-11 1:12am

I think saving the changes and notifying all clients of the happened changes, are two distinct problems.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

didileouf · Accepted Answer · 2011-12-12T06:21:00

Ok, after more research I found out that there is something called SqlDependency that was implemented since SQL server 2005.
Very interesting function that enables the SQL Server to "push notifications" to the subscriber. (where here the subscriber is my C# program)

So now whenever the table in SQL change or is modified then it triggers a function in my C# program.

Pretty Cool :)

Thanks Abhinav for the hint. It helped me finding that.