ASP.NET by Example

2017-07-07 02:10:07

I l @ ve RuBoard

`System.Data` Namespace

The System.Data namespace consists mainly of classes that make up ADO.NET. ADO.NET allows a developer to build components that manage data from data sources.

`DataColumn` Object Members

The DataColumn class represents the schema of a column in a DataTable object. Tables B.1 through B.4 list the constructor, properties, and methods for the DataColumn class.

Table B.1. `DataColumn` Constructor

Name	Parameters	Description
`DataColumn`	none	Initializes a new instance of the `DataColumn` class.
`DataColumn`	`columnName (String)`	Initializes a new instance of the `DataColumn` class with the specified name.
`DataColumn`	`columnName (String)` `dataType (Type)`	Initializes a new instance of the `DataColumn` class with the specified name and data type.
`DataColumn`	`columnName (String)` `dataType (Type)` `expr (String)`	Initializes a new instance of the `DataColumn` class with the specified name, data type, and expression.
`DataColumn`	`columnName (String)` `dataType (Type)` `expr (String)` `type (MappingType)`	Initializes a new instance of the `DataColumn` class with the specified name, data type, expression, and value that determines whether the column is an attribute.

Table B.2. `DataColumn` Properties

Name	Type	Description
`AllowDBNull`	`Boolean`	Retrieves or sets a value indicating whether null values are allowed in this column for rows in this table.
`AutoIncrement`	`Boolean`	Retrieves or sets a value indicating whether the column automatically increments the value of the column for new rows added to the table.
`AutoIncrementSeed`	`Long`	Retrieves or sets the starting value for a column that has its `AutoIncrement` property set to true.
`AutoIncrementStep`	`Long`	Retrieves or sets the increment used by a column with its `AutoIncrement` property set to true.
`Caption`	`String`	Retrieves or sets the caption for this column.
`ColumnMapping`	`MappingType`	Retrieves or sets the `MappingType` of the column.
`ColumnName`	`String`	Retrieves or sets the name of the column within the collection.
`Container`	`IContainer`	Retrieves the container for the component.
`DataType`	`Type`	The type of data stored in the column.
`DefaultValue`	`Object`	Retrieves or sets the default value for the column when creating new rows.
`DesignMode`	`Boolean`	Retrieves a value indicating of the component is in design mode.
`Expression`	`String`	Retrieves or sets the expression used to either filter rows, calculate the column's value, or create an aggregate column.
`ExtendedProperties`	`Property Collection`	Retrieves the collection of custom user information.
`Namespace`	`String`	Gets or sets the namespace of the `DataColumn` .
`Ordinal`	`Integer`	Retrieves the position of the column in the collection.
`Prefix`	`String`	Gets or sets the XML prefix that aliases the `DataTable's` namespace.
`ReadOnly`	`Boolean`	Retrieves or sets a value indicating whether the column allows changes after a row has been added to the table.
`Site`	`ISite`	Retrieves or sets the site of the component.
`Table`	`DataTable`	Retrieves the `DataTable` the column belongs to.
`Unique`	`Boolean`	Retrieves or sets a value indicating whether the values in each row must be unique.

Table B.3. `DataColumn` Methods

Name	Parameters	Description
`Dispose`	none	Disposes the component.
`Dispose`	disposing (Boolean)	Releases the unmanaged resources used by the `MarshalByValue` `Component` and optionally releases the managed resources.
`Equals`	`obj (Object)`	Determines whether the specified object is the same instance as the current object.
`Equals`	`objA (Object)` `objB (Object)`	Determines if the specified object instances are equal.
`GetHashCode`	none	Serves as a hash function for a particular type.
`GetService`	`service (Type)`	Gets the implementer of the IServiceProvider.
`GetType`	none	Retrieves the type of the object.
`ToString`	none	Returns a string that represents the current object.

Table B.4. `DataColumn` Event

Name	Description
`Disposed`	Adds an event handler to listen to the Disposed event of the component.

`DataRow` Object Members

The DataRow class represents a row of data in a DataTable . Tables B.5 and B.6 list the properties and methods for the DataRow class.

Table B.5. `DataRow` Properties

