MSDN Library

The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

This topic has not yet been rated - Rate this topic

Data Walkthroughs (Visual Studio Tools for Office)

Visual Studio 2008

Other Versions

Updated: July 2008

Walkthroughs provide step-by-step instructions for common scenarios and are a good place to start learning about Visual Studio Tools for Office.

The following walkthroughs demonstrate how to work with data in document-level customizations and application-level add-ins for Microsoft Office Word and Microsoft Office Excel.

Binding Controls to Data

Walkthrough: Simple Data Binding in a Document-Level Project: Demonstrates how to bind a single data field in a SQL Server database to a NamedRange in a document-level customization for Excel.
Walkthrough: Complex Data Binding in a Document-Level Project: Demonstrates how to bind a table in a SQL Server database to a ListObject in a document-level customization for Excel.
Walkthrough: Simple Data Binding in an Application-Level Project: Demonstrates how to bind a single data field in a SQL Server database to a RichTextContentControl in an application-level add-in for Word.
Walkthrough: Complex Data Binding in an Application-Level Project: Demonstrates how to bind a table in a SQL Server database to a ListObject in an application-level add-in for Excel.
Walkthrough: Binding Data to Controls on an Excel Actions Pane: Demonstrates how to add controls that are bound to a data source to an actions pane in Excel.
Walkthrough: Binding Data to Controls on a Word Actions Pane: Demonstrates how to bind controls on an actions pane to data. The controls demonstrate a master/detail relation between tables in a SQL Server database.
Walkthrough: Binding Content Controls to Custom XML Parts: Demonstrates how to bind content controls in a Word document to XML data that is stored in the document.

Caching Data in Document-Level Solutions

Walkthrough: Creating a Master/Detail Relation Using a Cached Dataset: Demonstrates how to create a master/detail relation on a worksheet, and cache the data so that the solution can be used offline.
Walkthrough: Inserting Data into a Workbook on a Server: Demonstrates how to insert data into a dataset that is cached in a Microsoft Office Excel workbook without starting Excel.
Walkthrough: Retrieving Cached Data from a Workbook on a Server: Demonstrates how to retrieve data from a dataset that is cached in a Microsoft Office Excel workbook without starting Excel.
Walkthrough: Changing Cached Data in a Workbook on a Server: Demonstrates how to modify a dataset that is cached in a Microsoft Office Excel workbook without starting Excel.