Learn how to build custom applications that use the business data catalog and smart tags. This code sample and white paper walks through a custom solution that integrates LOB data with the 2007 Microsoft Office system to support the preparation of documents within Microsoft Office Word 2007. The solution presented uses product information contained within a Microsoft SQL Server 2005 database to support the creation of a quote sheet.

In this scenario, a manufacturing sales representative uses a solution based on Office Word 2007, Microsoft Visual Studio 2005 Tools for Office Second Edition, and the business data catalog feature of Microsoft Office SharePoint Server 2007 Enterprise Edition to access product information and create a new quote sheet. The solution allows the sales representative to easily browse product information from within Office Word and insert the information into a quote document template. Furthermore, the solution uses smart tags to identify product numbers within the quote and display detailed information contained in the business data catalog through Office SharePoint Server 2007.

Before opening the sample code, you should have an appropriate development environment including:

1. Microsoft Office SharePoint Server Enterprise Edition
2. Microsoft Office Word 2007
3. Visual Studio 2005
4. AdventureWorks sample database
5. Microsoft Visual Studio Tools for Office 2005, Second Edition

This sample is intended to be run directly from Visual Studio 2005 with the Word Add-In project set as the default start up project.

2007 Office Sample: Using the Business Data Catalog and Smart Tags with the 2007 Office System (Windows Validation required)