Name	Type	Description
`HasErrors`	`Boolean`	Retrieves a value indicating whether there are errors in the collection.
`Item`	`Object`	Retrieves or sets data stored in the column.
`ItemArray`	`Object`	Retrieves or sets all the values for this row through an array.
`RowError`	`String`	Retrieves or sets the custom error description for a row.
`RowState`	`DataRowState`	Retrieves the current state of the row in regard to its relationship to the `RowsCollection` .
`Table`	`DataTable`	Retrieves the `DataTable` for which this row has a schema.

Table B.6. `DataRow` Methods

Name	Parameters	Description
`AcceptChanges`	none	Commits all changes made to this row since the last time this method was called.
`BeginEdit`	none	Begins an edit operation on a `DataRow` object.
`CancelEdit`	none	Cancels the current edit on the row.
`ClearErrors`	none	Clears the errors for the row, including the RowError and errors set with SetColumnError.
`Delete`	none	Deletes the row.
`EndEdit`	none	End the edit occurring for this row.
`Equals`	`obj (Object)`	Determines whether the specified object is the same instance as the current object.
`Equals`	`objA (Object)` `objB (Object)`	Determines if the specified object instances are equal.
`GetChildRows`	`relation (DataRelation)`	Retrieves the child rows of this `DataRow` using the specified `DataRelation` .
`GetChildRows`	`relationName (String)`	Retrieves the child rows of this `DataRow` using the named `DataRelation` .
`GetChildRows`	`relation (DataRelation)` `version DataRowVersion`	Retrieves the child rows of this `DataRow` using the specified `DataRelation` and `(DataRowVersion)` .
`GetChildRows`	`relationName (String)` `version (DataRowVersion)`	Retrieves the specified version of the child rows using the specified `DataRelation` .
`GetColumnError`	`columnIndex (Integer)`	Retrieves the error description for the column using the specified index.
`GetColumnError`	`columnName (String)`	Retrieves the error description for the column using the specified name.
`GetColumnError`	`column (DataColumn)`	Retrieves the error description for the column using the specified `DataColumn` .
`GetColumnsInError`	none	Retrieves an array of columns that have errors.
`GetHashCode`	none	Serves as a hash function for a particular type.
`GetParentRow`	`relationName (String)`	Retrieves the parent row of a `DataRow` using the specified relation name.
`GetParentRow`	`relation (DataRelation)`	Retrieves the parent row of a `DataRow` using the specified `DataRelation` .
`GetParentRow`	`relationName (String)` `version (DataRowVersion)`	Retrieves the parent row of a `DataRow` using the specified relation name and the specified `DataRowVersion` .
`GetParentRow`	`relation (DataRelation)` `version (DataRowVersion)`	Retrieves the parent row of a `DataRow` using the specified `DataRelation` and the specified `DataRowVersion` .
`GetParentRows`	`relation (DataRelation)`	Retrieves the parent rows of a `DataRow` , using the specified `DataRelation` .
`GetParentRows`	`relationName (String)`	Retrieves the parent rows of a `DataRow` , using the specified relation name.
`GetParentRows`	`relationName (String)` `version (DataRowVersion)`	Retrieves the parent rows of a `DataRow` , using the specified relation name and the specified `DataRowVersion` .
`GetParentRows`	`relation (DataRelation)` `version (DataRowVersion)`	Retrieves the parent rows of a `DataRow` , using the specified `DataRelation` and the specified `DataRowVersion` .
`GetType`	none	Retrieves the type of the object.
`HasVersion`	`version (DataRowVersion)`	Retrieves a value indicating whether a specified version exists.
`IsNull`	`column (DataColumn)`	Retrieves a value indicating whether the specified `DataColumn` contains a null value.
`IsNull`	`columnName (String)`	Retrieves a value indicating whether the specified named column contains a null value.
`IsNull`	`columnIndex (Integer)`	Retrieves a value indicating whether the column with the specified index contains a null value.
`IsNull`	`column (DataColumn)` `Version (DataRowVersion)`	Gets a value indicating whether the specified `DataColumn` and `DataRowVersion` contains a null value.
`RejectChanges`	none	Rejects all changes made to the row since the `AcceptChanges` method was last called.
`SetColumnError`	`columnName (String)` `error (String)`	Sets the error description for a specified named column.
`SetColumnError`	`column (DataColumn)` `error (String)`	Sets the error description for a specified `DataColumn` .
`SetColumnError`	`columnIndex (Integer)` `error (String)`	Sets the error description for a column with a specified index.
`SetParentRow`	`parentRow (DataRow)`	Sets the parent row of a DataRow with the specified DataRow.
`SetParentRow`	`parentRow (DataRow)` `relation (DataRelation)`	Sets the parent row of a specified `DataRow` with the specified `DataRow` and `DataRelation` .
`SetUnspecified`	`column (DataColumn)`	Sets the value of a `DataColumn` with the specified name to unspecified.
`ToString`	none	Returns a string that represents the current object.

