Re: ASP.Net and SQL
-
Hi, Can anyone tell me is there any way to generate a message box or a popup window in asp.net when there is an entry in a database. Ex: Suppose i have a table and there are several users logged into my site. One of the users got registered to my site so a new entry is added to the database. At that time all the remainig users who are viewing my site should get a message box or a popup window saying that new user is added. If anyone can help me out of this i would be thankful to them Thanks in advance
-
Hi, Can anyone tell me is there any way to generate a message box or a popup window in asp.net when there is an entry in a database. Ex: Suppose i have a table and there are several users logged into my site. One of the users got registered to my site so a new entry is added to the database. At that time all the remainig users who are viewing my site should get a message box or a popup window saying that new user is added. If anyone can help me out of this i would be thankful to them Thanks in advance
You will need to use some client side script to display the message. Javascript:
alert('This is a message from the developer.');
In order to know when a new user is added you will need to carry out some kind of polling because web pages are essentially disconnected (IE There is no way to recieve an event in an ASPX (HTML) page on the client about something that happened on the server). This can be done by either posting a hidden page back periodically, or preferrably using AJAX. The only other thing to consider is - does the user need to be notified immediately or is on the next page submit/change sufficent? If they can wait until they do something that causes a postback then you could check in each page load event (You may want to create a base class that does this and make all of your pages inherit from it).
MCSD(VB6/SQL7) MCAD(C#/SQL2000) MCSD(C#/SQL2000) -- modified at 9:18 Friday 4th November, 2005