2. ADOX object
Catalog Contains a collection of directories describing the data source schema.
Column
Group
Index
Key
Procedure Denotes a stored procedure.
Table
User
View
3. ADOX method
Append(Columns) Adds a new Column object to the Columns collection.
Append(Groups) Adds a new Group object to the Groups collection.
Append (Indexes) Adds a new Index object to the Indexes collection.
Append (Keys) Adds a new Key object to the Keys collection.
Append (Procedures) Adds a new Procedure object to the Procedures collection.
Append(Tables) Adds a new Table object to the Tables collection.
Append (Users) adds a new User object to the Users collection.
Append (Views) Adds a new View object to the Views collection.
ChangePassword Change the password of the user account.
Create Create a new directory.
Delete Delete objects in the collection.
GetObjectOwner Returns the owner of the object in the directory.
GetPermissions Obtains permissions to groups or users on objects.
Item Returns the specified member of the collection by name or sequence number.
Refresh Update objects in the collection to reflect the objects available and specified for the provider.
SetObjectOwner Specifies the owner of the object in the directory.
SetPermissions Set the permissions of groups or users on the object.
4. ADOX attributes
ActiveConnection Indicates the ADO Connection object to which the directory belongs.
Attributes describes column characteristics.
Clustered Indicates whether the index is clustered.
Command Specifies the ADO Command object that can be used to create or execute processes.
Count Indicates the number of objects in the collection.
DateCreated Indicates the date when the object was created.
DateModified Indicates the date of the last object changed.
DefinedSize indicates the specified maximum size of the column.
DeleteRule Indicates the action to be performed when the main keyword is deleted.
IndexNulls indicates whether records with Null values in the index field have index items.
Name indicates the name of the object.
NumericScale Indicates the range of values in the column.
ParentCatalog Specifies the parent directory of a table or column to access the properties of a specific provider.
Precision Indicates the highest accuracy of the data value in the column.
PrimaryKey Indicates whether the index represents the primary keyword of the table.
RelatedColumn indicates the name of the relevant column in the relevant table (keyword column only).
RelatedTable indicates the name of the relevant table.
SortOrder indicates the sort order of columns (index columns only).
Type(column) indicates the data type of the column.
Type (keyword) indicates the data type of the keyword.
Type (table) indicates the type of the table.
Unique indicates whether the index keyword must be unique.
UpdateRule Indicates the action that will be performed when the main keyword is updated.
5. Example
1. Create a database example
The following code shows how to create a new Jet database through the Create method.
ASP code:
-----------------------------------------------------------
set cat=("")
"Provider=.4.0;Data Source=c:\"
VB code
--------------------------------
Sub CreateDatabase()
'Dim cat As New
' ""Provider=.4.0;Data Source=c:\""
End Sub
2. Create table example ASP code:
-------------<%
set cat=("")
dbpath=("/shit/date/") "Provider=.4.0;Data Source="&dbpath
set tbl=("")
= "MyTable"
"Column1", 3 'adInteger
"Column2", 3 'adInteger
"Column3", 202 ,50 'adVarWChar
tbl
%>
VB code: ---------------
Sub CreateTable()
Dim tbl As New Table
Dim cat As New
'Open the directory.
'Open the directory.
= _
""Provider=.4.0;"" & _
""Data Source=c:\Program Files\Microsoft Office\"" & _
""Office\Samples\;""
= ""MyTable""
""Column1"", adInteger
""Column2"", adInteger
""Column3"", adVarWChar, 50
tbl
End Sub
Previous page123Next pageRead the full text