RAD Studio for Microsoft .NET |  |

Browsing a Database in the Data Explorer
See Also
Collapse All

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

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.

To retrieve data from the database

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.

To run a stored procedure

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.

See Also

ADO.NET Component Designers

Adding a New Connection

Executing SQL in the Data Explorer

Modifying Connections

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!