Search Wiki:
These samples demonstrate a simple Office Business Application used by the new Northwind Traders that includes versions for both Visual Studio 2008 Service Pack 1 and Visual Studio 2010. It follows the workflow of accepting purchase orders through email all the way to shipping. It shows how to expose LOB data using Data Services as well as interact with it in Outlook, Word, Excel and SharePoint.

Visual Studio 2010 Version

Download the latest VS2010 release here
Please read the SetupInstructions.docx contained in the .zip for information on how to configure your system to run the sample properly.

I've started releasing articles that show how to upgrade the VS2008 version to VS2010 so be sure to check these out:

Setting up Windows 7 for Office & SharePoint 2010 Beta Development
Migrating an Outlook Client to .NET Framework 4 in Visual Studio 2010
Build WPF Data Controls for Outlook Addins Easily with VS2010
Migrating a 2007 Workflow to Visual Studio & SharePoint 2010
Creating a SharePoint Visual Web Part using Visual Studio 2010

This sample was built using Visual Studio 2010 and it demonstrates:
  1. A way to easily expose LOB data using WCF Data Services (formerly known as ADO.NET Data Services)
  2. An Outlook 2010 Add-in that displays LOB data in a WPF control that I built in 5 minutes using the new drag-drop databinding and designer features
  3. How to store and retrieve structured data from Word 2010 documents
  4. An Excel 2010 document customization that edits LOB data through the data service and provides data visualization
  5. A SharePoint 2010 Document Library Workflow that adds Order info to the database by reading word documents and updates and reports order statuses based on changes in the database using the data service
  6. A SharePoint 2010 Visual Web Part that reports low inventory in the database using the data service and allows users to add tasks
  7. A SharePoint 2010 Silverlight Web Part that demonstrates how to deploy Silverlight web parts to SharePoint 2010 and use the SharePoint Silverlight client library to add tasks

Visual Studio 2008 Version

Download the latest VS2008 release here
Please read the companion article series for step-by-step information on building this sample:

Building an Office Business Application
OBA Part 1 - Exposing Line-of-Business Data
OBA Part 2 - Building an Outlook Client against LOB Data
OBA Part 3 - Storing and Reading Data in Word Documents
OBA Part 4 - Building an Excel Client against LOB Data
OBA Part 5 - Building the SharePoint 2007 Workflow

This sample was built using Visual Studio 2008 Professional Service Pack 1 and it demonstrates:
  1. A way to easily expose LOB data using ADO.NET Data Services
  2. An Outlook Add-in that displays LOB data in a WPF control
  3. How to store and retrieve structured data from Word 2007 documents
  4. An Excel document customization that edits LOB data provides data visualization
  5. A SharePoint 2007 Document Library Workflow that adds Order info to the database by reading word documents and updates and reports order statuses based on changes in the database using ADO.NET Data Services

PLEASE READ THIS

This sample uses the Northwind sample database you can download here. The sample contains a database project that includes change scripts to add EmailAddress to customers and employees tables as well as OrderNumber to the Orders table so please make sure you run those before attempting to run the sample. You may also need to update the connection string located in the Web.config of the NorthwindDataService project.

You will also need to download the Open XML SDK.
Last edited Feb 4 2010 at 3:03 AM  by BethMassi, version 27
Updating...
Page view tracker