DataRecordSet

DataRecordSet class

Stores, formats, refreshes, and exposes data queried from a database in Microsoft Visio.

DataRecordSet()

Constructor.

Properties

NameTypeDescription
IDlongThe data recordset ID, unique within the document.
ConnectionIDlongThe connection ID for the associated DataConnection object. Does not exist for XML data sources.
CommandStringThe command string used to query data from the data source.
OptionsintOptions to apply to the data recordset. Possible values can be any combination of one or more of those shown in the foll
TimeRefreshedDateTimeThe date and time the data recordset was last refreshed.
NextRowIDlongThe next available Visio row ID.
NameStringThe display (or “friendly”) name of the data recordset.
RowOrderintWhether to use the order of the rows in the data recordset as the primary key. True (1) if row IDs are determined by row
RefreshOverwriteAllintWhether to overwrite user changes to shape data items in shapes linked to data when the data recordset is refreshed. The
RefreshNoReconciliationUIintWhether the data-reconciliation user interface should be disabled. True (1) to disable the user interface (UI). False (0
RefreshIntervallongHow often (in minutes) Visio refreshes the data recordset automatically. This value must be 1 or larger.
ReplaceLinksintDefines how shape-data links are treated when shapes are copied or cut. 1 to replace existing links in the target shape.
ChecksumlongA checksum value, generated by Visio, and based on data-recordset properties. Set this attribute to 0; Visio recalculate
ADODataStringContains XML that conforms to the ADO classic XML schema for an ADO recordset and that describes the data in the data re
PrimaryKeysStringCollectionIdentifies one or more primary-key columns in the data recordset.
RefreshConflictsRowCollectionIndicates a row in the data recordset linked to a shape that is in conflict after the data recordset is refreshed. RowID
RowMapsRowCollectionMaps a data-recordset row to a shape. RowID - Row ID of the row, unique within the data recordset. ShapeID - Shape ID of
AutoLinkComparisonAutoLinkComparisonDefines a rule that compares a column in the parent DataRecordset element with a shape data item from the last successfu
DataColumnsDataColumnCollectionContains all the DataColumn elements in a data recordset.