Once you have a live connection, you can use the Data Explorer to browse database objects.

1. Choose ViewData Explorer.
2. Expand a provider node to expose the list of available connections.
3. Expand a connection node to view the list of database objects (tables, views, and procedures).
   Note: If you receive an error because your connection is not live, you should refresh your provider, and/or modify your connection.

1. Expand a connection in the Data Explorer.
2. Double-click a table name or view name to retrieve data. This operation returns a result set into a tabbed Data Explorer page in the Code Editor.
   Tip: You can also select a table in the Data Explorer
   and right-click to display a pop-up menu with a Retrieve Data From Table command.

1. Choose ViewData Explorer.
2. Expand a connection in the Data Explorer and locate a stored procedure.
3. Double-click the stored procedure to view its parameters. The parameters open in a separate page on the design surface.
4. Edit input parameters as necessary.
5. Click the Execute button in the top left corner of the page to execute the procedure. The result set appears in a datagrid.
   Tip: You can also select a procedure in the Data Explorer
   and right-click to display a pop-up menu with an Execute command.