The DataTable type exposes the following members.
Back to Top
Back to Top
Back to Top
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.
| |
BeginRefresh | Obsolete.
Begins a refresh of this table, making it up-to-date with the
current settings. Depending on the table type, data will be reloaded
from the data source or recalculated.
| |
CreateEventRelay |
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.) | |
CreateProperty T (PropertyName, UndoableList T ) |
Creates an UndoableList T and assigns it to the specified field.
The UndoableList T will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreateProperty T (PropertyName, UndoableSet T ) |
Creates an UndoableSet T and assigns it to the specified field.
The UndoableSet T will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreateProperty TNode (PropertyName, UndoableCrossReferenceProperty TNode , TNode) |
Creates an UndoableCrossReferenceProperty T and assigns it to the specified field.
The UndoableCrossReferenceProperty T will have the specified propertyName and initialValue.
(Inherited from DocumentNode.) | |
CreateProperty T (PropertyName, UndoableProperty T , T) |
Creates an UndoableProperty T and assigns it to the specified field.
The UndoableProperty T will have the specified propertyName and initialValue.
(Inherited from DocumentNode.) | |
CreateProperty TKey, TValue (PropertyName, UndoableDictionary TKey, TValue ) |
Creates an UndoableDictionary TKey, TValue and assigns it to the specified field.
The UndoableDictionary TKey, TValue will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreateProperty TKey, TNode (PropertyName, PropertyName, UndoableKeyedCollection TKey, TNode ) |
Creates an UndoableKeyedCollection TKey, TNode and assigns it to the specified field.
The UndoableKeyedCollection TKey, TNode will have the specified propertyName.
(Inherited from DocumentNode.) | |
CreateReadOnlyProperty T |
Creates a read-only property of type T and assigns it to the specified field.
(Inherited from DocumentNode.) | |
CreateRuntimeConstant T |
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.) | |
CreateRuntimeProperty T (PropertyName, RuntimeProperty T , DependencyDeclarer, PropertyComputer T ) | Obsolete.
Creates a RuntimeProperty T .
(Inherited from DocumentNode.) | |
CreateRuntimeProperty T (PropertyName, RuntimeProperty T , StatelessDependencyDeclarer, StatelessPropertyComputer T ) |
Creates a RuntimeProperty T .
(Inherited from DocumentNode.) | |
DeclareInternalEventHandlers | Override this method to declare handlers of internal events.
(Inherited from DocumentNode.) | |
DeserializeProperty T (SerializationInfo, StreamingContext, PropertyName, UndoableCrossReferenceProperty T ) |
Deserializes an UndoableCrossReferenceProperty T with value of type T
stored in info with key propertyName.
(Inherited from DocumentNode.) | |
DeserializeProperty T (SerializationInfo, StreamingContext, PropertyName, UndoableList T ) | (Inherited from DocumentNode.) | |
DeserializeProperty T (SerializationInfo, StreamingContext, PropertyName, UndoableProperty T ) | (Inherited from DocumentNode.) | |
DeserializeProperty T (SerializationInfo, StreamingContext, PropertyName, UndoableSet T ) | (Inherited from DocumentNode.) | |
DeserializeProperty TKey, TValue (SerializationInfo, StreamingContext, PropertyName, UndoableDictionary TKey, TValue ) | (Inherited from DocumentNode.) | |
DeserializeProperty TKey, TNode (SerializationInfo, StreamingContext, PropertyName, PropertyName, UndoableKeyedCollection TKey, TNode ) | (Inherited from DocumentNode.) | |
DeserializeReadOnlyProperty T |
Deserializes a read-only property of type T
stored in info with key propertyName.
(Inherited from DocumentNode.) | |
DuplicateSubtree T | 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.) | |
EndRefresh | Obsolete. Waits until the currently executing refresh operation is
finished.
| |
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.) | |
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.
| |
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(IEnumerable Int32 , DataValueCursor ) |
Enumerates a subset of the rows for the columns specified by the given valueCursors | |
GetService | Override this method to provide services accessible
from this node and its descendants.
If you can not provide the requested service, you should call
base.GetService which relays the request to the owner
or to the AnalysisApplication if no owner is set.
(Inherited from Node.) | |
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 |
Allows a node to configure itself to the surrounding document.
(Inherited from DocumentNode.) | |
OnConfigured |
Allows a node to configure itself to the surrounding document.
(Inherited from DocumentNode.) | |
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 |
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.
| |
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.
| |
SerializeProperty T (SerializationInfo, StreamingContext, UndoableCrossReferenceProperty T ) | Serializes an Undoable*Property with value of type T
storing it in info with key property.Name.
(Inherited from DocumentNode.) | |
SerializeProperty T (SerializationInfo, StreamingContext, UndoableList T ) | Serializes an UndoableList with values of type T
storing it in info with key list.Name.
(Inherited from DocumentNode.) | |
SerializeProperty T (SerializationInfo, StreamingContext, UndoableProperty T ) | Serializes an UndoableProperty with value of type T
storing it in info with key property.Name.
(Inherited from DocumentNode.) | |
SerializeProperty T (SerializationInfo, StreamingContext, UndoableSet T ) | Serializes an UndoableSet storing it in info
with key given by the property name of the set.
(Inherited from DocumentNode.) | |
SerializeProperty TKey, TValue (SerializationInfo, StreamingContext, UndoableDictionary TKey, TValue ) | Serializes an UndoableDictionary storing it in info
with key given by the property name of the dictionary.
(Inherited from DocumentNode.) | |
SerializeProperty TKey, TNode (SerializationInfo, StreamingContext, UndoableKeyedCollection TKey, TNode ) |
Serializes an UndoableKeyedCollection TKey, TNode storing it in info
with key given by the property name of the keyedCollection.
(Inherited from DocumentNode.) | |
SerializeReadOnlyProperty T |
Serializes a read-only property of type T
stored in info with key propertyName.
(Inherited from DocumentNode.) | |
ValidateAttached | Validates that the node is attached.
(Inherited from DocumentNode.) |
Properties
Name | Description | |
---|---|---|
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 |
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 Refresh 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 Refresh ).
| |
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.
| |
Transactions |
Gets a collection of methods for executing transactions on the document.
(Inherited from DocumentNode.) |
Explicit Interface Implementations
Name | Description | |
---|---|---|
IServiceProvider GetService |
Implements IServiceProvider.
(Inherited from Node.) | |
INodeContext GetAncestor T |
Implements GetAncestor T .
(Inherited from DocumentNode.) | |
INodeContext GetService T |
Implements GetService T .
(Inherited from DocumentNode.) | |
INodeContext IsDescendantOf |
Implements IsDescendantOf(DocumentNode).
(Inherited from DocumentNode.) | |
ITransactions BeginAggregatedTransaction |
Implements BeginAggregatedTransaction .
(Inherited from DocumentNode.) | |
ITransactions ExecuteInvisibleTransaction |
Implements ExecuteInvisibleTransaction(Executor).
(Inherited from DocumentNode.) | |
ITransactions ExecuteStickyTransaction |
Implements ExecuteStickyTransaction(Guid, Executor).
(Inherited from DocumentNode.) | |
ITransactions ExecuteTransaction |
Implements ExecuteTransaction(Executor).
(Inherited from DocumentNode.) |
See Also