Dates calculation in SQL

SELECT GETDATE() AS NOW, GETDATE()-(1) AS YESTERDAY, GETDATE()-(0.04166666) AS PREVIOUS_HOUR, GETDATE()-(0.0006944444) AS PREVIOUS_MINUTE, GETDATE()-(0.000011574) AS PREVIOUS_SECOND

Anti-reverse engineering guide

CodeProject Article

Subprocess in WPF

Ver Articulo MSDN
Ver Articulo Blog "escarbandocodigo"

Convert message to morce code

Dictionary lst = new Dictionary();

private void Form1_Load(object sender, EventArgs e)
{
lst.Add("A", "11");
lst.Add("B", "12");
lst.Add("C", "13");
lst.Add("D", "14");
lst.Add("E", "15");
lst.Add("F", "21");
lst.Add("G", "22");
lst.Add("H", "23");
lst.Add("I", "24");
lst.Add("J", "25");
lst.Add("K", "31");
lst.Add("L", "32");
lst.Add("M", "33");
lst.Add("N", "34");
lst.Add("O", "35");
lst.Add("P", "41");
lst.Add("Q", "42");
lst.Add("R", "43");
lst.Add("S", "44");
lst.Add("T", "45");
lst.Add("U", "51");
lst.Add("V", "52");
lst.Add("W", "53");
lst.Add("X", "54");
lst.Add("Y", "55");
lst.Add("Z", "61");
lst.Add("1", "62");
lst.Add("2", "63");
lst.Add("3", "64");
lst.Add("4", "65");
lst.Add("5", "66");
lst.Add("6", "71");
lst.Add("7", "72");
lst.Add("8", "73");
lst.Add("9", "74");
lst.Add("0", "75");
lst.Add(".", "77");
lst.Add(",", "85");
lst.Add("-", "86");
lst.Add("?", "87");
lst.Add("!", "88");
lst.Add("_", "95");
lst.Add("(", "96");
lst.Add(")", "97");
lst.Add("Ñ", "98");
lst.Add(" ", "99");
////codigo similar al morce
//lst.Add("A", "-----·");
//lst.Add("B", "----·-");
//lst.Add("C", "----··");
//lst.Add("D", "---·--");
//lst.Add("E", "---·-·");
//lst.Add("F", "---··-");
//lst.Add("G", "---···");
//lst.Add("H", "--·---");
//lst.Add("I", "--·--·");
//lst.Add("J", "--·-·-");
//lst.Add("K", "--·-··");
//lst.Add("L", "--··--");
//lst.Add("M", "--··-·");
//lst.Add("N", "--···-");
//lst.Add("O", "--····");
//lst.Add("P", "-·----");
//lst.Add("Q", "-·---·");
//lst.Add("R", "-·--·-");
//lst.Add("S", "-·--··");
//lst.Add("T", "-·-·--");
//lst.Add("U", "-·-·-·");
//lst.Add("V", "-·-··-");
//lst.Add("W", "-·-···");
//lst.Add("X", "-··---");
//lst.Add("Y", "-··--·");
//lst.Add("Z", "-··-·-");
//lst.Add("1", "-··-··");
//lst.Add("2", "-···--");
//lst.Add("3", "-···-·");
//lst.Add("4", "-····-");
//lst.Add("5", "-·····");
//lst.Add("6", "·-----");
//lst.Add("7", "·----·");
//lst.Add("8", "·---·-");
//lst.Add("9", "·---··");
//lst.Add("0", "·--·--");
//lst.Add(".", "·--·-·");
//lst.Add(",", "·--··-");
//lst.Add("-", "·--···");
//lst.Add("?", "·-·--·");
//lst.Add("!", "·-·--·");
//lst.Add("_", "·-·-·-");
//lst.Add("(", "·-·-··");
//lst.Add(")", "·-··--");
//lst.Add("Ñ", "·-··-·");
//lst.Add(" ", "------");
}


private void btConvert_Click(object sender, EventArgs e)
{
textBox1.Text = textBox1.Text.ToUpper();
string s = textBox1.Text;
string t = string.Empty;

for (int i = 0; i <= s.Length - 1; i++)
{
if (lst.ContainsKey(s[i].ToString()))
{
t += lst.First(p => p.Key == s[i].ToString()).Value.ToString();
}
}

textBox1.Text = t;
}

