Popup Windows ASP.Net when new data inserted

Question

0.00/5 (No votes)

See more:

Hi,

I wanna as something,

How do I show PopUp window with ASP.Net when new data received in my database (MySQL). In my page, I set it to refresh every 5 seconds.
How do I do that?

Many thanks

Update : If anyone know how to do better to notify me when new data added, please tell me. (The notify should consist the value data added)

Posted 10-May-12 16:29pm

satrio_budidharmawan

Updated 10-May-12 17:12pm

v2

Add a Solution

Comments

Sandeep Mewara 10-May-12 23:03pm

Page refresh every 5 sec & a popup every new update - I will get irritated!

satrio_budidharmawan 10-May-12 23:11pm

Is there any better ways to notify me directly when new data added(including show me what's inserted)?

[no name] 10-May-12 23:48pm

What you tried to solve this problem?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

AmitKumar89 · Answer 1 · 2012-05-10T17:38:00

Solution 1

Hi,

I think this problem can be solved using SqlDependency.
Please follow the link:
http://www.dreamincode.net/forums/topic/156991-using-sqldependency-to-monitor-sql-database-changes/[^]
http://wdevs.blogspot.in/2011/10/notify-database-changes-to-aspnet-pages.html[^]
Using SqlDependency for data change events[^]

This may help you.
All the best.
-AK

Posted 10-May-12 17:38pm

AmitKumar89

Comments

satrio_budidharmawan 10-May-12 23:56pm

I don't think it will works with MySQL

Krunal Rohit · Answer 2 · 2012-05-10T18:09:00

Solution 2

you need to add this namespace in your code:

System.Windows.Form;
// it will include all the controls of form app in your asp. net app.

now when you click on Add Data(whatever name you've taken), write this code below your code:

C#

MessageBox.Show(here your value var+" added succesfully");

Hope this will help you. Thanks

Posted 10-May-12 18:09pm

Krunal Rohit

Updated 10-May-12 18:25pm

v2

Comments

[no name] 11-May-12 0:28am

what you've edited here, meber60?