`DataSet` Object Members

The DataSet class represents an in-memory cache of data. Tables B.7 through B.10 list the constructor, properties, methods, and events for the DataSet class.

Table B.7. `DataSet` Constructor

Name Parameters Description

DataSet none Initializes a new instance of the DataSet class.

DataSet

info (SerializationInfo)

context (StreamingContext)

Initializes a new DataSet class with the SerializationInfo and StreamingContext .

DataSet name (String) Initializes a new instance of the DataSet class with the specified name.

Table B.8. `DataSet` Properties

Name	Type	Description
`CaseSensitive`	`Boolean`	Retrieves or sets a value indicating whether string comparisons within `DataTable` objects are case sensitive.
`Container`	`IContainer`	Retrieves the container for the component.
`DataSetName`	`String`	Retrieves or sets the name of the `DataSet` .
`DefaultViewManager`	`DataViewManager`	Retrieves a custom view of the data contained by the `DataSet` .
`DesignMode`	`Boolean`	Retrieves a value indicating the component is in design mode.
`EnforceConstraints`	`Boolean`	Retrieves or sets a value indicating whether constraint rules are followed when an update operation is performed.
`ExtendedProperties`	`PropertyCollection`	Retrieves the collection of custom user information.
`HasErrors`	`Boolean`	Retrieves a value indicating whether there are errors in any of the rows in any of the tables of this `DataSet` .
`Locale`	`CultureInfo`	Retrieves or sets the locale information used to compare strings within the table.
`NameSpace`	`String`	Retrieves or sets the namespace of the `DataSet` .
`Prefix`	`String`	Retrieves or sets an XML prefix that aliases the namespace of the `DataSet` .
`Relations`	Data `RelationCollection`	Retrieves the collection of relations that link tables and allow navigation from parent tables to child tables.
`Site`	`ISite`	Retrieves or sets the site of the component.
`Tables`	Data `TableCollection`	Retrieves the collection of tables contained in the `DataSet` .

Table B.9. `DataSet` Methods

