Basic ADO programming model
ADO provides ways to do the following:
Connect to the data source. At the same time, it is determined whether all changes to the data source have been successful or not. Specifies the command to access the data source, and can be used with variable parameters, or optimize it. Excuting an order. If this command returns the data in the form of rows in the table, these rows are stored in a cache that is easy to check, operation, or changes. In appropriate, the content of the cached row can be used to update the data source. Provide conventional methods to detect errors (usually caused by establishing a connection or execution command).
In a typical case, all of these steps are required in the programming model. However, since ADO has strong flexibility, you can do some useful work at the end only need to perform some modules. For example: store data directly from the file to the cache line, and then check the data with the ADO resource.