How to: Preview Data-Adapter Results
After configuring a data adapter, you can test how the adapter will fill a dataset.
Note
In the previous version of Visual Studio, data adapters were used for communicating between an application and a database. While data adapters are still a main component of .NET Framework Data Providers (ADO.NET), TableAdapters are designer-generated components that simplify the process of moving data between your application and a database. For more information on working with TableAdapters, see TableAdapter Overview.
To preview data-adapter results
Create a data adapter. For more information, see Creating Data Adapters.
Right-click the data adapter in the component tray and then choose Preview Data.
The Preview Data Dialog Box opens.
Select a data adapter from the Select an object to preview list.
If the command referenced by the adapter's SelectCommand property requires parameters, fill in parameter values in the Parameters grid.
Click Preview to preview the data.
The results of the SelectCommand statement or stored procedure are displayed in the Results area.
See Also
Concepts
Populating a DataSet from a DataAdapter (ADO.NET)
Creating Data Applications by Using Visual Studio