Concurrency notification question

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

I'm posting this question in both the SqlServer and ADO.Net newsgroups in
the event there might be a programmatic answer on either the frontend or the
backend.

Imagine a small network running the same app attached to SqlExpress. A
listbox is filled via a datareader with contact names using an autonumber ID
as the selected value.

User 1 edits a contact name. Upon firing the Update, the app reloads the
contact listbox on User 1's copy of the app.

User 2 adds a new contact. Upon firing the Insert, the app reloads the
contact listbox on User 2's copy of the app.

But User 1 does not have the new contact added by User 2, and User 2 does
not have the updated name of the contact edited by User 1.

Is there a better method of showing/updating/notifying User 1 that a new
contact exists (and to notify User 2 that a name has been changed) other
than waiting for the next time the contact listbox gets reloaded on those
respective systems? Perhaps "notify" is the incorrect word, I just would
like those changes to be shown in all copies of the app that are on the
network.
 
Earl said:
I'm posting this question in both the SqlServer and ADO.Net newsgroups in
the event there might be a programmatic answer on either the frontend or
the backend.

Imagine a small network running the same app attached to SqlExpress. A
listbox is filled via a datareader with contact names using an autonumber
ID as the selected value.

User 1 edits a contact name. Upon firing the Update, the app reloads the
contact listbox on User 1's copy of the app.

User 2 adds a new contact. Upon firing the Insert, the app reloads the
contact listbox on User 2's copy of the app.

But User 1 does not have the new contact added by User 2, and User 2 does
not have the updated name of the contact edited by User 1.

Is there a better method of showing/updating/notifying User 1 that a new
contact exists (and to notify User 2 that a name has been changed) other
than waiting for the next time the contact listbox gets reloaded on those
respective systems? Perhaps "notify" is the incorrect word, I just would
like those changes to be shown in all copies of the app that are on the
network.
Click to expand...

Query Notifications in ADO.NET 2.0
http://msdn2.microsoft.com/en-us/library/ms379594(VS.80).aspx

David
 
Thanks David ... Query Notifications has been kicking my butt for weeks now,
including where the implementation made changes to the database that caused
my app to hang on startup (an issue I never did resolve without removing the
Notification setup). And nobody ever replied to a few Notification topics
that I posted, so I got the distinct impression that no one is really using
them outside of Microsoft.
 
Hi, Earl:

After looking at your question, it seems to me that our SocketPro at
www.udaparts.com is the anwser to your problem.

Our SocketPro has a built-in simple but powerful real-time notification.
See the site http://www.udaparts.com/document/articles/articles.htm and
http://www.udaparts.com/document/articles/chatservice.htm.

As long as you play with the tutorial 2 and other samples, you can
easily figure out how to use SocketPro built-in real-time notification
service for your project.


Regards,
 
Cor,

I had a similar requirment and was told in the windows.daabinding forum that
SQL Depndency and Notification doesn't work with SQL Express.

But in the sample on vb-tips, looking at the connection string, it seems the
sample is working with SQL Express.

So will sql dependency and Query notification work SQL Express ?

thanks
 
Cor,

Whenever I go to a link to your website, I always get just the blue
background although the browser indicates "Done". I'm wondering if there are
some controls or popups in action that my system is blocking.
 
AnikSol said:
Cor,

I had a similar requirment and was told in the windows.daabinding forum
that SQL Depndency and Notification doesn't work with SQL Express.

But in the sample on vb-tips, looking at the connection string, it seems
the sample is working with SQL Express.

So will sql dependency and Query notification work SQL Express ?
Click to expand...

Yes, Query Notification works on Express Edition. I just tested it.

If you are not getting the notifications you expect check the service broker
transmission queue for errors.

select * from sys.transmission_queue

David
 
thanks to David and Cor.


David Browne said:
Yes, Query Notification works on Express Edition. I just tested it.

If you are not getting the notifications you expect check the service
broker transmission queue for errors.

select * from sys.transmission_queue

David
Click to expand...
 
Earl,

We use very much the new Ajax controls, will you tell us what browser you
are using?

Cor
 
Earl,

Our policy is that we have this website for developpers who in our opinion
use at least when they are free the latest tools. It is as well usable with
the newest FireFox by the way and was more curious if you was using that
browswer..

I don't know how I can test with IE 6.0, the effort to build a computer with
only that is to much for me, while even as it is not working with that
browser we won't change things. Maybe have others as well problems with the
IE 6.0 than I will be pleased to hear it here, so we know that.

Cor
 
Back
Top