Export (0) Print
Expand All

DataTable Members

DataTable overview

Public Constructors

public constructorDataTable Constructor

Supported by the .NET Compact Framework.

Overloaded. Initializes a new instance of the DataTable class.

Public Properties

public propertyCaseSensitive

Supported by the .NET Compact Framework.

Indicates whether string comparisons within the table are case-sensitive.
public propertyChildRelations

Supported by the .NET Compact Framework.

Gets the collection of child relations for this DataTable.
public propertyColumns

Supported by the .NET Compact Framework.

Gets the collection of columns that belong to this table.
public propertyConstraints

Supported by the .NET Compact Framework.

Gets the collection of constraints maintained by this table.
public propertyContainer (inherited from MarshalByValueComponent) Gets the container for the component.
public propertyDataSet

Supported by the .NET Compact Framework.

Gets the DataSet that this table belongs to.
public propertyDefaultView

Supported by the .NET Compact Framework.

Gets a customized view of the table which may include a filtered view, or a cursor position.
public propertyDesignMode (inherited from MarshalByValueComponent) Gets a value indicating whether the component is currently in design mode.
public propertyDisplayExpression

Supported by the .NET Compact Framework.

Gets or sets the expression that will return a value used to represent this table in the user interface.
public propertyExtendedProperties

Supported by the .NET Compact Framework.

Gets the collection of customized user information.
public propertyHasErrors

Supported by the .NET Compact Framework.

Gets a value indicating whether there are errors in any of the rows in any of the tables of the DataSet to which the table belongs.
public propertyLocale

Supported by the .NET Compact Framework.

Gets or sets the locale information used to compare strings within the table.
public propertyMinimumCapacity

Supported by the .NET Compact Framework.

Gets or sets the initial starting size for this table.
public propertyNamespace

Supported by the .NET Compact Framework.

Gets or sets the namespace for the XML represenation of the data stored in the DataTable.
public propertyParentRelations

Supported by the .NET Compact Framework.

Gets the collection of parent relations for this DataTable.
public propertyPrefix

Supported by the .NET Compact Framework.

Gets or sets the namespace for the XML represenation of the data stored in the DataTable.
public propertyPrimaryKey

Supported by the .NET Compact Framework.

Gets or sets an array of columns that function as primary keys for the data table.
public propertyRows

Supported by the .NET Compact Framework.

Gets the collection of rows that belong to this table.
public propertySite Overridden. Gets or sets an System.ComponentModel.ISite for the DataTable.
public propertyTableName

Supported by the .NET Compact Framework.

Gets or sets the name of the DataTable.

Public Methods

public methodAcceptChanges

Supported by the .NET Compact Framework.

Commits all the changes made to this table since the last time AcceptChanges was called.
public methodBeginInit

Supported by the .NET Compact Framework.

Begins the initialization of a DataTable that is used on a form or used by another component. The initialization occurs at runtime.
public methodBeginLoadData

Supported by the .NET Compact Framework.

Turns off notifications, index maintenance, and constraints while loading data.
public methodClear

Supported by the .NET Compact Framework.

Clears the DataTable of all data.
public methodClone

Supported by the .NET Compact Framework.

Clones the structure of the DataTable, including all DataTable schemas and constraints.
public methodCompute

Supported by the .NET Compact Framework.

Computes the given expression on the current rows that pass the filter criteria.
public methodCopy Copies both the structure and data for this DataTable.
public methodDispose (inherited from MarshalByValueComponent) Overloaded. Releases the resources used by the MarshalByValueComponent.
public methodEndInit

Supported by the .NET Compact Framework.

Ends the initialization of a DataTable that is used on a form or used by another component. The initialization occurs at runtime.
public methodEndLoadData

Supported by the .NET Compact Framework.

Turns on notifications, index maintenance, and constraints after loading data.
public methodEquals (inherited from Object)

Supported by the .NET Compact Framework.

Overloaded. Determines whether two Object instances are equal.
public methodGetChanges Overloaded. Gets a copy of the DataTable containing all changes made to it since it was last loaded, or since AcceptChanges was called.
public methodGetErrors

Supported by the .NET Compact Framework.

Gets an array of DataRow objects that contain errors.
public methodGetHashCode (inherited from Object)

Supported by the .NET Compact Framework.

Serves as a hash function for a particular type, suitable for use in hashing algorithms and data structures like a hash table.
public methodGetService (inherited from MarshalByValueComponent) Gets the implementer of the IServiceProvider.
public methodGetType (inherited from Object)

Supported by the .NET Compact Framework.

Gets the Type of the current instance.
public methodImportRow

Supported by the .NET Compact Framework.

Copies a DataRow into a DataTable, preserving any property settings, as well as original and current values.
public methodLoadDataRow

Supported by the .NET Compact Framework.

Finds and updates a specific row. If no matching row is found, a new row is created using the given values.
public methodNewRow

Supported by the .NET Compact Framework.

Creates a new DataRow with the same schema as the table.
public methodRejectChanges

Supported by the .NET Compact Framework.

Rolls back all changes that have been made to the table since it was loaded, or the last time AcceptChanges was called.
public methodReset

Supported by the .NET Compact Framework.

Resets the DataTable to its original state.
public methodSelect

Supported by the .NET Compact Framework.

Overloaded. Gets an array of DataRow objects.
public methodToString

Supported by the .NET Compact Framework.

Overridden. Gets the TableName and DisplayExpression, if there is one as a concatenated string.

Public Events

public eventColumnChanged Occurs after a value has been changed for the specified DataColumn in a DataRow.
public eventColumnChanging Occurs when a value is being changed for the specified DataColumn in a DataRow.
public eventDisposed (inherited from MarshalByValueComponent) Adds an event handler to listen to the Disposed event on the component.
public eventRowChanged Occurs after a DataRow has been changed successfully.
public eventRowChanging Occurs when a DataRow is changing.
public eventRowDeleted Occurs after a row in the table has been deleted.
public eventRowDeleting Occurs before a row in the table is about to be deleted.

Protected Constructors

protected constructorDataTable Constructor Overloaded. Initializes a new instance of the DataTable class.

Protected Properties

protected propertyEvents (inherited from MarshalByValueComponent) Gets the list of event handlers that are attached to this component.

Protected Methods

protected methodCreateInstance Creates a new instance of the DataTable class.
protected methodDispose (inherited from MarshalByValueComponent) Overloaded. Releases the resources used by the MarshalByValueComponent.
protected methodFinalize (inherited from Object)

Supported by the .NET Compact Framework.

Overridden. Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.

In C# and C++, finalizers are expressed using destructor syntax.

protected methodMemberwiseClone (inherited from Object)

Supported by the .NET Compact Framework.

Creates a shallow copy of the current Object.
protected methodNewRowFromBuilder

Supported by the .NET Compact Framework.

Creates a new row from an existing row.
protected methodOnColumnChanged

Supported by the .NET Compact Framework.

Raises the ColumnChanged event.
protected methodOnColumnChanging

Supported by the .NET Compact Framework.

Raises the ColumnChanging event.
protected methodOnRemoveColumn Notifies the DataTable that a DataColumn is being removed.
protected methodOnRowChanged

Supported by the .NET Compact Framework.

Raises the RowChanged event.
protected methodOnRowChanging

Supported by the .NET Compact Framework.

Raises the RowChanging event.
protected methodOnRowDeleted

Supported by the .NET Compact Framework.

Raises the RowDeleted event.
protected methodOnRowDeleting

Supported by the .NET Compact Framework.

Raises the RowDeleting event.

Explicit Interface Implementations

See Also

DataTable Class | System.Data Namespace

Show:
© 2014 Microsoft