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
Office UI Customization Walkthroughs
Security and Deployment Walkthroughs
Common Tasks in Office Programming