Roel van Lisdonk – Page 105

When the Microsoft SQL Server Import and Export wizard is not enough

30 March, 2009 Roel van Lisdonk 0 Comments 0 categories

When importing data from Microsoft Access to Microsoft SQL Server you can use the Microsoft SQL Server Import and Export wizard, but some times you can not use this wizard because values in a column

Microsoft SQL Server Profiler 2005 filter on database name

27 March, 2009 Roel van Lisdonk 0 Comments 0 categories

If you want to filter you’re Microsoft SQL Server 2005 profiler trace on database name: Check the “Show all columns” checkbox on the “Events Selection” tab. Then click on the column filters… button, you can

Microsoft SQL Server 2005 Maintenance Plan Wizard

26 March, 2009 Roel van Lisdonk 0 Comments 0 categories

This post describes the way I used the Microsoft SQL Server 2005 Maintenance Plan Wizard. When none default values are used, they will be listed below. > To create a Microsoft SQL Server 2005

IIS 6 versus IIS 7 dialog comparison

25 March, 2009 Roel van Lisdonk 0 Comments 0 categories

I was looking for the "Change Execute Permissions" in IIS 7. In IIS 6 you would go to Web site > Properties > Home Directory Tab: But I could not find it in IIS 7.

Paging a ASP .NET 2.0 GridView with a LLBLGEN datasource

18 March, 2009 Roel van Lisdonk 0 Comments 0 categories

If you want to allow paging in a ASP .NET 2.0 GridView that uses a LLBLGEN datasource: – set AllowPaging = True – Create the PageIndexChanging event /// <summary> /// Change the page of the

Setting the GridView PagerStyle height in ASP .NET 2.0 with C#

18 March, 2009 Roel van Lisdonk 0 Comments 0 categories

When you set the PagerStyle Height property this will no allways set the correct height of the PageStyle. <asp:GridView ID="Test"> <PagerStyle Height="10px" /> </asp:GridView> To set the correct height use a CSS class: <asp:GridView ID="Test">

Delete IIS6 or IIS7 virtual directory on a website with hostheader, with C# and NANT

16 March, 2009 Roel van Lisdonk 0 Comments 0 categories

using System; using System.DirectoryServices; using System.Globalization; using Ada.Configurator.Common; using NAnt.Core.Attributes; using NAnt.Core; namespace AdaNantTasks { /// <summary> /// Delete an IIS virtual directory on a website with a hostheader. /// </summary> [TaskName("deleteVirtualDirectoryTask")] public class DeleteVirtualDirectoryTask

Create IIS6 or IIS7 virtual directory on a website with hostheader, with C# and NANT

16 March, 2009 Roel van Lisdonk 2 Comments 0 categories

using System; using System.DirectoryServices; using System.Globalization; using Ada.Configurator.Common; using NAnt.Core.Attributes; using NAnt.Core; namespace AdaNantTasks { [TaskName("createWebSite")] public class CreateWebsiteTask : Task { public NantLogger logger = new NantLogger(); private string m_server; [TaskAttribute("server", Required = true)]

Technology Summary

12 March, 2009 Roel van Lisdonk 0 Comments 0 categories

This post is just a note for me to track technologies. JQuery

Dump IIS info with C#