Search Wiki:
northwindlogo75.gif 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.

This is a work in progress that folows the following article series:

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

Download the latest release here

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.
Last edited Apr 22 2009 at 5:11 AM  by BethMassi, version 14
Page view tracker