Skip to content

Posts from Code

19
Jul

How to simulate the SQL WHERE IN clause in SharePoint 2007 SPQuery

If you ever have used something like SELECT * FROM table WHERE field IN ('value1','value2','value3','value4')   in T-SQL, and wanted to mimic this functionality in the SharePoint SPQuery class, you probably have found out there is no IN statement in the CAML Query language. So what do do? One solution...

Read more
15
Apr

How to use the SPGridView filter together with a SPDataSource

Normally you will no problems finding examples on how to use the SPGridView together with an ObjectDataSource and use the filtering mechanism. But what about using the SPDataSource object? This can also be done fairly simple. You do the basic things as you do using an ObjectDataSource object, however...

Read more
28
Dec

How to target 32bit and 64bit a .NET applications with WiX and separate MSI packages

This post will explain how you can build msi packages using WiX for both 32bit and 64bit platforms. The goal is to create 2 different msi packages. One for 64bit systems, which will install the program in to c:\Program Files on 64bit, and another msi package that will install the program in to c:\Program...

Read more
19
Oct

How to get the full URL from SPListItem in SharePoint

The SPListItem URL property does return the URL for the SPListItem including the List/Documetn Library name, but it doesn't return the full URL including the server and site names. To get the full URL, you can either concatenate the SPLIstItem.Web.Url and the SPListItem.URL, or extract the full URL from...

Read more
14
Jun

Designing the Stack Overflow Windows Gadget using Balsamiq Mockups

Reading on Stack Overflow that they have published the possibility to put your Stack Overflow status on your web page or blog. They call it the Stack Overflow “Flair”. There are a number of possibilities you have to get your flair information from their servers, and one of the methods is...

Read more
30
May

A Stack Overflow Sidebar Gadget

Update: The gadget (which now also supports both Serverfault.com and SuperUser.com ), with source code, is now available on CodePlex.com . I have been following the progress of the Stack Overflow web site since it has started. In fact, I did also participate in the beta testing of the site. In podcast...

Read more