A DataTable is a collection of columns and metadata.
Inheritance Hierarchy
Node
Spotfire.Dxp.Framework.DocumentModelDocumentNode
Spotfire.Dxp.DataDataTable
Spotfire.Dxp.DataDataView
Namespace: Spotfire.Dxp.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 64.0.19329.3263 (64.0.19329.3263)
Syntax
C#
[SerializableAttribute] [PersistenceVersionAttribute(57, 0)] public class DataTable : DocumentNode
The DataTable type exposes the following members.
Constructors
Name | Description | |
---|---|---|
DataTable |
Initializes a new instance of the DataTable class. Implements ISerializable. |
Properties
Name | Description | |
---|---|---|
AutoCreateFilters |
Gets or sets a value indicating whether to automatically create filters for new columns.
| |
Columns | Gets the collection of the columns that are part of this data table.
| |
Context |
Gets the context of this node.
(Inherited from DocumentNode.) | |
HasValidPrimaryKey | Gets a value indicating whether the table has a valid primary key or not.
| |
Id | Gets a unique identifier for this table.
| |
IsAttached |
Gets a value indicating whether this node is attached.
(Inherited from DocumentNode.) | |
IsExternal |
Gets a value indicating whether the data in this table is kept external.
| |
IsRefreshable | Obsolete.
Gets a value indicating whether this table is refreshable, that is,
it supports Refresh calls.
| |
IsRefreshableByNeed |
Gets a value indicating whether this table is refreshable by need, that is,
it supports RefreshOnDemandData calls and uses the NeedsRefresh
property to indicate if refresh is needed.
| |
Name | Gets or sets the name of this table.
| |
NameEscapedForExpression | Gets the name of the table escaped for usage in an
expression. This is a utility method which uses
EscapeIdentifier(String).
| |
NeedsRefresh |
Gets a value indicating whether this table needs to be refreshed (by calling RefreshOnDemandData).
| |
PrimaryKey |
Gets or sets the primary key for this data table. The primary
key is a collection of columns in this table that provides a unique
combination of values for each row.
| |
Properties | Gets the properties describing this table.
| |
Refreshing |
Gets a value indicating whether the data table is refreshing.
| |
RowCount | Gets the number of rows in the columns in this table. All columns in a DataTable
have the same number of rows.
| |
ShowColumnMatchPrompt |
Gets or sets a value indicating whether to show a prompt for
matching columns when data has been replaced.
| |
Transactions |
Gets a collection of methods for executing transactions on the document.
(Inherited from DocumentNode.) |
Methods
Name | Description | |
---|---|---|
AddColumns | Adds columns from the columns retrieved from the
dataSource using the settings in the
settings parameter. Use
CreateFileDataSource(String) to create a data
source from a file path.
| |
AddRows | Adds rows from the columns retrieved from the
dataSource using the settings in the
settings parameter. Use
CreateFileDataSource(String) to create a data
source from a file path.
| |
AddTransformation |
Adds a transformation to the table. The transformation will be applied on the source columns in the table
(i.e., the columns originating from a data source or the result of an add columns or add rows operation.)
Calculated columns will not be affected.
| |
AddTransformations |
Adds a sequence of transformations to the table. The transformation will be applied on the source columns in the table
(i.e., the columns originating from a data source or the result of an add columns or add rows operation.)
Calculated columns will not be affected.
| |
CanReloadAllData |
Gets a value indicating whether the data table can be reloaded using the ReloadAllData method.
| |
CanReloadLinkedData |
Gets a value indicating whether the data table can be reloaded using the ReloadLinkedData method.
| |
CreateEventRelay(PropertyName, StatelessDependencyDeclarer) |
Creates an event relay. An event relay is a property in the document model
which propagates event.
An event is raised for the event relay whenever when the trigger returned by the
specified dependencyDeclarer fires.
(Inherited from DocumentNode.) | |
CreateEventRelay(PropertyName, StatelessDependencyDeclarer, EventRelayMode) |
Creates an event relay. An event relay is a property in the document model
which propagates event.
An event is raised for the event relay whenever when the trigger returned by the
specified dependencyDeclarer fires.
(Inherited from DocumentNode.) | |
CreatePropertyT(PropertyName, UndoableListT) |
Creates an UndoableListT and assigns it to the specified field.
The UndoableListT will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreatePropertyT(PropertyName, UndoableSetT) |
Creates an UndoableSetT and assigns it to the specified field.
The UndoableSetT will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreatePropertyTNode(PropertyName, UndoableCrossReferencePropertyTNode, TNode) |
Creates an UndoableCrossReferencePropertyT and assigns it to the specified field.
The UndoableCrossReferencePropertyT will have the specified propertyName and initialValue.
(Inherited from DocumentNode.) | |
CreatePropertyT(PropertyName, UndoablePropertyT, T) |
Creates an UndoablePropertyT and assigns it to the specified field.
The UndoablePropertyT will have the specified propertyName and initialValue.
(Inherited from DocumentNode.) | |
CreatePropertyTKey, TValue(PropertyName, UndoableDictionaryTKey, TValue) |
Creates an UndoableDictionaryTKey, TValue and assigns it to the specified field.
The UndoableDictionaryTKey, TValue will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreatePropertyTKey, TNode(PropertyName, PropertyName, UndoableKeyedCollectionTKey, TNode) |
Creates an UndoableKeyedCollectionTKey, TNode and assigns it to the specified field.
The UndoableKeyedCollectionTKey, TNode will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreateReadOnlyPropertyT |
Creates a read-only property of type T and assigns it to the specified field.
(Inherited from DocumentNode.) | |
CreateRuntimeConstantT |
Creates a runtime constant. A runtime constant is a property in the document model
whose value is computed once when first accessed. The value is then disposed
along with the DocumentNode.
(Inherited from DocumentNode.) | |
CreateRuntimePropertyT |
Creates a RuntimePropertyT.
(Inherited from DocumentNode.) | |
DeclareInternalEventHandlers |
Declares internal event handlers.
(Overrides DocumentNodeDeclareInternalEventHandlers(InternalEventManager).) | |
DeserializePropertyT(SerializationInfo, StreamingContext, PropertyName, UndoableCrossReferencePropertyT) |
Deserializes an UndoableCrossReferencePropertyT with value of type T
stored in info with key propertyName.
(Inherited from DocumentNode.) | |
DeserializePropertyT(SerializationInfo, StreamingContext, PropertyName, UndoableListT) | (Inherited from DocumentNode.) | |
DeserializePropertyT(SerializationInfo, StreamingContext, PropertyName, UndoablePropertyT) | (Inherited from DocumentNode.) | |
DeserializePropertyT(SerializationInfo, StreamingContext, PropertyName, UndoableSetT) | (Inherited from DocumentNode.) | |
DeserializePropertyTKey, TValue(SerializationInfo, StreamingContext, PropertyName, UndoableDictionaryTKey, TValue) | (Inherited from DocumentNode.) | |
DeserializePropertyTKey, TNode(SerializationInfo, StreamingContext, PropertyName, PropertyName, UndoableKeyedCollectionTKey, TNode) | (Inherited from DocumentNode.) | |
DeserializeReadOnlyPropertyT |
Deserializes a read-only property of type T
stored in info with key propertyName.
(Inherited from DocumentNode.) | |
DuplicateSubtreeT | Returns a copy of the sub tree spanned from this node that
has the same outwards non-owning references. The returned copy will
be in state New and is intended to be attached to the document
immediately. (Inherited from DocumentNode.) | |
ExportDataToLibrary |
Export the data in the data table as a data file in the library.
| |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
GenerateSourceView |
Generates a SourceView representing DataOperations performed to construct this data table.
| |
GetDistinctRows |
Gets the distinct rows for the specified cursors. Note that this method is not supported for external data tables.
| |
GetMethods |
Gets the methods that can be used in expressions on this table.
| |
GetObjectData | Implements ISerializable. (Overrides DocumentNodeGetObjectData(SerializationInfo, StreamingContext).) | |
GetPersistedTypeName | Can be used in the deserialization constructor to get the type name that the class
corresponding to this class had when it was originally serialized. Will return null
if the specified caller type has no correspondence in the serialized information
(Inherited from DocumentNode.) | |
GetPersistedVersion | Can be used in the deserialization constructor to get the persistence version that this class
was marked with when it was originally serialized. Will return null
if the specified caller type has no correspondence in the serialized information
(Inherited from DocumentNode.) | |
GetRows(DataValueCursor) |
Enumerates all rows for the columns specified by the given valueCursors.
| |
GetRows(IEnumerableInt32, DataValueCursor) |
Enumerates a subset of the rows for the columns specified by the given valueCursors | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
InternalTransaction |
Starts an internal transaction on the document model by
executing the specified executor delegate.
(Inherited from DocumentNode.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
OnConfigure |
This method is only kept for backward compatibility.
(Overrides DocumentNodeOnConfigure.) | |
OnConfigured |
Allows a node to configure itself to the surrounding document.
(Overrides DocumentNodeOnConfigured.) | |
OnReconfigure |
Allows a node to reconfigure itself to a new part of the surrounding document.
(Inherited from DocumentNode.) | |
OnReconfigured |
Allows a node to reconfigure itself to a new part of the surrounding document.
(Inherited from DocumentNode.) | |
Refresh | Obsolete.
Refreshes this table to be up-to-date with the current settings. This will reload data from
the DataSource or recalculate depending on the type of table.
| |
RefreshOnDemandData |
Refreshes data that depends on other data and is not automatically updated.
This includes on-demand data with manual refresh, data functions with update behavior Manual
and calculations with update behavior Invalidate.
| |
RefreshOnDemandData(Action) |
Refreshes data that depends on other data and is not automatically updated.
This includes on-demand data with manual refresh, data functions with update behavior Manual
and calculations with update behavior Invalidate.
| |
ReloadAllData |
Reloads all data in this data table including data sources set to store their data.
| |
ReloadLinkedData |
Reloads only linked data in this data table.
| |
RemoveRows | Remove rows from this table.
| |
ReplaceData | Replace the data in the table with the columns in the data
source. Use CreateFileDataSource(String) to create
a data source from a file path.
| |
Select |
Returns the rows that matches the where clause expression.
The expression must be a boolean Spotfire expression.
| |
SerializePropertyT(SerializationInfo, StreamingContext, UndoableCrossReferencePropertyT) | Serializes an Undoable*Property with value of type T
storing it in info with key property.Name.
(Inherited from DocumentNode.) | |
SerializePropertyT(SerializationInfo, StreamingContext, UndoableListT) | Serializes an UndoableList with values of type T
storing it in info with key list.Name.
(Inherited from DocumentNode.) | |
SerializePropertyT(SerializationInfo, StreamingContext, UndoablePropertyT) | Serializes an UndoableProperty with value of type T
storing it in info with key property.Name.
(Inherited from DocumentNode.) | |
SerializePropertyT(SerializationInfo, StreamingContext, UndoableSetT) | Serializes an UndoableSet storing it in info
with key given by the property name of the set.
(Inherited from DocumentNode.) | |
SerializePropertyTKey, TValue(SerializationInfo, StreamingContext, UndoableDictionaryTKey, TValue) | Serializes an UndoableDictionary storing it in info
with key given by the property name of the dictionary.
(Inherited from DocumentNode.) | |
SerializePropertyTKey, TNode(SerializationInfo, StreamingContext, UndoableKeyedCollectionTKey, TNode) |
Serializes an UndoableKeyedCollectionTKey, TNode storing it in info
with key given by the property name of the keyedCollection.
(Inherited from DocumentNode.) | |
SerializeReadOnlyPropertyT |
Serializes a read-only property of type T
stored in info with key propertyName.
(Inherited from DocumentNode.) | |
ToString | Returns a string that represents the current object. (Inherited from Object.) | |
ValidateAttached | Validates that the node is attached.
(Inherited from DocumentNode.) |
Explicit Interface Implementations
Remarks
Version Information
Supported in: 14.2, 14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0, 11.8, 11.7, 11.6, 11.5, 11.4
See Also