Category Archives: Windows Apps

Creating a C# User Defined Function in Excel that Communicates with a WCF Service

Here is the business case: Your accounting staff wishes to query some figures from the financial system in Excel. To prevent a litany of copying and pasting, creating custom analysis services cubes, or taking the rather drastic measure of granting … Continue reading

Posted in Business Intelligence, Windows Apps | Leave a comment

Save & Send from Excel issues with Outlook add-in

Add-ins are a great way to add custom functionality to Outlook. I have found that in certain circumstances they can introduce problems that are frustrating. A prime example of this occurs during the following scenario: • There is add-in loaded … Continue reading

Posted in Windows Apps | Leave a comment

WPF Loading an Image from a Resource File

To load an image dynamically from the resource file in a WPF project, use the following steps: Ensure the image is in the Resources file: Add an image object to your XAML code: Then in your C# code, dynamically set … Continue reading

Posted in Windows Apps | 1 Comment

Running Multi-Value SSRS Reports from C#

There are a number of posts on the web that show you how to run a SSRS report from C#. Not too many of them cover multi-valued parameters which are extremely common in reports. First off you have a handle … Continue reading

Posted in Business Intelligence, Windows Apps | 1 Comment

SSRS from C# Execution Error

This error can appear when running an SSRS report via a web service call: This report requires a default or user-defined value for the report parameter ‘ParameterName’. To run or subscribe to this report, you must provide a parameter value. … Continue reading

Posted in Business Intelligence, Windows Apps | Leave a comment

Common Outlook Tasks via VSTO

Here are some common Outlook tasks. This code is used in an Outlook 2010 add-in. Creating an Outlook Mail Item Displaying and selecting from Outlook contacts Retrieves an Exchange user from the Global Address Book. Matches based on Display Name. … Continue reading

Posted in Windows Apps | 1 Comment

Resources and Settings

There are two tabs in a Visual Studio project which are often confused: Resources and Settings. Settings File An application settings file will allow you to store and retrieve properties for your application on the fly. Say you wrote a … Continue reading

Posted in Windows Apps | Leave a comment