Name	Parameters	Description
`AcceptChanges`	none	Commits all changes made to this `DataSet` since it was loaded or the last time the `AcceptChanges` method was called.
`BeginInit`	none	Begins the initialization of a `DataSet` that is used on a form or used by another component.
`Clear`	none	Clears the `DataSet` of all data.
`Clone`	none	Clones the structure of the `DataSet` .
`Copy`	none	Copies both the structure and data for this `DataSet` .
`Dispose`	none	Releases the resources used by the MarshalByValueComponent.
`Equals`	`obj (Object)`	Determines whether the specified object is the same instance as the current object.
`Equals`	`objA (Object)` `objB (Object)`	Determines if the specified object instances are equal.
`GetChanges`	none	Returns a copy of the `DataSet` that contains all changes made to the `DataSet` since it was loaded or the `AcceptChanges` method was called.
`GetChanges`	`rowStates (DataRowState)`	Returns a copy of the `DataSet` that contains all changes made to the `DataSet` since it was loaded or the `AcceptChanges` method was called, filtered by `DataRowState` .
`GetHashCode`	none	Serves as a hash function for a particular type.
`GetService`	`service (Type)`	Get the implementer of the IServiceProvider.
`GetType`	none	Retrieves the type of the object.
`GetXml`	none	Retrieves an xml representation of the data stored in the `DataSet` .
`GetXmlSchema`	none	Retrieves the XSD schema for the XML representation of the data in the `DataSet` .
`HasChanges`	none	Retrieves a value indicating whether the `DataSet` has changes.
`HasChanges`	`rowStates (DataRowState)`	Retrieves a value indicating whether the `DataSet` has changes, filtered by `DataRowState` .
`InferXmlSchema`	`stream (Stream)` `nsArray[] (String)`	Infers the XML schema from the specified Stream object into the `DataSet` .
`InferXmlSchema`	`fileName (String)` `nsArray[] (String)`	Infers the XML schema from the specified file into the `DataSet` .
`InferXmlSchema`	`reader (TextReader)` `nsArray[] (String)`	Infers the XML schema from the specified `TextReader` into the `DataSet` .
`InferXmlSchema`	`reader (XmlReader)` `nsArray[] (String)`	Infers the XML schema from the specified `TextReader` into the `DataSet` .
`Merge`	`rows[] (DataRow)`	Merges the `DataSet` with an array of `DataRow` objects.
`Merge`	`table (DataTable)`	Merges the `DataSet` with a specified `DataTable` .
`Merge`	`dataSet (DataSet)`	Merges the `DataSet` into a specified `DataSet` .
`Merge`	`dataSet (DataSet)` `preserveChanges (Boolean)`	Merges the `DataSet` with a specified `DataSet` , preserving changes according to the specified argument.
`Merge`	`rows[] (DataRow)` `preserveChanges (Boolean)` `missingSchemaAction (MissingSchemaAction)`	Merges the `DataSet` with an array of `DataRow` objects, preserving changes, and handling incompatible schema according to the specified arguments.
`Merge`	`dataSet (DataSet)` `preserveChanges (Boolean)` `missingSchemaAction (MissingSchemaAction)`	Merges the `DataSet` with a specified `DataSet` , preserving changes, and handling incompatible schema according to the specified arguments.
`Merge`	`table (DataTable)` `preserveChanges (Boolean)` `missingSchemaAction (MissingSchemaAction)`	Merges the `DataSet` with a specified `DataTable` , preserving changes, and handling incompatible schema according to the specified arguments.
`ReadXml`	`reader (XmlReader)`	Reads XML schema and data into the `DataSet` using the specified `XMLReader` object.
`ReadXml`	`stream (Stream)`	Reads XML schema and data into the `DataSet` using the specified `Stream` object.
`ReadXml`	`reader (TextReader)`	Reads XML schema and data into the `DataSet` using the specified `TextReader` object.
`ReadXml`	`fileName (String)`	Reads XML schema and data into the `DataSet` using the specified file.
`ReadXml`	`stream (Stream)` `Mode (XmlReadMode)`	Reads XML schema and data into the `DataSet` using the specified Stream and XmlReadMode.
`ReadXml`	`fileName (String)` `Mode (XmlReadMode)`	Reads XML schema and data into the `DataSet` using the specified file and XmlReadMode.
`ReadXml`	`reader (TextReader)` `Mode (XmlReadMode)`	Reads XML schema and data into the `DataSet` using the specified TextReader and XmlReadMode.
`ReadXml`	`reader (XmlReader)` `Mode (XmlReadMode)`	Reads XML schema and data into the `DataSet` using the specified XmlReader and XmlReadMode.
`ReadXmlSchema`	`reader (XmlReader)`	Reads the XML schema into the `DataSet` from the specified `XmlReader` object.
`ReadXmlSchema`	`stream (Stream)`	Reads the XML schema into the `DataSet` from the specified `Stream` object.
`ReadXmlSchema`	`reader (TextReader)`	Reads the XML schema into the `DataSet` from the specified `TextReader` object.
`ReadXmlSchema`	`fileName (String)`	Reads the XML schema into the `DataSet` from the specified file.
`RejectChanges`	none	Rolls back all changes made to the `DataSet` since it was loaded or the last time the `AcceptChanges` method was called.
`Reset`	none	Resets the DataSet to its original state.
`ToString`	none	Returns a string that represents the current object.
`WriteXml`	`writer (XmlWriter)`	Writes the current schema and data for the `DataSet` using the specified `XMLWriter` object.
`WriteXml`	`fileName (String)`	Writes the current schema and data for the `DataSet` using the specified file.
`WriteXml`	`stream (Stream)`	Writes the current schema and data for the `DataSet` using the specified `Stream` object.
`WriteXml`	`writer (TextWriter)`	Writes the current schema and data for the `DataSet` using the specified `TextWriter` object.
`WriteXml`	`stream (Stream)` `mode (XmlWriteMode)`	Reads XML schema and data into the `DataSet` using the specified XmlReader and XmlReadMode.
`WriteXml`	`fileName (String)` `mode (XmlWriteMode)`	Reads XML schema and data into the `DataSet` using the specified XmlReader and XmlReadMode.
`WriteXml`	`writer (TextWriter)` `mode (XmlWriteMode)`	Reads XML schema and data into the `DataSet` using the specified XmlReader and XmlReadMode.
`WriteXml`	`writer (XmlWriter)` `mode (XmlWriteMode)`	Reads XML schema and data into the `DataSet` using the specified XmlReader and XmlReadMode.
`WriteXmlSchema`	`writer (TextWriter)`	Writes the `DataSet` structure as an XML schema to the specified `TextWriter` object.
`WriteXmlSchema`	`stream (Stream)`	Writes the `DataSet` structure as an XML schema to the specified `Stream` object.
`WriteXmlSchema`	`fileName (String)`	Writes the `DataSet` structure as an XML schema to the specified file.
`WriteXmlSchema`	`writer (XMLWriter)`	Writes the `DataSet` structure as an XML schema to the `XMLWriter` object.

