Data in Office solutions walkthroughs
Applies to: 
Visual Studio 
Visual Studio for Mac
Note
This article applies to Visual Studio 2017. If you're looking for the latest Visual Studio documentation, see Visual Studio documentation. We recommend upgrading to the latest version of Visual Studio. Download it here
The following walkthroughs demonstrate how to work with data in document-level customizations and VSTO Add-ins for Microsoft Office Word and Microsoft Office Excel.
Bind 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 VSTO Add-in project Demonstrates how to bind a single data field in a SQL Server database to a RichTextContentControl in a VSTO Add-in for Word.
Walkthrough: Complex data binding in VSTO Add-in project Demonstrates how to bind a table in a SQL Server database to a ListObject in a VSTO Add-in for Excel.
Walkthrough: Bind 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: Bind 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: Bind 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.
Cache data in document-level solutions
Walkthrough: Create 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: Insert 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: Retrieve 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: Change 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.