mô hình đối tượng ADO của tác với nhau để cung cấp cho bạn các đối tượng và các bộ sưu tập đó là cần thiết để làm việc với dữ liệu của bạn. Một vài mô hình đối tượng bao gồm những điều sau đây | Looking At the ADO Object Models That s right object models plural. Unlike DAO which consists of one object model ADO has several separate object models. Note With you use Namespaces and classes rather than references and object models. Although this takes some getting used to it isn t too bad after a while. ADO s object models work together to give you the objects and collections that are necessary to work with your data. A couple of the object models consist of the following ActiveX Data Objects ADODB allows you to create and work with recordsets as well as perform error handling. ADO Extensions for DDL and Security ADOX is the data definition language allowing you to work with and modify the database schema. Security objects are also included in this object model. Although these are separate object models and will be explained as such you will also use them cohesively. For instance to modify the table s structure you need to get to the Tables collection located off the Catalog object in the ADOX library however this Catalog will have its ActiveConnection property set to the Connection object ADODB . Take a look at what makes up the individual object models. The ActiveX Data Objects ADODB Object Model The ActiveX Data Objects object model see Figure consists of the following Connection object. Equivalent to the Database object in DAO this is where most of your work with ADO begins. All the objects and collections that are mentioned after this come from the Connection object. Errors collection Error object. Identical to the DAO errors collection and error object this allows developers to manage error handling. Command object. This allows you to run a query against a database and return records in a Recordset object to manipulate a database s structure and to execute a bulk operation. A collection of parameters is used with the Command object. Recordset object. Similar to the DAO Recordset object you can open the Recordset objects as .
