Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

DataTable Methods

The methods of the DataTable class are listed here. For a complete list of DataTable class members, see the DataTable Members topic.

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.

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.

See Also

DataTable Class | System.Data Namespace

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft