Export (0) Print
Expand All

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

Note Required applications

The features in this topic are available only if you have the required applications installed.

For more information, see Features Available by Product Combination.

  • One of these development environments:

    VSTO 2005


    Visual Studio Team System

  • Microsoft Office 2003

Data access works the same way in Microsoft Visual Studio 2005 Tools for the Microsoft Office System projects as it does in Windows Forms projects. You use the same tools and code to bring the data into your solution, and you can even use Windows Forms controls to display the data. In addition, you can take advantage of controls called host controls, native objects in Microsoft Office Word 2003 that have been enhanced with events and data binding capability. For more information, see Host Items and Host Controls Overview.

To populate a document with data from a local data file

  1. Open your Word application in Visual Studio, with the document open in the designer.

  2. Open the Data Sources window and create a data source for your project. For more information, see How to: Connect to Data in an Access Database and How to: Connect to Data in a SQL Server Express Database.

  3. Drag the field you want from the Data Sources window to your document. By default, a Bookmark control is created on the document for each individual field. You can change this default by selecting the field in the Data Sources window and then choosing a different control from the drop-down list.

When you run the project, the controls display the first record in the data source. You can enable scrolling through the records by handling the currency events using the objects in the BindingSource.

See Also

Community Additions

© 2015 Microsoft