command| Create | Data The new Data Environment provides a simple command to make a Web application data-driven, Complex SQL statements are not embedded in an. asp file, but instead are displayed, maintained, and reused on the application layer in the Data Environment under Global.asa files, and you don't have to modify the query on every page, just modify the data command. These changes will be reflected in the file that references the data command, and you can drag the field (fields) from the command directly to the HTML or ASP page.
Create a new data connection by right-clicking the project name in Project Explorer and selecting the Add Data Connection menu command. The DataEnvironment object will appear under the Global.asa node and, under DataEnvironment, you can find the data connection.
Add a reusable SQL statement under the DataEnvironment of the data connection, and you need to fill out its data source for this command in the property page as long as you right-click on the project and choose Add Data command.
When you try to drag fields from the DataEnvironment onto the page, and each field is inserted on the page, the DTC is also inserted.
