Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Data Access

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 Visual Studio Tools for Office. 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 Document-Level Customizations

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 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 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.

Walkthrough: Binding Data to Controls on a Word Actions Pane

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

Walkthrough: Simple Data Binding in a Document-Level Project

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

Walkthrough: Complex Data Binding in a Document-Level Project

Demonstrates the basics of binding multiple cells in an Excel 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 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 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 document.

How to: Populate Documents with Data from a Database

Shows how data access in Word 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 documents is similar to working with Windows Forms projects.

How to: Populate Documents with Data from Services

Demonstrates how to bring Web service data into your Excel 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.

Accessing Data Sample

Shows how to read data from a data source and display it in an Excel 2007 worksheet or a Word 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: Simple Data Binding in a Document-Level Project

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

Walkthrough: Complex Data Binding in a Document-Level Project

Demonstrates the basics of binding multiple cells in an Excel 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 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 tools that you use when the workbook is open outside of Visual Studio.

Community Additions

ADD
Show:
© 2015 Microsoft