Table B.10. `DataSet` Events

Name	Description
`MergeFailed`	Fires when a target and source `DataRow` have the same primary key value and `EnforceConstraints` is set to true.
`Disposed`	Adds an event handler to listen to the Dispose event on the component.

`DataTable` Object Members

The DataTable class represents one table of in-memory data. Tables B.11 through B.14 list the constructor, properties, methods, and events of the DataTable class.

Table B.11. `DataTable` Constructor

Name Parameters Description

DataTable none Initializes a new instance of the DataTable class.

DataTable tableName (String) Initializes a new instance of the DataTable class with the specified name.

DataTable

info (SerializationInfo)

context (StreamingContext)

Initializes a new instance of the DataTable class with the SerializationInfo and StreamingContext.

Table B.12. `DataTable` Properties

Name	Type	Description
`CaseSensitive`	`Boolean`	Indicates whether string comparisons within the table are case sensitive.
`ChildRelations`	Data `RelationCollection`	Retrieves the collection of child relations for the `DataTable` .
`Columns`	Data `ColumnCollections`	Retrieves the collection of columns for the `DataTable` .
`Constraints`	`ConstraintCollection`	Retrieves the collection of constraints for the `DataTable` .
`Container`	`IContainer`	Retrieves the container for the component.
`DataSet`	`DataSet`	Retrieves the `DataSet` that the table belongs to.
`DefaultView`	`DataView`	Retrieves a customized view of the table.
`DesignMode`	`Boolean`	Retrieves a value indicating whether the component is in design mode.
`DisplayExpression`	`String`	Retrieves or sets the expression that will return a value used to represent the table in the UI.
`ExtendedProperties`	`PropertyCollection`	Retrieves the collection of customized user information.
`HasErrors`	`Boolean`	Retrieves a value indicating whether there are errors in any of the rows in the tables in the `DataSet` to which the table belongs.
`Locale`	`CultureInfo`	Retrieves or sets the locale information used to compare strings within the table.
`MinimumCapacity`	`Integer`	Retrieves or sets the initial beginning capacity for the table.
`Namespace`	`String`	Retrieves or sets the namespace for the `DataTable` .
`ParentRelations`	Data `RelationCollection`	Retrieves the collection of parent relations for the `DataTable` .
`Prefix`	`String`	Gets or sets the namespace for the XML representation of the data stored in the `DataTable` .
`PrimaryKey`	`DataColumn`	Retrieves or sets an array of columns that function as primary keys for the `DataTable` .
`Rows`	Data `RowCollection`	Retrieves the collection of rows that belong to this table.
`Site`	`ISite`	Retrieves or sets the site of the component.
`TableName`	`String`	Retrieves or sets the table name.

Table B.13. `DataTable` Methods

