Blog
How to get a list of all timezones and their UTC Offsets in C# (With Sample Code)
If you are writing an international website, it is better to show timestamps to the users in their local timezone. Not everybody can easily translate time from UTC to their local time. Displaying time in a different timezone is confusing to the users and can lead to many misunderstandings. That's why you may want to give the user a choice to select timezone and then make them happy by displaying all timestamps in their local timezones.
But how do you get the timezones list? Here is a little C# code example that shows how to display UTC offset and user-friendly timezone labels:
SQLite vs SQL Server Comparison
SQLite is a tiny database that is specifically designed for embedded use. It is a single-file database that is deployed side-by-side with your application. If you have to write an application that needs just a limited set of database functionality, then a tiny SQLite library has a big advantage over SQL Server of not having any dedicated installer. Basically SQLite is just a simple DLL file that is deployed with the executable of your application. It can be even compiled in your C/C++ application, as SQLLite is distributed in a form of single .c file (called "amalgamation"). Also, SQLite comes completely free of charge.
Ensure Consistency of Stored Data by Using Cyclic Redundancy Check (CRC)
Having data secure is critical for the reliability of the applications. It is very important to have data consistent when managing user's finance, ensuring reliable control of industrial processes, ensuring stable work of medical equipment, etc. But the storage sometimes fails, the transmission lines fail, lastly, there are bugs in the software application. All those factors produce corruption to critical data.
How to kill process by name in Windows using WinAPI?
Sometimes you may need to terminate (kill) a process in Windows. Why may you need this? For example, you have a kiosk and you need some application to be constantly running (the Kiosk GUI), but this application is written not perfectly, it hangs. You cannot make it work better, because it's not you who wrote it. You can write a small helper application that will be checking the status of an application, say, by sending some messages to its window. And if the application window does not respond, your tiny app will just kill the GUI app and restart it.
Leaving sending messages and re-launching applications out of the scope of this small article, let's find out how to actually kill the application.