jQuery tip: Add an element as hidden and show on click.

0 Comments

If you want to add an element initially as hidden, just use CSS display: none. In the onclick event, use jQuery to show the element.   TIP: Don’t use CSS visibility: hidden, because this will

How to convert a JSON string, containing UTC datetime to a local server datetime string in C#

0 Comments

using Microsoft.VisualStudio.TestTools.UnitTesting; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Diagnostics; using System.IO; using System.Text.RegularExpressions; namespace Research.Rli.Tests { [TestClass] public class ResearchTester { [TestMethod] public void Test() { string json = @"{""date"":""2013-04-10T14:52:43.207Z""}"; Dto dto = JsonConvert.DeserializeObject<Dto>(json);

Installing SSIS support in Microsoft Visual Studio 2012

0 Comments

As of 5-mrt-2013, Microsoft Visual Studio 2012 supports SSIS projects by installing Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012   You can download Microsoft SQL Server Data Tools – Business

How to left pad a string in T-SQL (SQL Server 2012)

0 Comments

If you want to left pad a string in T-SQL in Microsoft SQL Server 2012, you can use the format function: To get the current hour padded with, zeros use: declare @CurrentDateTime datetime = '2013-04-03