473,657 Members | 2,378 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Refresh browser if database table is altered

271 Contributor
Hi Experts,

I have a senario and i am in need of your suggestions in this.
I have a database which is updated by a perl application. I use an asp.net page to display the data's in the database, and this page is accessing the database through a web service. For me this part is working fine. now i need to refresh my asp.net page is there occurs any change in the database (i.e., if the perl application alters the table it should get immediately reflected on my asp.net page). Timers can be used here but it is killing my resource as the database is huge.

Thanks in advance
karthi
Jan 7 '09 #1
4 1737
Plater
7,872 Recognized Expert Expert
Hmm, have you considered having the browser do a little messaging behind the scenes to ask "has anything changed?" and it the server says "yes it has" refresh your asp.net page. If the server says "nope, nothing new" then you don't refresh the page?
Jan 7 '09 #2
karthi84
271 Contributor
Hi Plater,Thanks for the reply. but even then there will be a huge traffic to my database server as when ever the browser requests the server the database will be hit. Is there any possible way for using triggers to refresh my page either directly or indirectly.
Jan 9 '09 #3
PRR
750 Recognized Expert Contributor
You could use static System.Timers.T imer in your web service...The timer can periodically "scan" a table where updates from parent page are copied..(not the original table, guess its "HUGE". For this to work write a trigger which will fire on insert update and delete... the trigger should copy that changed data to a new table)... The new table entry can be updated in web service(cached dataset/datatable ) and a static bool variable set to true( meaning something has changed..so update).. Meanwhile your your client aspx page can query whether the static variable has changed or not? if yes updated...?
Jan 9 '09 #4
karthi84
271 Contributor
Hi DeepBlue,This idea sounds good let me try in your way.
Jan 9 '09 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
2345
by: droog | last post by:
hi group! I am new to PHP and so far managed to find my answers by searching this group instead of posting repeating questions, but I don't know what to search for to get answer to this question: I want to sell pin numbers. I have a script called display.php that gets a pin number from MySQL database table, displays it in the browser and deletes the row it got that pin from in the database table.
10
6465
by: Conax | last post by:
Hi there, My boss is hoping that I can come up with a page that displays some information. The information will always be displayed on specific part of the page, with auto refresh. But he doesn't want the whole page to be refreshed so that buttons and images around the information do not get reloaded each time. Is this really possible? Other pages on this site don't use frames, so this page can't use frams too. Creating an ActiveX...
12
9774
by: Javier | last post by:
Hello, I'm very new in this forum and as I have the following problem, the website is in http://new.vanara.com ---------------------------------------------------------------------------- -------------------------------------------- Here's how the site works: You should press a button in the rollover area in order to load a source file on an Iframe, this Iframe is actually hidden working as a Buffer. The body of this loaded Iframe is...
17
3302
by: Jim Little | last post by:
Hello, I'm driving myself crazy either because I'm missing something about ASP.NET, or what I'm trying to do simply can't be done. First, I am not using session variables to track state. My app will ultimately be web-farmed, so I resisted using either session variables. Second, what I'm trying to do is easy. What I'm trying to prevent seems impossible.
15
33354
by: tmax | last post by:
PHP Pros: I have a simple html form that submits data to a php script, which processes it, and then redisplays the same page, but with a "thank you" message in place of the html form. This is all working fine. However, when refresh the browser, I get the following message displayed: "The page you are trying to view contains POSTDATA. If you resend the data, any action the form carried out (such as as search or online purchse) will...
6
9168
by: Mark | last post by:
i'm using an html form to submit comments to a database. the form is on the same page where the comments are being displayed. if you hit submit, your comment appears as it should, but then if you hit refresh there is a duplicate post. how might i fix this?
9
3109
by: sellcraig | last post by:
Microsoft access 2 tables table "data main" contains a field called "code" table "ddw1" is created from a make table query of "data main" Goal- the data in "code" field in needs to be inserted into a standard web address in the table (the filed name is link) in ddw1 Example address ---
6
3529
by: Chris Larmer | last post by:
I have two subforms in my main form. In the main form I want the user to select a customer, class, and date range. The 2 subforms are similar. One is the history records in the recent past and the other is future records. The user has to input a passenger forecast for the customer for the selected class for each record in the date range. The subforms are populated by a query which is altered according to their selection. I wish to...
10
5892
Ciary
by: Ciary | last post by:
hey all, i'm going to post my next question here since i have no idea where to start. my problem is this: i'm trying to this. i have a page from where i read all records from a table. when the admin adds a new record to a database, all visitors should get a refresh request or they should automatically refresh. a more practical example (to better explain what i mean) a radiostation keeps a playlist (starting from their last played song) on...
0
8411
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8838
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8739
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8613
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7351
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
5638
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2740
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1969
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.