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.

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)