DataTable Members
.NET Framework 2.0
Represents one table of in-memory data.
The following tables list the members exposed by the DataTable type.
(see also
Protected Constructors
)
Top
| Name | Description | |
|---|---|---|
| DataTable | Overloaded. Initializes a new instance of the DataTable class. |
(see also
Protected Properties
)
Top
| Name | Description | |
|---|---|---|
| CaseSensitive | Indicates whether string comparisons within the table are case-sensitive. |
| ChildRelations | Gets the collection of child relations for this DataTable. |
| Columns | Gets the collection of columns that belong to this table. |
| Constraints | Gets the collection of constraints maintained by this table. |
| Container | Gets the container for the component.(Inherited from MarshalByValueComponent.) |
| DataSet | Gets the DataSet to which this table belongs. |
| DefaultView | Gets a customized view of the table that may include a filtered view, or a cursor position. |
| DesignMode | Gets a value indicating whether the component is currently in design mode.(Inherited from MarshalByValueComponent.) |
| DisplayExpression | Gets or sets the expression that returns a value used to represent this table in the user interface. |
| ExtendedProperties | Gets the collection of customized user information. |
| HasErrors | 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. |
| IsInitialized | Gets a value that indicates whether the DataTable is initialized. |
| Locale | Gets or sets the locale information used to compare strings within the table. |
| MinimumCapacity | Gets or sets the initial starting size for this table. |
| Namespace | Gets or sets the namespace for the XML representation of the data stored in the DataTable. |
| ParentRelations | Gets the collection of parent relations for this DataTable. |
| Prefix | Gets or sets the namespace for the XML representation of the data stored in the DataTable. |
| PrimaryKey | Gets or sets an array of columns that function as primary keys for the data table. |
| RemotingFormat | Gets or sets the serialization format. |
| Rows | Gets the collection of rows that belong to this table. |
| Site | Gets or sets an System.ComponentModel.ISite for the DataTable. |
| TableName | Gets or sets the name of the DataTable. |
| Name | Description | |
|---|---|---|
| Events | Gets the list of event handlers that are attached to this component.(Inherited from MarshalByValueComponent.) |
(see also
Protected Methods
)
Top
| Name | Description | |
|---|---|---|
| AcceptChanges | Commits all the changes made to this table since the last time AcceptChanges was called. |
| BeginInit | Begins the initialization of a DataTable that is used on a form or used by another component. The initialization occurs at runtime. |
| BeginLoadData | Turns off notifications, index maintenance, and constraints while loading data. |
| Clear | Clears the DataTable of all data. |
| Clone | Clones the structure of the DataTable, including all DataTable schemas and constraints. |
| Compute | Computes the given expression on the current rows that pass the filter criteria. |
| Copy | Copies both the structure and data for this DataTable. |
| CreateDataReader | Returns a DataTableReader corresponding to the data within this DataTable. |
| Dispose | Overloaded. Releases the resources used by the MarshalByValueComponent. (Inherited from MarshalByValueComponent.) |
| EndInit | Ends the initialization of a DataTable that is used on a form or used by another component. The initialization occurs at runtime. |
| EndLoadData | Turns on notifications, index maintenance, and constraints after loading data. |
| Equals | Overloaded. Determines whether two Object instances are equal. (Inherited from Object.) |
| GetChanges | Overloaded. Gets a copy of the DataTable containing all changes made to it since it was last loaded, or since AcceptChanges was called. |
| GetDataTableSchema | This method returns a XmlSchemaSet instance containing the WSDL that describes the DataTable for Web Services. |
| GetErrors | Gets an array of DataRow objects that contain errors. |
| GetHashCode | Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table. (Inherited from Object.) |
| GetObjectData | Populates a serialization information object with the data needed to serialize the DataTable. |
| GetService | Gets the implementer of the IServiceProvider. (Inherited from MarshalByValueComponent.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| ImportRow | Copies a DataRow into a DataTable, preserving any property settings, as well as original and current values. |
| Load | Overloaded. Fills a DataTable with values from a data source using the supplied IDataReader. If the DataTable already contains rows, the incoming data from the data source is merged with the existing rows. |
| LoadDataRow | Overloaded. Finds and updates a specific row. If no matching row is found, a new row is created using the given values. |
| Merge | Overloaded. Merge the specified DataTable with the current DataTable. |
| NewRow | Creates a new DataRow with the same schema as the table. |
| ReadXml | Overloaded. Reads XML schema and data into the DataTable. |
| ReadXmlSchema | Overloaded. Reads an XML schema into the DataTable. |
| ReferenceEquals | Determines whether the specified Object instances are the same instance. (Inherited from Object.) |
| RejectChanges | Rolls back all changes that have been made to the table since it was loaded, or the last time AcceptChanges was called. |
| Reset | Resets the DataTable to its original state. |
| Select | Overloaded. Gets an array of DataRow objects. |
| ToString | Overridden. Gets the TableName and DisplayExpression, if there is one as a concatenated string. |
| WriteXml | Overloaded. Writes the current contents of the DataTable as XML. |
| WriteXmlSchema | Overloaded. Writes the current data structure of the DataTable as an XML schema. |
| Name | Description | |
|---|---|---|
| CreateInstance | |
| Dispose | Overloaded. Releases the resources used by the MarshalByValueComponent. (Inherited from MarshalByValueComponent.) |
| Finalize | [To be supplied.] (Inherited from MarshalByValueComponent.) |
| GetRowType | |
| GetSchema | |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| NewRowArray | |
| NewRowFromBuilder | Creates a new row from an existing row. |
| OnColumnChanged | Raises the ColumnChanged event. |
| OnColumnChanging | Raises the ColumnChanging event. |
| OnPropertyChanging | Raises the PropertyChanged event. |
| OnRemoveColumn | Notifies the DataTable that a DataColumn is being removed. |
| OnRowChanged | Raises the RowChanged event. |
| OnRowChanging | Raises the RowChanging event. |
| OnRowDeleted | Raises the RowDeleted event. |
| OnRowDeleting | Raises the RowDeleting event. |
| OnTableCleared | Raises the TableCleared event. |
| OnTableClearing | Raises the TableClearing event. |
| OnTableNewRow | Raises the TableNewRow event. |
| ReadXmlSerializable |
| Name | Description | |
|---|---|---|
| ColumnChanged | Occurs after a value has been changed for the specified DataColumn in a DataRow. |
| ColumnChanging | Occurs when a value is being changed for the specified DataColumn in a DataRow. |
| Disposed | Adds an event handler to listen to the Disposed event on the component.(Inherited from MarshalByValueComponent.) |
| Initialized | Occurs after the DataTable is initialized. |
| RowChanged | Occurs after a DataRow has been changed successfully. |
| RowChanging | Occurs when a DataRow is changing. |
| RowDeleted | Occurs after a row in the table has been deleted. |
| RowDeleting | Occurs before a row in the table is about to be deleted. |
| TableCleared | Occurs after a DataTable is cleared. |
| TableClearing | Occurs when a DataTable is cleared. |
| TableNewRow | Occurs when a new DataRow is inserted. |
| Name | Description | |
|---|---|---|
| System.ComponentModel.IListSource.GetList | For a description of this member, see GetList. |
| System.Runtime.Serialization.ISerializable.GetObjectData | |
| System.Xml.Serialization.IXmlSerializable.GetSchema | For a description of this member, see GetSchema. |
| System.Xml.Serialization.IXmlSerializable.ReadXml | For a description of this member, see ReadXml. |
| System.Xml.Serialization.IXmlSerializable.WriteXml | For a description of this member, see WriteXml. |
| System.ComponentModel.IListSource.ContainsListCollection | For a description of this member, see ContainsListCollection. |
Community Additions
ADD
Show: