C# - Real-Time Database Update At Specified Time
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
Similar Messages:
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
Feb 1, 2010
I need to do an update a field in database every x minutes. ie: a person login and I need to update a field related to they every X minutes until the value reach a value. Like this, this person start a count event from 1 to 10, they log off the web, but this count must remain countting until reachs 10, 1 by 1 every 7 minutes. I cannot do a SQL Job. Should I User a System.Timer??? Should I record the time and value of the last update, when the person log in I cauculate and update the value??
View 4 Replies
Feb 11, 2011
I need to display the real time data in the label.
Explain In detail:
The camera is counting the people and store the counted value in database every minute.
so i need to pick the data and display it same on the screen. There are lot of cameras counting. So i need to take camera number and display respective count.
Camera NUmber
Counted Value
1
Label1(Display realtime data here)
2
Label2
View 3 Replies
Oct 20, 2010
This is the sqlDateTime overflow problem again. Background. As I'm sure you know dates must be between 1/1/1753 and 12/31/2999. If you have an empty date field, it throws and exception. So I created a function (below) that solve the problem when attempting to update or insert a record with a date field. Works great.
Public Shared Function MakeDateField(ByVal pasDate As String) As Nullable(Of DateTime)
If IsDate(pasDate) Then
Try
If pasDate <= System.DateTime.MinValue Then
Return Nothing
Else
Return CType(pasDate, DateTime)
End If
Catch ex As NullReferenceException
Return Nothing
End Try
Else
Return Nothing
End If
End Function
So I thought about using a time field. I have the field, have the validator in place and then attempted to test the page. It resulted in my least favorite error message "sqlDateTime overflow".
I can think of several workarounds like adding a date or a fixed date to the time field, or converting it to a string. Each of these is problematic.
IS THERE A BETTER WAY TO UPDATE/INSERT TIME FIELDS.
View 2 Replies
Mar 11, 2010
I have a gridview on my page. I have a checkbox in each row of this gridview. For each checkbox in the gridview, I'd like to update my table accordingly, but I don't want them to have to hit a submit button every time they check the checkbox. I want them to check all the boxes they need to and at the end, they should hit one submit button.
View 12 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
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
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
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
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
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