Share via


Preview Data Dialog Box

The Preview Data dialog box allows you to view the data returned by the TableAdapter queries in your project. You can preview data from parameterized queries by inputting parameter values for each parameter in the Parameters area.

Note   When working with local data files (.mdb or .mdf files), two copies of the database are in your project. One copy is in the bin folder, and one copy is in your project folder. Any changes you make while running your application are written to the copy in the bin folder. The data displayed in the Data Preview dialog box is from the copy in the project folder. For more information, see How to: Manage Local Data Files in Your Project.

User Interface Element List

  • Select an Object to Preview
    Select a query from the drop-down list to preview its data. Queries are located below each data table in the tree view.

  • Target DataSet
    When previewing data in data adapters, select the dataset you want to preview the data in.

  • Parameters
    Enter parameter values in the Value column of the data grid.

    Note

    The Parameters area is only available when the selected query accepts input parameters.

  • Preview
    Click the Preview button to execute the selected query and display the data in the Results area.

  • Resultsets
    Select the result set from the list to preview its data. This field appears when a query returns more than one table of data.

  • Results
    Displays the data returned from the executed query. The number of columns and rows returned is displayed above the data grid.

  • Close
    Closes the dialog box without making changes to your application or the underlying database.

  • Help
    Opens and displays this Help page.

See Also

Tasks

How to: Create TableAdapter Queries

How to: Edit TableAdapter Queries

How to: Connect to Data in a Database

Walkthrough: Connecting to Data in a Database (Windows Forms)

Concepts

Preparing Your Application to Receive Data

Fetching Data into Your Application

Binding Controls to Data in Visual Studio

Editing Data in Your Application

Validating Data

Saving Data

Other Resources

Connecting to Data in Visual Studio

ASP.NET Data Access