all things Sitecore related

Pieter Brinkman

Pieter is Technical Marketing Manager for Sitecore Netherlands and owner of He has more than ten years experience with software developing in multiple programming languages and with different Content Management Systems. Before joining Sitecore Pieter was a lead developer for multiple Sitecore and .Net projects, he joined Sitecore in 2011 as an Solution Architect in The Netherlands, after two years as an Solution Architect he joined the Technical Marketing department. In the role as Techinical Marketing Manager he is responsible for the Global MVP program and the Sitecore technical branding strategy.

You can follow Pieter on twitter: @pieterbrink123 or Google+

Realization corporate website

By on September 7, 2009 in Portfolio with 0 Comments
Realization corporate website

For Evident Interactive I was Lead-developer on the project. With a team of 5 professionals we build 23 websites in 5 months. All the websites where implemented within one instance of Sitecore CMS. The websites containing Flash, Silverlight, GoogleMaps, Flick and Youtube. The project was successfully realized within the deadline.

Continue Reading »

TSQL: Nested Select with multiple results to one (comma separated) string

By on August 25, 2009 in TSQL with 0 Comments

For this example I will use the default Membership tables. Let say: I need to return all users with their roles (comma separated) in one query. After a long time Googling I found the following solution. select   UserName,   (select roles.RoleName + ', '     FROM aspnet_Roles roles     join aspnet_UsersInRoles usersInRole on roles.RoleId = […]

Continue Reading »

TSQL: Use common table expression

By on August 23, 2009 in TSQL with 0 Comments

With common table expressions you can save the results to a temporary result set and use this results set for other queries. WITH temporaryNamedResultSet AS (   select UserName from aspnet_Users ) select * from temporaryNamedResultSet

Continue Reading »

Asp.Net: invoke WCF method with WCF Test Client

When deploying a Silverlight application we ran into problems a WCF web-service, to find out what the problem was I wanted to invoke the method. Microsoft shipped an application for invoking methods from your Windows PC (WCFtestclient.exe). The following steps explain how to use WCFtestclient.exe. First startup Visual Studio 2008 Command Prompt. In the command […]

Continue Reading »

XSL: for-each with max items

By on August 5, 2009 in XSL with 3 Comments

While working with Umbraco and Sitecore I learned some Xsl tricks. The following example shows how to show the first 10 items in a HTML list. <ul>   <xsl:for-each select="*">     <xsl:if test="position()&lt;='9'">       <li>  <a href="{@link}">    <xsl:value-of select="@name"/>   </a>       </li>     </xsl:if>   </xsl:for-each> </ul>

Continue Reading »

LINQ: Creating a if statement in Linq query

By on July 30, 2009 in ASP.Net, linq with 0 Comments

A lot of times I need to check a statement within my LINQ-query and I wish there was a possibility of a IF statement within LINQ. The following code is the solution to my IF problem. I use a temporary variable (let isOlderThen30) to check if a statement is true. Then in my WHERE statement […]

Continue Reading »

Linq to Xml: Generate Google Sitemap with sitemap-protocol

By on July 8, 2009 in ASP.Net, Google, linq, XML with 1 Comment

In this example I will generate a XML site-map that complies with the sitemap-protocol XML schema. //create datasource List<string> blogPosts = new List<string>{  "",  "",  "",  "" }; //Create namespace for sitemap-protocol XNamespace xmlNS = ""; XDocument xmlDoc =  new XDocument(   new XDeclaration("1.0", "UTF-8", null),   new XElement(xmlNS + "urlset",    from blogPostUrl in […]

Continue Reading »

Add meta data (keywords, description) dynamicly

By on July 6, 2009 in ASP.Net, Controls with 1 Comment

Add meta-data dynamically to your page by adding a HtmlMeta control to your Header. In this example I dynamically add a keyword string to the page. string keyWords = "metatags, html, dynamic, generate"; HtmlMeta keywords = new HtmlMeta(); keywords.Name = "keywords"; keywords.Content = keyWords; Page.Header.Controls.Add(keywords);  You can do the same for other meta-data like description.

Continue Reading »

Linq Casting: ToDictionary()

By on June 23, 2009 in linq with 0 Comments

In this post I will give an example how to cast a GenericList to Dictionary. This example will use the following Blogger class. public class Blogger {  public string FirstName { get; set; }  public string LastName { get; set; }  public int Age { get; set; }  public string Blog { get; set; } } The example […]

Continue Reading »

Playing with JQuery (fixing Intellisense in VS2008)

By on June 23, 2009 in Javascript, Visual Studio with 0 Comments

The last few years I spend a lot of time working with Asp.Net AJAX. It all worked pretty good, the only downside is that you do not have control the generated HTML. With jQuery you can manipulate generated HTML. This HTML can be generated fully controlled with a ListView. I'm a lazy programmer so the first […]

Continue Reading »

Set CultureCode for RDLC (SQL reporting report)

By on June 11, 2009 in ASP.Net with 1 Comment

You can set the culture of a report by clicking the report and setting the Language property. If you want to support multiple cultures you can set the property to =User!Language .

Continue Reading »

Using the ViewState within the SelectMethod of a ObjectDataSource

By on June 3, 2009 in ASP.Net, Controls with 1 Comment

By default it is not possible to use the ViewState within methods of a ObjectDataSource. Because the DataSource doesn’t run within the current page instance, it just fires the method that you specified. You can set the page instance for the DataSourceby setting the ObjectInstance property in the ObjectCreating event of the DataSource. <asp:ObjectDataSource ID="odsListing" […]

Continue Reading »

Updated some blog posts

By on May 20, 2009 in ASP.Net with 0 Comments

I update two posts: String formatting in C# Copied the source of the post to my own blog as backup. DBML read connection string from web.config Added an easier way of doing this Cheers, Pieter

Continue Reading »

WCF webservice error with DBML objects

By on May 7, 2009 in ASP.Net, linq, Silverlight with 2 Comments

When deploying a WCF webservice for a Silverligh application I got the following error: An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is: System.InvalidOperationException: An exception was thrown in a call to a WSDL export extension: System.ServiceModel.Description.DataContractSerializerOperationBehavior  contract: <a href=""></a> —-> System.Runtime.Serialization.InvalidDataContractException: Type 'Project.service.HU_BACH.ScPlacemark' cannot be serialized. Consider marking it with the DataContractAttribute attribute, and […]

Continue Reading »

Asp.Net: Clear inputfields after form submit

By on April 15, 2009 in ASP.Net, Controls with 3 Comments

Every time a form is successful summited I need to clear all input-fields to the default values and give feedback to the user. I wrote a method ClearControl that can have a control as input parameter. This method will set the control based on his type back to the defaultvalue.  public static void ClearControl(Control control) {  switch (control.GetType().Name)  {   case "TextBox": […]

Continue Reading »