ASP.NET MVC Ajax

Question

I would like to have a page that checks for updates to a database table and refreshes the grid using an Ajax call and when a new row is inserted into the table pop up a message window.

This database table gets updated with new rows every 15 minutes or so and the message window lets the user know that a new record has been added or possibly more than one record.

I'm wanting to do this in ASP.NET MVC with Ajax but have no idea how to go about setting up the javascript to check for updates on a timer or if there's a flag that the XHR uses to indicate a change in state.

Mani · Accepted Answer · 2011-05-10 04:32:14Z

3

You should try PokeIn library. It helps you to notify connected clients based on server side events. Here is a basic scenario;

Single static timer runs on the server side and checks any changes on DB. If an update is available sends it to connected clients / associated groups etc.

Samples are available from

answered May 10, 2011 at 4:32

Mani

513 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tomas Aschan · Accepted Answer · 2009-06-18 21:40:51Z

1

This could be a possible way to do it:

Store the time when the data is aquired in a global variable in javascript.
Every x minutes, you do a javascript call to an action method with the timestamp as parameter. This can be done for example using the jQuery Timer as suggested by Rony.
The action method checks the database to see if anything has changed or not, and returns a simple boolean 1/0.
If, and only if, the data has changed, you get the new data from another action method and notify the user that new data has been retrieved.

answered Jun 18, 2009 at 21:40

Tomas Aschan

61.2k62 gold badges267 silver badges424 bronze badges

Comments

Rony · Accepted Answer · 2009-06-18 21:41:24Z

0

you can use jQuery timers to check the state of the database using ajax and then modify the values in the table accordinly

answered Jun 18, 2009 at 21:41

Rony

9,5392 gold badges24 silver badges22 bronze badges

Collectives™ on Stack Overflow

ASP.NET MVC Ajax

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related