Sometimes you might feel that your Windows 10 is really slow and busy with something unknown. When opening task manager (use for example hotkey Ctrl+Shift+Esc) you might see something like this: Microsoft Compatibility Telemetry (CompatTelRunner.exe) is an integral part of Windows OS system. While it is not a malevolent application, some users find it suspicious… Read More »
If you need to set current date and time as default value then here is the table modification query: ALTER TABLE mytable MODIFY COLUMN mycolumn datetime DEFAULT CURRENT_TIMESTAMP
Using configuration file is pretty straightforward. First add to your application references Assembly System.Configuration. ConfigurationManager provides access to configuration files for client applications, It makes sense to encapsulate configuration settings read and write to special methods. public static string ReadSetting(string key, string defaultValue = “Not Found”) { var appSettings = ConfigurationManager.AppSettings; string result = appSettings[key] ?? defaultValue;… Read More »
If you need to covert Unix timestamp to DateTime then here it is: public DateTime TimestampToDatetime(long timeStamp) { var epoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc); return epoch.AddSeconds(timeStamp); } var date = TimestampToDatetime(1490091991); Update: DateTime to Unix timestamp public static int DateToStamp(DateTime datetime) { var date = new DateTime(1970, 1, 1,… Read More »
Remember when Windows 98 needed a computer costing $1,000+ to run comfortably? Almost 20 years later, the early Microsoft OS runs on a computer that sells for just $25 and that is so small it fits on your wrist. This Raspberry Pi-powered, Windows 98 wristwatch is a project by amateur technology enthusiast 314Reactor. This article… Read More »
If you get after Xamarin update building error “Project cannot build using Android 7.0 (API Level 24 – Nougat) because Your Java version (1.7.0) is too old. You must have at least 1.8 installed. Please install it or set Java Development Kit path for Oracle 1.8+ on Tools->Options->Xamarin->Android Settings menu.” then Install Java SDK version… Read More »