.net - Using SqlCacheDependency To Get Real Time Updates?
Jan 9, 2010
I would like to display real time updates on a web page (based on a status field in a database table that is altered by an external process). Based on my research, there are several ways of doing this.
Long Polling (Comet) - This seems to be complex to implement Regular Polling - I can have an AJAX method trigger a database hit every 5seconds to get the current status. But I fear this will have performance issues.
Then I read about using SqlCacheDependency - basically the cache gets invalidated based on a field in the table. I am assuming I can use the event trigerred when the cache is invalidated to show the new update to the user?
View 2 Replies
Similar Messages:
Nov 17, 2010
How do you implement a real-time update like Twitter does ("423 more tweets since you started searching")? I need to refresh my page at least every 10 seconds. I'm using ASP.NET MVC and jquery.
View 4 Replies
Feb 27, 2010
I have seen several websites that show you a real time update of what's going on in the database. An example could be. A stock ticker website that shows stock prices in real time Showing data like "What other users are searching for currently.." I'd assume this would involve some kind of polling mechanism that queries the database every few seconds and renders it on a web page. But the thought scares me when I think about it from the performance standpoint.
In an application I am working on, I need to display the real time status of an operation that a user has submitted. Users wait for the process to be completed. As and when an operation is completed, the status is updated by another process (could be a windows service). Should I query the database every second to get the updated status?
View 3 Replies
Sep 30, 2010
I would like to create a progress bar with real time updates on the different method calls that happen on a button click in asp.net 1.1. I have seen some examples but nothing that provides updates on the progress bar while the server side operation executes.
View 1 Replies
May 7, 2015
How to Display online users as green and offline as grey using real time updates..
View 1 Replies
Mar 31, 2011
Given a Database that has a table Called [Bid Transactions], which contains records of all available auctions that are currently running on an ASP.net website .. something similar to Ebay.com, when the deadline of the auction passed, I should close that auction, Send a notification message to both the item owner and the bidding winner to inform them.
how should I keep track of all open auctions? how could I monitor all their ending time and update the Auction status to be "Closed" on Real-time basis? ..
(1) Using SQL jobs ? .. that should reduce system performance .. shouldn't it ?
(2) A back-end service that is running on the server and uses Threading ? .. I have no clear background about that solution.
View 1 Replies
Feb 9, 2011
I made a progress bar for uploading by using web services and javascript. But I got a problem. It is ever late web services than file save function. Thous, the information is not real in client side. How can I do?
View 1 Replies
Mar 2, 2011
I need to add a "real-time" element to my web application. Basically, I need to detect "changes" which are stored in a SQL Server table, and update various parts of the UI when a change has occured. I'm currently doing this by polling. I send an ajax request to the server every 3 seconds asking for any new changes - these are then returned and processed.
It works, but I don't like it - it means that for each browser I'll be issuing these requests frequently, and the server will always be busy processing them. In short, it doesn't scale well. Is there any clever alternative that avoids polling overhead?
View 6 Replies
Dec 1, 2010
i need to build asp.net program that connect to sql-server 2008 i have in my program row count that count my database rows. i need to see allwais this row count. is there any way to show this ? any refresh ? or i need to run all the time any query ? any timer? i need something that not take A lot of resources
View 3 Replies
Jan 17, 2011
I have a set of forms that user must fill, and those forms represent some html output. I want user to be able to see how his input will look like while he filling the fields. So, just wondering if anyone know's a good way or even maybe there is such a thing as plugin or something.
View 2 Replies
Jun 3, 2010
I'm looking for a way to put real time features into my web site. The idea is asynchronous communication between 2 people - like a chat session. If I use the chat example - I'd like the second person to know that the first one has sent a message to him, without refreshing or doing something active on the web page. Polling is not a good idea here - so is there any other solution? the back-end could be ASP.NET or PHP (ASP.NET preferred).
View 3 Replies
Apr 2, 2010
Iam new to webservices,Till now I did not use web service.Anybody can you give a real time example for webservice.Please it will be very useful for me.
View 3 Replies
Oct 19, 2010
I am newbie in the world of web application. I need ur suggestion.I am using oracle 9 in Aix platform. I have several sql queries that need to run periodically. I am planning to make web based application where in backend those query will be run and query result will show in my desktop PC. Query result need to refresh after 10 minutes.
View 1 Replies
Jun 2, 2010
I am developing a real time tracking system , we are using cisco apis for retrieving the current location and they store this value in a location server(cisco hardware) ie from that server we will get the x and y positions. Using this x and y posituions i need to show the path of the object. i need to continuouly connect this with location server and retrieve the x and y and needto show the path . How this will be possible. Currently we are uising timer and refreshing it with 5 seconds. Is there any other way so that we need to show the path as soon aspossible likle an ant moving along the surfacce.
View 5 Replies
Mar 29, 2011
I have an asp.net application which uses session for user management. So if the application is restarted users will loose their works. I have some components used by this asp.net application and those components (class libraries in Bin folder) have configurations. I want to save configurations of those components somewhere and change them from back-end (administration panel) and the components use the updated configs but still application should not be restarted (changing web.config will result in application restart).
View 2 Replies
Apr 13, 2010
need ASP.NET File Upload with Real-Time Progress Bar
View 13 Replies
Nov 30, 2010
i need to build web program that connect to sql-server-2008 with 50 user's that run query and update the database. i need a fast real-time web program. what will be faster asp.net or ajax ?
View 4 Replies
Feb 17, 2011
i am trying to do ajax file upload and real time progress bar, i have tested it in the localhost and it worked perfectly, however when i tried testing it on the online Web Server the bar didn't work up till the end of the uploading file, when i put System.Threading.Sleep(value) in the end of uploading loop, the bar worked but the uploading was very slow, how to get rid of this?
View 3 Replies
Jul 15, 2010
I am wondering how is the real-time notification in facebook achieved? What kind of technologies are required?
Another question: I have a asp.net website and a back-end processing software. I want the back-end processing software to comunicate with the website so that the website can dynamically update the page. I am thinking that web service may be the solution. Is this right?
View 7 Replies
Jun 19, 2010
what pourpose we are using web service instead of traditional data-tier functionality. I aften seen some of the persons using webservice to interact with
Friend-end to back-end.
I also need some of the real time project demos has been done with the webservice functionality for my reference.
View 3 Replies
Sep 28, 2010
i am new to .net, i know fundamentals/basics only, i am using vs2008,sqlserver2005
i want to do a project with asp.net(using c#), SQlServer, Ajax, etc.
but i dont know how to start a project in real time scenario.
View 2 Replies
May 7, 2015
how to provide user notification about anything from database in asp.net like gmail ? see the pic for more detail :
[URL]
View 1 Replies
May 26, 2012
I have a webform that has a button. When the button is clicked, it gathers some records from a database and is supposed to update the UI with each record pulled. But for some reason, the UI only updates when the operation completes. I've posted the markup below. I can post the code if needed.
ASP.NET Code:
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<p>
<asp:Button ID="btnStart" runat="server" Text="Start" Width="94px" /></p>
<table style="width: 99%;">
[Code] .....
View 1 Replies
Jul 17, 2010
I found one link or web services [URL] which enable me to search whether email id exist in real world or not...Did some testing and it works. Is it possible to make similar web services and use it in my application? because i am not sure till what date this web services will work.
View 4 Replies
Oct 14, 2010
I was wondering how I would develop a page that allowed a user to type something into a text box that would show up in a label as they typed. I was looking for this online and found a few options but none of them worked. They included JavaScript, Ajax, and using the text box is onTextChanged command. For an example I need something similar to VistaPrint.
View 1 Replies
