StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODay Change Update Problem
text
Body
copied!<p><strong>C# - Winforms - SQL Server</strong></p> <p>i am building an application which displays some data on the screen of the current day which it gets from the database... the application is like a desktop widget so the data is always visible on the desktop</p> <p>the <strong>scheme</strong> i implemented is</p> <p>when user commits some change to the data, after the update query i call the "update display" function... and the new data is retrieved... </p> <p>by doing so i don't have too check constantly/periodically for changes in the database and data on the display is always current.. this sort of becomes <strong>PUSH</strong> technology</p> <p>now it keeps track of the data in the database for every day but only today's data is displayed... and when the program starts (manually\system start-up), it checks the date and </p> <ul> <li>if the record of the current day doesn't exist, it creates it and start display which can be later modified</li> <li>if the record exists then it just simply start display and there are interfaces available for modifying data</li> </ul> <p>now the problem is</p> <p><strong>If the PC is running & Application is running at 12:00 pm and the date changes... There is no technique to check that :</strong></p> <ul> <li>the day has changed and new record has to be created in database and the display needs to be refreshed</li> </ul> <p>now i can continuously check via loop for the date change and solve my problem but i would love if there is a better option...</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload