Data in Office Solutions Walkthroughs

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.

See Also

Concepts

Walkthroughs Using Word

Walkthroughs Using Excel

Office UI Customization Walkthroughs

Security and Deployment Walkthroughs

Common Tasks in Office Programming

Other Resources

Office Development Samples

Getting Started (Office Development in Visual Studio)

Designing and Creating Office Solutions