This documentation is archived and is not being maintained.

Data Access (How Do I in Visual Studio Tools for Office)

This page provides links to Help for tasks that you commonly perform when you access data in solutions that you create by using Microsoft Visual Studio 2005 Tools for the Microsoft Office System. To see other categories of key tasks covered by Visual Studio Tools for Office Help, see How Do I in Visual Studio Tools for Office.

Data in Office Solutions Overview

Discusses how data can be stored in an embedded data island that is accessible without starting the Office application.

How to: Cache Data for Use Offline or on a Server

Demonstrates how you can mark a data item to be cached in the document so that it is available offline, making it possible for the data in the document to be manipulated by code when the document is stored on a server.

How to: Programmatically Cache a Data Source in an Office Document

Shows how to add a data source to a document cache programmatically by calling the StartCaching method and passing in the data source.

How to: Programmatically Stop Caching a Data Source

Demonstrates how to stop caching a data source in the document cache programmatically by calling the StopCaching method and passing in the data source.

Walkthrough: Creating a Master/Detail Relation Using a Cached Dataset

Demonstrates creating a master/detail relation on a worksheet, and caching the data so that the solution can be used offline.

How to: Change Cached Data in a Workbook on a Server

Demonstrates how to change data in the cache of an Excel 2003 workbook that is part of a Visual Studio Tools for Office project without running Excel.

How to: Retrieve Cached Data from a Workbook on a Server

Shows how to retrieve data from the cache from an Excel 2003 workbook that is part of a Visual Studio Tools for Office project without running Excel, making it possible to get data from Excel workbooks that are stored on a server.

How to: Cache Data Objects

Describes how to cache objects that are not datasets or data tables in your Visual Studio Tools for Office solution documents.

Walkthrough: Binding Data to Controls on a Word Actions Pane

Demonstrates binding data to controls on an actions pane in Word 2003, in which the controls demonstrate a master/detail relation between tables in a SQL Server database.

Walkthrough: Binding a Worksheet Cell to a Database Field

Steps you through the basics of binding a single data field in a SQL Server database to a named range in Excel 2003.

Walkthrough: Binding Cells to Multiple Columns in a Table

Demonstrates the basics of binding multiple cells in an Excel 2003 worksheet to fields in the Northwind SQL Server database.

Walkthrough: Binding Data to Controls on an Excel Actions Pane

Describes how to add controls that are bound to a data source to an actions pane in Excel.

How to: Scroll through Database Records in a Worksheet

Shows how to display a single field from a database table in an Excel 2003 worksheet, with controls that enable the end user to scroll through all the records.

How to: Map ListObject Columns to Data

Describes how to map specific columns in a ListObject control to a data source.

How to: Scroll through Database Records in a Worksheet

Shows how to display a single field from a database table in an Excel 2003 worksheet, with controls that enable the end user to scroll through all the records.

How to: Format Text in Documents

Demonstrates how to use the Word Range object to format text in a Word 2003 document.

How to: Populate Documents with Data from a Local Database File

Shows how data access in Word 2003 solutions works the same way as it does in Windows Forms projects.

How to: Populate Worksheets with Data from a Database

Demonstrates how you can display database data in a worksheet, and how data access works the same way as it does in Windows Forms projects.

How to: Populate Documents with Data from Objects

Shows how accessing data that is stored in objects from Word 2003 documents is similar to working with Windows Forms projects.

How to: Populate Worksheets with Data from Web Services

Demonstrates how to bring Web service data into your Excel 2003 solutions.

How to: Cache Data for Use Offline or on a Server

Demonstrates how you can mark a data item to be cached in the document so that it is available offline, making it possible for the data in the document to be manipulated by code when the document is stored on a server.

Data Analysis Sample

Demonstrates data analysis tasks that are executed by using toolbar buttons and menus in Excel 2003.

Accessing Data Sample

Shows how to read data from a data source and display it in an Excel 2003 worksheet or a Word 2003 document.

Walkthrough: Creating a Master/Detail Relation Using a Cached Dataset

Demonstrates creating a master/detail relation on a worksheet, and caching the data so that the solution can be used offline.

Walkthrough: Binding a Worksheet Cell to a Database Field

Steps you through the basics of binding a single data field in a SQL Server database to a named range in Excel 2003.

Walkthrough: Binding Cells to Multiple Columns in a Table

Demonstrates the basics of binding multiple cells in an Excel 2003 worksheet to fields in the Northwind SQL Server database.

How to: Map Schemas to Word Documents Inside Visual Studio

Demonstrates how to map an XML schema to a document while the document is open in a Visual Studio Tools for Office project, using the same Word 2003 tools that you use when the document is open outside of Visual Studio.

How to: Map Schemas to Worksheets Inside Visual Studio

Describes how to map an XML schema to a worksheet while the worksheet is open in a Visual Studio Tools for Office project, using the same Excel 2003 tools that you use when the workbook is open outside of Visual Studio.

Show: