The Data Environment designer provides an interactive, environment for creating programmatic data access. At design time, you set property values for Connection and Command objects, write code to respond to ActiveX® Data Object (ADO) events, execute commands, and create aggregates and hierarchies. You can also drag Data Environment objects onto forms or reports to create data-bound controls.
With the Data Environment designer, you can accomplish the following tasks:
- Add a Data Environment designer to a Visual Basic project.
- Create Connection objects.
- Create Command objects based on stored procedures, tables, views, synonyms, and SQL statements.
- Create hierarchies of commands based on a grouping of Command objects, or by relating one or more Command objects together.
- Write and run code for Connection and Recordset objects.
- Drag fields within a Command object from the Data Environment designer onto a Visual Basic form or the Data Report designer.