Listening for database updates in asp .net
-
Hi All, I have a mysql database. I have a web portal in php where users can update personal information which is added and stored in the database. Im building another web app in asp .net which will feed from the same database. Is there anyway of 'listening' for when updates occur in the database efficently from my asp .net web app? Im not sure what the best approach is. Any suggestions much appreciated. Thanks Mike
-
Hi All, I have a mysql database. I have a web portal in php where users can update personal information which is added and stored in the database. Im building another web app in asp .net which will feed from the same database. Is there anyway of 'listening' for when updates occur in the database efficently from my asp .net web app? Im not sure what the best approach is. Any suggestions much appreciated. Thanks Mike
hardboy111 wrote:
Is there anyway of 'listening' for when updates occur in the database efficently from my asp .net web app?
As both the site are sharing the same database then why you are trying to listing? If there is any update in the database from PHP sites, when user refresh or reload the page in ASP.NET he will get the updated data. Any specific reason to do that?
cheers, Abhijit CodeProject MVP
-
Hi All, I have a mysql database. I have a web portal in php where users can update personal information which is added and stored in the database. Im building another web app in asp .net which will feed from the same database. Is there anyway of 'listening' for when updates occur in the database efficently from my asp .net web app? Im not sure what the best approach is. Any suggestions much appreciated. Thanks Mike
hardboy111 wrote:
Is there anyway of 'listening' for when updates
what do you mean by 'listening'. The very nature of web application does not allow you to listen to events on the server, or does it. One way to try is, since they are sharing the same database, in your asp.net you may want to use AJAX to check for updated periodically. This will be small and quick bursts of status checks. When you detect a change, hen you refresh your asp.net pages to fetch updated data.
Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
-
hardboy111 wrote:
Is there anyway of 'listening' for when updates
what do you mean by 'listening'. The very nature of web application does not allow you to listen to events on the server, or does it. One way to try is, since they are sharing the same database, in your asp.net you may want to use AJAX to check for updated periodically. This will be small and quick bursts of status checks. When you detect a change, hen you refresh your asp.net pages to fetch updated data.
Yusuf Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
im using a COMET approach. Hence if a update occurs I want to be able to push the update down to the web browser without any request from the client. Polling isnt what I want to do.