f_asmaa
asked on
PUSH technology in C#.net
How can I implement Push method in a VC#.net desktop application?
ASKER
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.
I don't think there's a language support this
you have to build that
you have to build that
ASKER
HOW? This was my first question !!!
>>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
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
ASKER
How can my application subscribe to an event in another application?
I need sample codes please.
I need sample codes please.
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
jurgen
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
jurgen
Bob