Show icon My PC in Windows 8
Surely many of you were surprised that Windows 8 does not bring your «My Computer» icon on your desktop or menus. Then I leave the steps of how to do it. First go to...
Autor: Victor Riquelme
Debug Problems – ContextSwitchDeadlock –
While debugging an application written in C #, I found the following error, Context «ContextSwitchDeadlock». The process waits to load a file in txt. ContextSwitchDeadlock detected Message: The CLR could not make the COM...
Format Chilean Rut in Postgresql
Here is a very practical method to format Chilean Rut (xx.xxx.xxx-x) The only requirement is to have the following function previously.PadIndex Postgresql CREATE OR REPLACE FUNCTION public.fn_format_rut(var_rut varchar(12)) RETURNS varchar(12) as $ declare v_cont...
PatIndex Postgresql
As you may already notice postgresql does not contain the function patidex, it is for this reason that we bring them to you next: CREATE OR REPLACE FUNCTION patindex(pattern VARCHAR, expression VARCHAR ) RETURNS...
First letter of each word in uppercase Postgresql
Unlike other database engines Postgresql provides us with the initcap() function to apply capital letter to our chains. Here is an example: SELECT initcap(‘HELLO WORLD’); Result: Hello World I hope it’s usefull
Primera letra de cada palabra en mayúscula Postgresql
A diferencia de otros motores de bases de datos Postgresql nos provee de la función initcap() para aplicar letra Capital a nuestras cadenas. A continuación un ejemplo: SELECT initcap(‘HOLA MUNDO’); Resultado: Hola Mundo Espero...
Function to execute forms from other solutions C #
If someday you encounter the problem of wanting to create a system with many modules and choose to separate each module in a different project, you will surely need to execute the forms and...
How to add double quotes in a string C # and Vb.Net
The following example shows how to save the word «Hello World» including double quotes in a string. C#(use prefix \) string texto =»»; texto = «\»Hello World\»»; VB.NET(Two single quotes together «») Dim texto...
Get and set .ini file values c #
Suppose you have an .ini file with the following information: [Data] Count=5 The following functions will allow you to obtain and modify your configuration file in a simple way: using System.Runtime.InteropServices; using System.Text; namespace...
Get data from a table in MySQL
In MYSQL there are several methods to know if a table exists or get information from the table directly from the SHEMA, one way is as follows: SELECT TABLE_SCHEMA AS BD, TABLE_NAME AS NOMBRE_TABLA,...
