Knowledgebase – Page 94 – Blog on software engineering

To connect to a Microsoft SQL Server database with “Windows Authentication” from outside the domain use runas /netonly /user:DOMAIN\username

10 June, 2009 Roel van Lisdonk 0 Comments 0 categories

If you have a development VMware image, which is not a member of the domain hosting you’re database, you can still make use of “windows authentication” by running the database script or Microsoft SQL Server

Donwload pictures automatically in HTML e-mail messages or RSS items in Microsoft Outlook 2007

10 June, 2009 Roel van Lisdonk 0 Comments 0 categories

If you want to allow Microsoft Outlook 2007, to download pictures in HTML e-mail messages automatically, follow these steps: 1. Start Microsoft Outlook 2007 2. On the Tools menu, click Trust Center… 3. Click to

How to grant exec rights to all stored procedures in Microsoft SQL Server 2005

9 June, 2009 Roel van Lisdonk 0 Comments 0 categories

Users are in our case always a member of some role. The role is given exec stored procedure rights and db_datareader, db_datawriter rights. Users in the role “TestRole” can select, insert, update, delete data and

“Run as” in Microsoft Windows Vista and Microsoft Windows 2008

9 June, 2009 Roel van Lisdonk 0 Comments 0 categories

To run a program as another user, you can’t right click the program and choose “Run as…” To run a program like the Microsoft SQL Server Mangement Studio 2008 with another user credentials: start >

ASP .NET – How to add javascript script files to you're masterpage

9 June, 2009 Roel van Lisdonk 0 Comments 0 categories

You can’t add javascript script files to you’re page header by using the normal <link> and <script> tags, when you are using masterpages in ASP .NET. You will have to do this in the code

A vision on HTML 5 vs Silverlight and Flash by Tim Heuer

9 June, 2009 Roel van Lisdonk 0 Comments 0 categories

A great article on HTML 5 vs Silverlight and Flash: http://timheuer.com/blog/archive/2009/05/30/google-wave-forces-out-silverlight-flash-ria-platforms.aspx

To add multiple QueryString parameters to the ASP .NET SiteMapNode use &

8 June, 2009 Roel van Lisdonk 0 Comments 0 categories

To add multiple QueryString parameters to the ASP .NET SiteMapNode use & <?xml version="1.0" encoding="utf-8" ?> <siteMap xmlns="http://schemas.microsoft.com/AspNet/SiteMap-File-1.0" > <siteMapNode title="Home" description="Home" url="Default.aspx" > <siteMapNode title="Test Rapport" description="Test Rapport" url="~/Rapporten/ViewReport.aspx?rapport=test&productId=1" /> </siteMapNode> </siteMap>

C# – Use Type.BaseType to get to the private instance fields

8 June, 2009 Roel van Lisdonk 0 Comments 0 categories

I used the Type.BaseType method to get to the private instance fields of a extended Microsoft ReportViewer Control. public object GetParametersArea(ExtendedReportViewer viewer) { return viewer.GetType().BaseType.GetField("m_parametersArea", BindingFlags.Instance | BindingFlags.NonPublic).GetValue(viewer); } You can’t use the bindingflag

Return all rows with TSQL when a Microsoft Reporting Services parameter is null

4 June, 2009 Roel van Lisdonk 0 Comments 0 categories

This examples uses the Microsoft SQL Server 2008 example database AdventureWorks (http://msftdbprodsamples.codeplex.com/) If you want to return all rows of a table when a parameter is null, use the TSQL function isnull: declare @productModelID as

Microsoft Reporting Services exception: rsInvalidReportParameterDependency Forward dependencies are not valid.

4 June, 2009 Roel van Lisdonk 0 Comments 0 categories

Exception: Error 1 [rsInvalidReportParameterDependency] The report parameter ‘productModelID’ has a DefaultValue or a ValidValue that depends on the report parameter “productModelID”. Forward dependencies are not valid. C:\Projects\Temp\Report Project1\Report Project1\Products.rdl 0 0 This error occurs, because