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:

VS 2010 - Update Form In Real Time

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

Architecture :: Database Update Table Field Time To Time

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

Web Forms :: Display Real Time Data In Label Using MS Access Database?

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

Forms Data Controls :: Asp 3.5 Time Field In FormView / Update/insert Time Fields?

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

Forms Data Controls :: Gridview With Checkbox Update One Time In A Button Click Not Every Time?

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

Real Time Progress Bar

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

Add Real Time MVC In Web Application

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

C# - Build Real Time Program

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

Real Time Input Preview

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

Put Real Time Features Into Website Using PHP

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

AJAX :: Looking For A Real Time Example For Webservice

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

C# - Real-time Updates Like Twitter?

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

.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

Databases :: Real Time Web Application_backend Sql?

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

How To Show The Real Time Path In A Webform

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

Ajax - Implement Real Time Updates?

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

Use Real Time Configurations In Application Without Restarting It?

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

File Upload With Real Time Progress Bar

Apr 13, 2010

need ASP.NET File Upload with Real-Time Progress Bar

View 13 Replies

Ajax - What's Faster For Real - Time Web Program

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

AJAX :: Fileupload With Real Time Progress Bar?

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

Architecture :: Facebook-like Real-time Notification?

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

WCF / ASMX :: Usage Of WebService In Real Time?

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

Procedure Of Doing Project In Real Time Environment?

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

Web Forms :: Real Time Notification With SignalR?

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







Copyrights 2005-15 www.BigResource.com, All rights reserved