Tag Archives: c#

Devexpress MVC Chart Axis label to format number by M (million) or K (thousand)

Often it is enough to show on chart axis label general indicative number instead of full precision figure. Also long figures take a lot of precious space. So instead 890 152 000 the 890M would do fine. So how to do it in case of DevExpress Chart control MVC extension. Unlike in case of Windows… Read More »

5 cents hint – c# + MSSQL getting last inserted id and what about bigint

Getting last inserted Id value is quite common needed task. When using SqlCommand it is not part of the class. Things are getting even trickier if the value must be Int64. But have no fear, it is not tricky. Just define in SqlCommand two sql statements:- first of insert and second for selecting back inserted… Read More »

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

DateTime startDate = new DateTime(2017, 1, 1);
DateTime endDate = DateTime.Today;

// looping between date range    
while (startDate < endDate)
{
 // ... to the "thing"
 startDate = startDate.AddDays(1);
}

DateTime startDate = new DateTime(2017, 1, 1);

DateTime endDate = DateTime.Today;

// looping between date range

while (startDate < endDate)

{

// ... to the "thing"

startDate = startDate.AddDays(1);

}

Mission completed.

Visual Studio 2015 – updating nuget packages

Sometimes, for example in case of updating MVC 4 projetc to MVC 5, some nuget packages will have wrong versions or might be missing from references. In this case command Update-Package -reinstall come handy. In Visual Studio open from menu Tools -> NuGet Package Manager -> Package Manager Console. In console execute next command for for… 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 :

   // 9  ==> \t 
   // 10 ==> \n
   // 13 ==> \r

   char sep = Convert.ToChar(9);
   string[] splitContent = line.Split(sep);

// 9 ==> \t

// 10 ==> \n

// 13 ==> \r

char sep = Convert.ToChar(9);

string[] splitContent = line.Split(sep);

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.

        public static string ReadSetting(string key, string defaultValue = "Not Found")
        {
            var appSettings = ConfigurationManager.AppSettings;
            string result = appSettings[key] ?? defaultValue;
            return result;
        }

        public static void AddUpdateAppSettings(string key, string value)
        {
            var configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
            var settings = configFile.AppSettings.Settings;
            if (settings[key] == null)
            {
                settings.Add(key, value);
            }
            else
            {
                settings[key].Value = value;
            }
            configFile.Save(ConfigurationSaveMode.Modified);
            ConfigurationManager.RefreshSection(configFile.AppSettings.SectionInformation.Name);
        }

public static string ReadSetting(string key, string defaultValue = "Not Found")

{

var appSettings = ConfigurationManager.AppSettings;

string result = appSettings[key] ?? defaultValue;

return result;

}

public static void AddUpdateAppSettings(string key, string value)

{

var configFile = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);

var settings = configFile.AppSettings.Settings;

if (settings[key] == null)

{

settings.Add(key, value);

}

else

{

settings[key].Value = value;

}

configFile.Save(ConfigurationSaveMode.Modified);

ConfigurationManager.RefreshSection(configFile.AppSettings.SectionInformation.Name);

}

To add or update use AddUpdateAppSettings:

AddUpdateAppSettings("mysql_host", "localhost");
AddUpdateAppSettings("mysql_port", "3306");
AddUpdateAppSettings("mysql_user", "root");
AddUpdateAppSettings("mysql_password", "");
AddUpdateAppSettings("mysql_db", "mydb");

AddUpdateAppSettings("mysql_host", "localhost");

AddUpdateAppSettings("mysql_port", "3306");

AddUpdateAppSettings("mysql_user", "root");

AddUpdateAppSettings("mysql_password", "");

AddUpdateAppSettings("mysql_db", "mydb");

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

C# creating table in Access database and “Data type mismatch” error

It is easy to create Access database tables in code in C#. But sometimes you might end with error Data type mismatch The problem of the mismatch in DataColumn type is due to the OleDbType assigned. Adding new column takes for second parameter the datatype. There are many types available to cover different data connections … Read More »

c# – Windows File Explorer extension for creating url shortcuts – Part 2

In previous post we stated extension for creating url shortcuts. Now it is time to create actual file explorer menu items and get the basics working. First let’s create small class what will deal with needed registry entries. Creating contect menu items is quite simple, just two entries in registry.

using Microsoft.Win32;
using System.Windows.Forms;

namespace UrlExtension
{
    public class UriExtensionUtils
    {
        public static void AddOption_ContextMenu()
        {
            RegistryKey _key = Registry.ClassesRoot.OpenSubKey("Directory\\Background\\Shell", true);
            RegistryKey newkey = _key.CreateSubKey("Add URL Shortcut");
            RegistryKey subNewkey = newkey.CreateSubKey("command");
            string appDirectory = Application.ExecutablePath.Replace("\\", "\\\\");
            
            subNewkey.SetValue("", appDirectory);
            subNewkey.Close();
            newkey.Close();
            _key.Close();
        }


        public static void RemoveOption_ContextMenu()
        {
            RegistryKey _key = Registry.ClassesRoot.OpenSubKey("Directory\\Background\\Shell\\", true);
            _key.DeleteSubKey("Add URL Shortcut");
            _key.Close();
        }
   }
}

using Microsoft.Win32;

using System.Windows.Forms;

namespace UrlExtension

{

public class UriExtensionUtils

{

public static void AddOption_ContextMenu()

{

RegistryKey _key = Registry.ClassesRoot.OpenSubKey("Directory\\Background\\Shell", true);

RegistryKey newkey = _key.CreateSubKey("Add URL Shortcut");

RegistryKey subNewkey = newkey.CreateSubKey("command");

string appDirectory = Application.ExecutablePath.Replace("\\", "\\\\");

subNewkey.SetValue("", appDirectory);

subNewkey.Close();

newkey.Close();

_key.Close();

}

public static void RemoveOption_ContextMenu()

{

RegistryKey _key = Registry.ClassesRoot.OpenSubKey("Directory\\Background\\Shell\\", true);

_key.DeleteSubKey("Add URL Shortcut");

_key.Close();

}

To handle registration and… Read More »

c# – Windows File Explorer extension for creating url shortcuts – Part 1

I like to save interesting websites as file system shortcuts in OneDrive directiory. It works nice using New->Shortcut in file explorer, but there is room for improvement. In first part we will look how to fetch website info and create url shortcut and in second will convert prepared code to file explorer extension. Development is easier using… Read More »