private void btUnConvert_Click(object sender, EventArgs e)
{
string s = textBox1.Text;
string t = string.Empty;
int wordlen = lst.FirstOrDefault().Value.Length;

for (int i = 0; i <= (s.Length/wordlen) - 1; i++)
{
if (lst.ContainsValue(s.Substring(i * wordlen, wordlen)))
{
t += lst.First(p => p.Value == s.Substring(i * wordlen, wordlen)).Key.ToString();
}
}

textBox1.Text = t;
}

Export database to excel using MS Excel

//Add Reference (COM) Microsoft Office List 12.0
//Add Reference (.NET) Microsoft.Office.Interop.Excel 12.0
using Excel = Microsoft.Office.Interop.Excel;
using System.Reflexion;
using System.IO;
using System.Diagnostics;
using System.Data.OleDb;

try
{
Excel.Application xlsApp = new Excel.Application(); //Create XLS
xlsApp.DisplayAlerts = false; //Block Alerts
Excel.Worksheet xlsSheet; //Declare Sheet
Excel.Workbook xlsBook; //Declare Workbook
xlsApp.Visible = false; //Turn off the aplicación
xlsBook = xlsApp.Workbooks.Add(true); //Add Workbook
xlsSheet = (Excel.Worksheet)xlsBook.ActiveSheet; //Add Sheet

//TABLE HEADER
for (irow = 0; irow < 1; irow++)
{
for (icol = 1; icol < Lista.Tables[0].Columns.Count; icol++)
{
xlsSheet.Cells[1, icol] = Lista.Tables[0].Columns[icol].ColumnName;
MessageBox.Show(Lista.Tables[0].Rows[irow].ItemArray[icol].ToString());
}
}


//TABLE ROWS
for (irow = 1; irow < Lista.Tables[0].Rows.Count; irow++)
{
for (icol = 1; icol < Lista.Tables[0].Columns.Count; icol++)
{
xlsSheet.Cells[irow + 1, icol] = Lista.Tables[0].Rows[irow - 1].ItemArray[icol - 1].ToString();
MessageBox.Show(Lista.Tables[0].Rows[irow].ItemArray[icol].ToString());
}
}

xlsSheet.Columns.AutoFit(); //Resize columns
xlsApp.Visible = true;
try
{
xlsApp.SaveWorkspace(); //Save XLS
}
catch
{ }
xlsApp.Quit();

MessageBox.Show("Insert Terminado");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

Export database to excel without MS Excel

try
{
if (File.Exists(@"c:\exportado.xls"))
File.Delete(@"c:\exportado.xls");

using(System.Data.OleDb.OleDbConnection con = new System.Data.OleDb.OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:\\exportado.xls';Extended Properties='Excel 8.0;HDR=Yes'"))
using (System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand("", con))
{
cmd.Connection = con;
con.Open();

string sql = "CREATE TABLE [Precios] ( columna1 VARCHAR(100) )";
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();

//sql = "UPDATE [Precios$A1:A1] SET columna1 = '12345678'";
sql = "INSERT INTO [Precios] (columna1) VALUES('12345678')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();

con.Close();
}

MessageBox.Show("Insert Terminado");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}

Creating temporal table, inserting and pivoting

--CREATING TEMPORAL TABLE
DECLARE @Tabla TABLE (
FName VARCHAR(25),
School VARCHAR(15),
Team VARCHAR(15),
Points INT
)

--INSERTING VALUES
INSERT INTO @Tabla VALUES ('Pablo','OLOF','MEN',5)
INSERT INTO @Tabla VALUES ('Pedro','OLOF','MEN',5)
INSERT INTO @Tabla VALUES ('Ruby','OLOF','WOMEN',5)
INSERT INTO @Tabla VALUES ('Ruby','OLOF','WOMEN',5)
INSERT INTO @Tabla VALUES ('Paco','AMAT','WOMEN',5)

--VIEW
SELECT * FROM @Tabla

--PIVOTING VALUES
SELECT School,[MEN],[WOMEN]
FROM (SELECT School,Team,Points FROM @Tabla) As T
PIVOT (SUM(Points)
FOR Team IN ([MEN],[WOMEN])) As PivotT

SELECT FName As FullName,School,[MEN],[WOMEN]
FROM (SELECT Fname,School,Team,Points FROM @Tabla) As T
PIVOT (SUM(Points)
FOR Team IN ([MEN],[WOMEN])) AS PivotT