Fetching Data from Database

Question

0.00/5 (No votes)

See more:

I want to display a message with some data from sqlserver database, when a specific record is added or a specific event is fired on database.

Is it possible to do so without using timer control.

please help.

Posted 17-Jul-12 22:16pm

djrocks0101

Add a Solution

Comments

Rahul.KumarSharma 18-Jul-12 4:18am

Please explain in detail.

djrocks0101 18-Jul-12 4:24am

Actually I am using ajax timer( interval=1000) to fetch data from database and wanna know that ,is there any other method to do so because it increases the load on database.

bbirajdar 18-Jul-12 5:13am

You are on the correct path..Polling is the only option

StianSandberg 18-Jul-12 4:19am

The coolest way to do this is to use SignalR. :) google it and try it.

3 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)

Christian Graus · Answer 1 · 2012-07-17T22:23:00

A timer is not a control, you can just write a timer in javascript. No, without a timer, you cannot make a website refresh itself, or make an AJAX call without input. This is true if you write the code, or use a third party library. If you don't know that, then you don't understand how the web works.

bbirajdar · Answer 2 · 2012-07-17T22:27:00

Solution 4

Use can user SQL triggers

SQL Triggers[^]

Posted 17-Jul-12 22:27pm

bbirajdar

Comments

djrocks0101 18-Jul-12 4:40am

How its going to help me on webpage because on webpage I have to check when a trigger is fired.

bbirajdar 18-Jul-12 5:12am

If you want the webpage data to be refreshed automatically when the data at the backend is changes, you will have to send asyncronous requests to the database from the webpage using ajax calls after a particular interval like 5 seconds.

yimingjiang · Answer 3 · 2012-07-17T22:40:00

Solution 5

i agree to use web ajax.trigger performance is not high.

Posted 17-Jul-12 22:40pm

yimingjiang