Name	Parameters	Description
`AcceptChanges`	none	Commits all changes made to this table since the last time the `AcceptChanges` method was called.
`BeginInit`	none	Begins the initialization of a `DataTable` that is used on a form or used by another component.
`Clear`	none	Clears the table of all data.
`Clone`	none	Clones the structure of the DataTable, including all schemas, relations, and constraints.
`Compute`	`expression (String)` `filter (String)`	Computes the specified expression on the current rows that pass the filter criteria.
`Dispose`	none	Disposes the component.
`Dispose`	`disposing (Boolean)`	Releases the unmanaged resources used by the `MarshalByValueComponent` and optionally releases the managed resources.
`EndInit`	none	Ends the initialization of a `DataTable` that is used on a form or is used by another component.
`Equals`	`obj (Object)`	Determines whether the specified object is the same instance as the current object.
`Equals`	`objA (Object)` `objB (Object)`	Determines if the specified object instances are equal.
`GetChanges`	none	Gets a copy of the `DataTable` that contains all the changes made to it since it was loaded or `AcceptChanges` was last called.
`GetChanges`	`rowState (DataRowState)`	Gets a copy of the `DataTable` that contains all the changes made to it since it was loaded or `AcceptChanges` was last called, filtered by `DataRowState` .
`GetErrors`	none	Returns an array of `DataRow` objects that contain errors.
`GetHashCode`	none	Serves as a hash function for a particular type.
`GetService`	`service (Type)`	Returns the implementer of the IServiceProvider.
`GetType`	none	Retrieves the type of the object.
`ImportRow`	`row (DataRow)`	Copies a `DataRow` , including original and current values, `DataRowState` values, and errors, into a `DataTable` .
`LoadDataRow`	`values[] (Object)` `acceptChanges (Boolean)`	Finds and updates a specific row. If no matching row is found, then a new row is created using the given values.
`NewRow`	none	Creates a new `DataRow` with the same schema as the table.
`RejectChanges`	none	Rolls back all changes made to the table since the last time the `AcceptChanges` method was called.
`Select`	none	Retrieves an array of `DataRow` objects.
`Select`	`FilterExpression (String)`	Retrieves an array of `DataRow` objects that match the filter criteria ordered by the primary key.
`Select`	`FilterExpression (String)` `sort (String)`	Retrieves an array of `DataRow` objects that match the filter criteria, in the specified sort order.
`Select`	`FilterExpression (String)` `sort (String)` `recordState (DataViewRowState)`	Retrieves an array of `DataRow` objects that match the filter criteria, in the specified sort order, and that match the specified state.
`ToString`	none	Returns a string that represents the current object.

Table B.14. `DataTable` Events

Name	Description
`ColumnChanged`	Occurs after a value has been changed for the specified DataColumn in a DataRow.
`ColumnChanging`	Occurs when a value is changing for a specified DataColumn in a DataRow.
`Disposed`	Adds an event handler to listen to the Disposed event on a component.
`RowChanged`	Fires after a row value has been edited successfully.
`RowChanging`	Fires when a value for a row is changing.
`RowDeleted`	Fires after a row has been deleted.
`RowDeleting`	Fires before a row in the table is about to be deleted.

`DataView` Object Members

The DataView class represents a databindable, customized view of a DataTable . Tables B.15 through B.18 list the constructor, properties, methods, and events for the DataView class.

Table B.15. `DataView` Constructor

Name	Parameters	Description
`DataView`	none	Initializes a new instance of the `DataView` class.
`DataView`	table ( `DataTable` )	Initializes a new instance of the `DataView` class with the specified `DataTable` .

Table B.16. `DataView` Properties

Name	Type	Description
`AllowDelete`	`Boolean`	Retrieves or sets a value indicating whether deletes are allowed.
`AllowEdit`	`Boolean`	Retrieves or sets a value indicating whether edits are allowed.
`AllowNew`	`Boolean`	Retrieves or sets a value indicating whether new rows can be added.
`ApplyDefaultSort`	`Boolean`	Retrieves or sets a value indicating whether to use the default sort.
`Container`	`IContainer`	Retrieves the container for the component.
`Count`	`Integer`	Retrieves the number of records in the DataView after RowFilter and RowStateFilter have been applied.
`DataViewManager`	`DataViewManager`	Retrieves the DataView associated with this view.
`DesignMode`	`Boolean`	Retrieves a value indicating whether the component is currently in design mode.
`Item`	`DataRowView`	Retrieves a row of data from a specified table.
`RowFilter`	`String`	Retrieves or sets the expression used to filter which rows are viewed in the `DataView` .
`RowStateFilter`	`DataViewRowState`	Retrieves or sets the row state filter used in the `DataView` .
`Site`	`ISite`	Retrieves or sets the site of the component.
`Sort`	`String`	Retrieves or sets the sort column or columns and the sort order for the table.
`Table`	`DataTable`	Retrieves or sets the source table.

Table B.17. `DataView` Methods

