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 moreHow 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 moreHow 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 moreHow 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 moreDesigning 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 moreA 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.png)
.png)