June 2009 – Knowledgebase

Loosing records on left outer join in T-SQL Microsoft SQL Server 2008

25 June, 2009 Roel van Lisdonk 0 Comments 0 categories

If you do a left outer join and you loose records of the “left” table, this might be caused by the where clause: This query will result in all records of table Production.HourGroup, only Production.HourGroup

Formatting a date to a specific string (like dd-MM-YYYY) in Microsoft Excel VBA

24 June, 2009 Roel van Lisdonk 0 Comments 0 categories

If you want to format a date to a specific date format, like dd-MM-YYYY in Microsoft Excel VBA, use: Dim specificFormatedString as String specificFormatedString = Format(Date,"DD-MM-YYYY")

How to resolve collation conflicts in Microsoft SQL Server 2008 stored procedure

24 June, 2009 Roel van Lisdonk 0 Comments 0 categories

To resolve collation conflicts like: Msg 468, Level 16, State 9, Line 135 Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. You should surround the ‘=’ with collate database_default

Add a WebService reference to a Microsoft Office Excel sheet

24 June, 2009 Roel van Lisdonk 0 Comments 0 categories

> Start you’re webservice > Start Microsoft Office Excel > Show the Control Toolbox toolbar: > View > Toolbars > Control Toolbox > Enter Design mode by clicking the “Design Mode” button on the Control

SketchPath XPath query tool

22 June, 2009 Roel van Lisdonk 0 Comments 0 categories

If you want to know the XPath query to an element of a XML file, but you’re new to XPath, you can use the Freeware tool: SketchPath to get show the XPath query. In mine

To compare two string, ignoring case, use string.Compare and not string.ToLower in C#

22 June, 2009 Roel van Lisdonk 0 Comments 0 categories

If you want to compare two string, ignoring case, use string.Compare and not string.ToLower, for performance reasons. if (string.Compare(stringA, stringA, true) == 0){ // Strings are equal (case ignored)}

How to use the ReportViewer.Drillthrough event in ASP .NET 2.0

22 June, 2009 Roel van Lisdonk 0 Comments 0 categories

If you have created a Microsoft Reporting Server report with a drillthrough. The user can Navigate to another report by clicking a link. This will fire the ReportViewer.Drilltrhough event on a ReportViewer control in ASP

Find largest files and folders with freeware tools like JDiskReport and TreeSize

19 June, 2009 Roel van Lisdonk 0 Comments 0 categories

Find largest files and folders with freeware tools like JDiskReport and TreeSize Download TreeSize Free at: http://www.jam-software.com/freeware/TreeSizeFree.zip Download JDiskReport at: http://www.jgoodies.com/downloads/index.html Found at: http://www.raymond.cc/blog/archives/2007/04/30/find-out-what-files-and-folders-are-taking-up-hard-drive-spaces/

Simplest way to detect session timeout in an asp .net 2.0 web application in C#

18 June, 2009 Roel van Lisdonk 0 Comments 0 categories

The simplest way to detect if a session timeout occurred in an asp .net 2.0 web application use Global.asax Session_Start and Page_Load event. see: http://blogs.msdn.com/nikhiln/archive/2007/06/21/detecting-session-timeout-in-asp-net-2-0-web-applications.aspx Using Session["xxx"] value to determine the session timeout: This

Convert dutch string to DateTime and DateTime to dutch String with TryParseExact in C#

18 June, 2009 Roel van Lisdonk 0 Comments 0 categories

To convert a dutch string to DateTime and a DateTime to a dutch string in C# use the class: public class DateTimeHelper { /// <summary> /// Returns a DateTime object if conversion from dutch string

Month: June 2009