GetFiles, sorted by Creation DateTime, filtered by include file mask and exclude file mask, including subfolders in C#

The “GetFiles” function, returns all files in the given folder, including subfolders, that match the “includeMask”. The result is sorted by the file CreationTime. The function excludes all files that match the “excludeMask”   To call the function: List<FileInfo> files = FileSystemHelper.GetFiles(@”C:\Windows”,”*.*”, “*.exe”, SortOrder.Ascending, SearchOption.AllDirectories);   The function:/// <summary>/// Get …

SSIS package configuration

We have chosen to use a windows environment variable to hold the path to the *.dtsConfig, which is used to configure the *.dtsx package. – Close all open Microsoft Visual Studio 2005 instances (because changing windows environment variables will have nog effect) – Add a Windows Environment Variable: – start …

Remove ExpandedColunCount and ExpandedRowCount when using Microsoft Exel (*.xml) file as template

When you use a Microsoft Excel "*.xml" file as template for generating Microsoft Excel reports, remove the ss:ExpandedColumnCount="1" ss:ExpandedRowCount="1" x:FullColumns="1" x:FullRows="1" from the <Table> tag under the <Worksheet> tag. If you don’t remove these counters a error will occur, because the row and or column count is higher then 1: …

Set text on control with javascript

To set the text on a control with javascript use:   /* Set the text value of the given element. This function assumes this document is defined and not null and has a function getElementById Used by: – */ function SetText(elementId, text) { // Check input values if(IsNullOrUndefined(document)){alert(‘SetText: Object [document] …

Change cursor to hand with CSS, when mouse over a column in a ASP .NET 2.0 GridView

When you want to change the cursor to a hand instead of the default pointer on mouse over, use CSS. In you’re gridview column: <Columns> <asp:TemplateField HeaderText=”Barcode”> <ItemTemplate><span class=”hand”><%# Eval(“Column”)%></span></ItemTemplate> </asp:TemplateField> </Columns> In the header: <style type=”text/css”>    .hand { cursor: pointer; cursor: hand; } /* cross browser hand */</style>   …