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