How to get the Windows 10 Creators Update

Microsoft is gearing up to roll out the Windows 10 Creators Update to everyone starting on April 11th. If the update is not yet available available for you under Settings -> Update & security -> Check for updates then you can get it manually.   Microsoft also offers the “Windows 10 Update Assistant,” which is a tool designed… Read More »

5 cents hint – c# split text by tab delimiter

if you ever need to split text file lines or other strings by tab delimiter then it it is easy :  

and done !

5 cents hint – Dump and restore MySQL database on WAMP server

For backing up and restoring MySQL database on WAMP server no fancy tools are needed. Out of the box command line tools will do all you need: Dump database : [path to wamp mysql bin directory]\bin\mysqldump -u[user]-p[password] [database name] > [destination file] For example C:\wamp64\bin\mysql\mysql5.6.17\bin\mysqldump -uroot -p mydatabase > c:\temp\mydatabase.sql   And restoring same thing back: [path to wamp… Read More »

DevExpress XtraReports – enable custom SQL for enduser report designer in code

By default DevExpress XtraReports  enduser report designer allows only creating SQL statements using Query Builder. Custom SQL statements are security risk and because of that they are not allowed by default. If you know what you are doing  and want to use custom SQL  statements then they can be enabled on Report Designer form. See closer documentation at DevExpress site.… Read More »

How to disable Microsoft Compatibility Telemetry

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 »

c# – accessig application configuration file using ConfigurationManager

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.  

To add or update use AddUpdateAppSettings:

For read use ReadSetting. In this sample we provide also default values so in case… Read More »

5 cent hint – Unix timestamp to c# datetime

If you need to covert Unix timestamp  to DateTime then here it is:  

Update: DateTime to Unix timestamp