Connect to Data and create reusable Data commands

The new data environment provides simple commands to make Web applications data-driven. Complex SQL statements are not hidden in one. asp files are replaced by Global. display, maintenance, and reuse of the Application layer in the Data environment under the asa file. You do not have to modify the query on each page, but just modify the Data Command, these changes will be reflected in the file that references the data Command. At the same time, you can drag the field (fields) from the Command directly to the HTML or ASP page.
In Project Explorer, right-click the Project name and select the Add Data Connection menu command to create a new Data Connection. The DataEnvironment object is stored in Global. it appears under the asa node. Under DataEnvironment, you can find this data connection.
Add a reusable SQL statement under the DataEnvironment of the Data connection. You only need to right-click the project and select Add Data Command, you need to fill in its Data source for this Data Command on the property page.
Drag the field from DataEnvironment to the page. When each field is inserted to the page, DTC is also inserted.