Name	Parameters	Description
`AddNew`	none	Adds a new row to the `DataView` .
`BeginInit`	none	Begins the initialization of a `DataView` that is used on a form or used by another component.
`Delete`	`index (Integer)`	Deletes a row at the specified index.
`Dispose`	none	Disposes of the resources (other than memory) used by the DataView object.
`Dispose`	`disposing (Boolean` )	Releases the unmanaged resources used by the `MarshalByValueComponent` and optionally releases the managed resources.
`EndInit`	none	Ends the initialization of a `DataView` that is used on a form or used by another component.
`Equals`	none	Determines whether the specified object is the same instance as the current object.
`Equals`	`objA (Object)` `objB (Object)`	Determines if the specified object instances are equal.
`Find`	`key (Object)`	Finds a row in the `DataView` using the specified primary key value.
`Find`	`key[] (Object)`	Finds a row in the `DataView` using the specified primary key values.
`GetEnumerator`	none	Retrieves an enumerator for this `DataView` .
`GetHashCode`	none	Serves as a hash function for a particular type.
`GetService`	`service (Type)`	Gets the implementer of the IServiceProvider.
`GetType`	none	Retrieves the type of the object.
`ToString`	none	Returns a string that represents the current object.

Table B.18. `DataView` Events

Name	Description
`Disposed`	Adds an event handler to listen to the `Disposed` event on a component.
`ListChanged`	Fires when the list managed by the `DataView` changes.

`DataViewManager` Object Members

Contains a default DataViewSettingCollection for each DataTable in a DataSet.

Table B.19. `DataViewManager` Constructor

Name	Parameters	Description
`DataViewManager`	none	Initializes a new instance of the `DataViewManager` class.
`DataViewManager`	`dataSet` ( `DataSet` )	Initializes a new instance of the `DataViewManger` class for the specified `DataSet` .

Table B.20. `DataViewManager` Properties

Name	Type	Description
`Container`	`IContainer`	Retrieves the container for the component.
`DataSet`	`DataSet`	Retrieves or sets the name of the `DataSet` to use with the `DataViewManager` .
`DataViewSetting-CollectionString`	`String`	Retrieves or sets a value used for code persistence.
`DataViewSettings`	`DataViewSettingCollection`	Gets the `DataViewSetting-Collection` for each `DataTable` in the `DataSet` .
`DesignMode`	`Boolean`	Retrieves a value indicating whether the component is currently in design mode.
`Site`	`ISite`	Retrieves or sets the site of the component.

Table B.21. `DataViewManager` Methods

Name	Parameters	Description
`CreateDataView`	`table (DataView)`	Creates a `DataView` for the specified DataTable.
`Dispose`	none	Disposes of the resources (other than memory) used by the DataView object.
`Dispose`	`disposing (Boolean)`	Releases the unmanaged resources used by the `MarshalByValueComponent` and optionally releases the managed resources.
`Equals`	none	Determines whether the specified object is the same instance as the current object.
`Equals`	`objA (Object)` `objB (Object)`	Determines if the specified object instances are equal.
`GetHashCode`	none	Serves as a hash function for a particular type.
`GetService`	`service (Type)`	Gets the implementer of the IServiceProvider.
`GetType`	none	Retrieves the type of the object.
`ToString`	none	Returns a string that represents the current object.

Table B.22. `DataViewManager` Events

Name	Description
`Disposed`	Adds an event handler to listen to the `Disposed` event on a component.
`ListChanged`	Fires when a row is added or deleted from a DataView.

I l @ ve RuBoard

System.Data Namespace

DataColumn Object Members

Table B.1. DataColumn Constructor

Table B.2. DataColumn Properties

Table B.3. DataColumn Methods

Table B.4. DataColumn Event

DataRow Object Members

Table B.5. DataRow Properties

Table B.6. DataRow Methods

DataSet Object Members

Table B.7. DataSet Constructor

Table B.8. DataSet Properties

Table B.9. DataSet Methods

Table B.10. DataSet Events

DataTable Object Members

Table B.11. DataTable Constructor

Table B.12. DataTable Properties

Table B.13. DataTable Methods

Table B.14. DataTable Events

DataView Object Members

Table B.15. DataView Constructor

Table B.16. DataView Properties

Table B.17. DataView Methods

Table B.18. DataView Events

DataViewManager Object Members

Table B.19. DataViewManager Constructor

Table B.20. DataViewManager Properties

Table B.21. DataViewManager Methods

Table B.22. DataViewManager Events

Категории