• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1707
  • Last Modified:

PUSH technology in C#.net

How can I implement Push method in a VC#.net desktop application?
1 Solution
Bob LearnedCommented:
What do you want to "push"?  Application updates?

f_asmaaAuthor Commented:
If someone makes changes in SQL Server database, I want the connecting .net applications to update themselves immediately. The current solution is to check for database updates every several minutes.
Mohammed NasmanSoftware DeveloperCommented:
I don't think there's a language support this
you have to build that
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

f_asmaaAuthor Commented:
HOW? This was my first question !!!
Mohammed NasmanSoftware DeveloperCommented:
>>The current solution is to check for database updates every several minutes.
you answered your question ;-)

there's no way that the connection or application will know the modification on the server

here's a suggestion, but maybe not the best soluation
write a trigger on database update or delete, and make this trigger make a call for application that notify your application about a something happen

maybe with Sql server2005 (yukon) it will be more easier, because it allow you to write a managed code inside it
Another way to do it is have an application running between your database and your client application (creating a 3-Tier solution).  There is plenty of material for this on the Internet, and you could create an event-driven solution (which would report to any subscribing clients) by routing all database access through the middle tier.
There is a solution that may work better for you (depending on the DB you are using).

1. You cache the data from the DB
2. You refresh the cache File is modified.  (Although ASP.NET caching cannot trigger expiration on a
change to a database, you can make the cache dependant on a file.)
3. (The trick) Create a trigger(s) in your DB that modifies the cache's "expiration" file whenever any action that warrants a refresh occurs on your table(s).

Here is a tutorial that describes this approach:
Write a trigger on the relevant table for (insert, delete whatever the case is) and invoke an external application through the trigger using extended stored procedures, this external application can raise an event which your application can subscribe to
f_asmaaAuthor Commented:
How can my application subscribe to an event in another application?

I need sample codes please.
Jurgen ThysC# DeveloperCommented:
Hi there,
I need to do something simular, I'm writing an auction site, I have two major Checks, the first most  check if there are any new articles on sale or off sall based on Start an Stop Time, this runs seperate from the clients sessions, the second check is: are there any new biding on the articles, in the client session or other client sessions, now I can do this with a classic updatepanel that returns the page to the server and check some Application var's, but every second?? that flickers, so I thought if I can put the first check in  a seperate thread (no problem) and the second in a thread that 'Pushes' the data updates (ultrawebgrid) to the clients page, then I can forget about update panel, because that's sending the entire page over the net
Is this possible? implement a sort of RSS ??
friendly greetings

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now