Finding Help Documentation for ADO, a built in component of ASP, 45

I have one on my site.

The name is: [Manual] Microsoft ActiveX Data Objects (ADO).chm

You can use any kind of advanced version of the component to write it yourself, and if you are familiar with ASP, it is easier to get started with writing directly in VB.

The principle of accessing the database.

ASP is a server-side script execution environment that can be used to generate and execute dynamic, high-performance web server programs. When a user requests an ASP home page using a browser, the web server responds, invokes the ASP engine to execute the ASP file, interprets the scripting language (jscript or vbscript) in it, connects to the database via ODBC, and accesses the components from the database.

ADO (ActiveX Data Objects) completes the database operation, and finally ASP generates an HTML homepage containing the data query results and returns it to the client for display.

Since ASP runs on the server side, the running result is returned to the user's browser in the form of HTML homepage, so the ASP source program will not be leaked, which increases the security and confidentiality of the system. In addition, ASP is an object-oriented scripting environment, and users can add their own ActiveX components to extend its functionality and expand the scope of applications.

database access component ado

When accessing the web database with ASP, you must use the ADO component, which is the built-in ActiveX server component of ASP, and can be connected to a variety of databases by setting ODBC and OLEDB on the web server: such as Sybase, Oracle, Informix, SQL Server, Access, VFP, etc., is the most efficient and straightforward way to operate the database currently supported by Microsoft.

Usually we learn to link access the database uses this control, the specific steps are as follows.

Three. ASP to access the database.

In ASP, using the ADO component to access the backend database can be done by following the following steps:

1.Define the data source.

Open the "Control Panel" on the web server, select "ODBC", select "Add" under "System DSN", and select the type, name, location, etc. of the database you want. In this example, sqlserver is defined, the data source is ht, the database name is htdata, and the scripting language is jscript.

2.Use the ADO component to query the web database.

Call the method to get the instance, and then use the open method to open the database.

After specifying the SQL command to be executed to connect to the database, you can perform operations on the database, such as querying, modifying, deleting, etc., which are completed through SQL commands. **Reference Network.

To use the RecordSet property and methods and display the resultsIn order to track data more precisely, use the RecordSet component to create a cursor that contains the data, which is data stored in memory.

Close the database.

Finally, after providing an address, you can see for yourself to understand the knowledge.