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.
I have a chart to display the percentage of available time for a machine, but it won't display all the labels. It will only display a select few, spread out evenly apart but I need it to show ALL of them. Here is how it's set up, however, I don't know what I would change in order for it to display all labels: [Code]....
I have a Table (in SQL Server) that is being updated roughly every minute or so with new records being inserted from various sources. The number of records inserted in this duration varies from a few records up to dozens of new records. I am using an update panel to rebind my data every minute to keep the GridView current. Now that I have the data refreshing I am looking for a better solution than reloading the data every minute. how to best keep my GridView up to date? Here is what I would like to accomplish:
1. Load the GridView and refresh the contents every minute. (60 second intervals)
2. When the GridView is refreshed every minute I would like to append only the new records to the existing grid, rather than bringing back the entire result set with each round trip to the database.
3. I would like a visual cue to identify the rows that have been inserted into the GridView. If new rows were to flash/flicker with a background color (yellow) that would be ideal.
Am I even using the correct control for displaying real time data, or are their other options? I essentially am looking to find the preferred method of displaying data that is being updated in real time in a web application. I'm hoping there is a solution involving AJAX but I haven't been able to find much on The Google. I am open to changing anything and everything about my approach -- this is largely a learning exercise. For testing purposes I am currently using LinqDataSource in conjunction with a GridView in an UpdatePanel being refreshed by a Timer control every 60 seconds. Informational: I have also started playing with the [URL] in place of the Timer control. However, for the purposes of this example I would be content to achieve the desired behavior using native controls as I have described them above.
I am using a repeater control, and in that one of the item, displays a time value that it retrieves from a database, the issue now is, that i want the data to get processed eg, todays date [ minus ] the date that was retrieved from the database. How can i go about this?
I am expecting to use the vb code behind to process the data, and then display it in the repeater control pragmatically for each corresponding record that is displayed.
I am trying to build a site that will display a word ("Synset" in my code) from a "function call", (ultimately the word will come from another database but I'm ignoring that part for now). The user will click one of 4 radio buttons deciding if the word is "positive", "negative", "neutral", or "can not be determined". Then the user clicks "Save" the word is saved a MS SQL database, the function is called displaying a new word and the process is repeated.
So far I have been able to get this to mostly work by using the code below. The problem is that the function is called and the correct word displayed when the page loads the first time, when I click a radio button and then the "Submit" button, the word and value from the radio button are saved to the database but then no new word is displayed. The text just disappears. The new word is created, as I can see that new words are saved to the database when i click submit.
I'm thinking the issue might be because I'm binding the text attribute of the label I'm using to display the word to the sqldatasource, because it's probably trying to display the text from the database?
I've tried putting the code that gets and displays the new word in FormView1_PageIndexChanging() and submitButton_Click() and neither work.
I've tried to just call Response.Redirect("Default.aspx") in submitButton_Click() and this displays the word but nothing is saved to the database.
I need to build a system which needs to show data on almost near real time basis from a MSMQ data source and this sould be showin in image with a circle as to where the incident occurs.
This is the description given.
The position of the Incident relative to the 123 mark is requested to be represented on a circular concentration diagram .
The algorithm will have to export the location of each incident relative to the 123 mark in polar coordinates (r,θ) and translate this position to the 'master image' coordinate system that will display Incident location.
I have two questions.
1. How can i show the data in an Image and also please point me to any material which might help me with the same.
2. How do i show almost real time data from a MSMQ data source and also how do i architect the same for performance.
I have created a web form where users input there details and submit it to an acess database. I also want the current data and time of there submition to be stored into the database along with the other information. I was thinking about making the time and data displaying in a lable or textbox and submit the the values within them into the database. I have been looking around the internt on how to do this but I couldn't get any of the examples I have tried working. Is there another way to create this funnctionality.
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.
I am trying to insert "Date" and "Time" in database table (both are separate columns) using below code:
string query = "Insert into tempTable(List_Id, Date, Time) VALUES('" + lblId.Text + "', @Date, @Time)"; SqlCommand cmd = new SqlCommand(query, connection); connection.Open(); TimeSpan time = new TimeSpan(); time.ToString(); cmd.Parameters.AddWithValue("@Date", Convert.ToDateTime(DateTime.Now.ToShortDateString())); cmd.Parameters.AddWithValue("@Time", Convert.ToDateTime(DateTime.Now.ToString("HH:mm:ss"))); cmd.ExecuteNonQuery(); connection.Close();
Above record is inserted in DB like below:In Date column: 12/29/2014 12:00:00 AMIn Time column:12/29/2014 5:30:46 PMDatatype for "Date" and "Time" column is "datetime"I want that: as I save the Date and Time in DB table, it should display same date and same time what is saved in DB table not current date and time.I tried below code to fetch saved records from table, after inserting Date and Time in DB:
string query2 = "Select Date, Time where Id='" + itemId + "'"; SqlCommand cmd2 = new SqlCommand(query2, connection); connection.Open(); SqlDataAdapter da = new SqlDataAdapter(query2, connection); DataTable dt = new DataTable(); da.Fill(dt); lblDate.Text = DateTime.Parse(dt.Rows.ToString()).ToString("dd-MM-yyyy"); lblTime.Text = DateTime.Parse(dt.Rows.ToString()).ToString("HH:MM tt");
But currently it is giving me below output : Date:29-12-2014Time:18:04 PM (current time)..
Why its showing current date time in place of saved record ??
I want label to display limited text say 20 char even the data it retrieve from database may be more than 20 char.. like in gmail,we see message body limited when we click it display whole message..how is that possible...?
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?
I have to display data (names) in a random order on the website. The data is stored in a MS Access database. The names must be displayed in a GridView and DataList in different places. I have created a query in MS Access "zorder: Rnd([MarinaAccommodation]![ID])" which works fine in MS Access giving me a different order each time.
The problem is that when I try run it on the website the order remains the same, it does not change each time the page is loaded.