Category Archives: Programming

5 cents hint – c# looping between date range

If you need looping between date range then there are many ways to solve this task. Here is one simple code snippet

Mission completed.

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 !

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 »

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