ADOX Code Examples in Microsoft Visual Basic

These topics provide sample code to help you understand how to use ADOX. All code examples are written using Microsoft Visual Basic.

Note

Paste the entire code example, from Sub to End Sub, into your code editor. The example may not run correctly if you use partial examples or if paragraph formatting is lost.

Methods

• Columns and Tables Append Methods, Name Property Example (VB)

• Connection Close Method, Table Type Property Example (VB)

• Create Method Example (VB)

• GetObjectOwner and SetObjectOwner Methods Example (VB)

• GetPermissions and SetPermissions Methods Example (VB)

• Groups and Users Append, ChangePassword Methods Example (VB)

• Indexes Append Method Example (VB)

• Keys Append Method, Key Type, RelatedColumn, RelatedTable, and UpdateRule Properties Example (VB)

• Procedures Append Method Example (VB)

• Procedures Delete Method Example (VB)

• Procedures Refresh Method Example (VB)

• Views Append Method Example (VB)

• Views Delete Method Example (VB)

• Views Refresh Method Example (VB)

Properties

• Attributes Property Example (VB)

• Catalog ActiveConnection Property Example (VB)

• Clustered Property Example (VB)

• Command and CommandText Properties Example (VB)

• Command Property, Parameters Collection Example (VB)

• CommandText Property, Views Collection Example (VB)

• DateCreated and DateModified Properties Example (VB)

• DefinedSize Property Example (VB)

• DeleteRule Property Example (VB)

• IndexNulls Property Example (VB)

• Key Type, RelatedColumn, RelatedTable, and UpdateRule Properties, Keys Append Method Example (VB)

• Name Property, Columns and Tables Append Methods Example (VB)

• NumericScale and Precision Properties Example (VB)

• ParentCatalog Property Example (VB)

• PrimaryKey and Unique Properties Example (VB)

• SortOrder Property Example (VB)

• Table Type Property, Connection Close Method, Example (VB)

Collections

• Parameters Collection, Command Property Example (VB)

• Views and Fields Collections Example (VB)

• Views Collection, CommandText Property Example (VB)