How to refresh aspx page from sql server

Question

How to refresh aspx page from sql server.I am using asp.net,C-Sharp with SQL Server 2008.What i mean is i have table, say Table1.If any DML operation is performed (Update,Insert etc) to Table1,then my page,say Page1.aspx should autmatically get refreshed.I can't use timer for refreshing the page.I need to trigger the refresh from database.

Should the page get refreshed even if the browser is closed? — Oded, Apr 10 '12 at 15:15
@Oded:-I guess my purpose won't be solved by closing the browser — Joby Kurian, Apr 10 '12 at 15:17
have a look at this : http://stackoverflow.com/questions/1437309/how-to-refresh-a-page-when-record-in-db-table-get-changed-in-asp-net-3-5 — Zaki, Apr 10 '12 at 15:17
**http://www.asp.net/web-forms/tutorials/data-access/caching-data/using-sql-cache-dependencies-vb** — huMpty duMpty, Apr 10 '12 at 15:18
Are you trying to update the page in real-time or on the next postback? — James Johnson, Apr 10 '12 at 16:00

score 6 · Accepted Answer · edited May 23 '17 at 12:00

Even though the server may be notified when data has changed, the real challenge is communicating those changes to the client in real-time without requiring a timer or user interaction.

You have a couple of options:

Your best bet is to use a WebSocket, which enables bidirectional communication between the client and server. This is the solution I would pick.

Here are some examples using WebSockets:
There are a few good libraries around too that will take care of most of the leg work. A couple to check out are WebSync and PokeIn. Both products offer decent documentation and community editions that you can download for free.

Here are some tutorials to check out:
- WebSync Tutorials
- PokeIn Basic Tutorial / PokeIn Advanced Tutorial
Use AJAX to poll for changes every X number of seconds. If changes are detected reload the page, otherwise do nothing.

score 1 · Answer 2 · answered Apr 10 '12 at 15:16

1

You probably want to look into the SqlDependency object. This object will notify you of changes to a specified database query in real time. When your application receives a message from the database, you can simply refresh the page in your code-behind.

answered Apr 10 '12 at 15:16

Michael Bowersox

1,471
11
17

Any examples of this being used in an application? – James Johnson Apr 10 '12 at 16:02
2

The problem with this approach is that it doesn't communicate back to the client in real-time. – James Johnson Apr 10 '12 at 16:24
You're probably right James... once the page has loaded, it doesn't matter that the SqlDependency has been registered since the page is no longer actively executing. I'm still thinking in WPF mode. – Michael Bowersox Apr 10 '12 at 17:14

score 0 · Answer 3 · answered Apr 10 '12 at 16:43

0

I wonder if you could adapt SignalR to send a message to the client to prompt a refresh?

This tutorial could get you started.

answered Apr 10 '12 at 16:43

SouthShoreAK

4,176
2
26
48

How to refresh aspx page from sql server

3 Answers3