Crestron.SimplSharp.CrestronData

Classes

  ClassDescription
Public classConstraint
Represents a constraint that can be enforced on one or more DataColumn objects.
Public classConstraintCollection
Represents a collection of constraints for a DataTable.
Public classConstraintException
Represents the exception that is thrown when attempting an action that violates a constraint.
Public classDataColumn
Represents the schema of a column in a DataTable.
Public classDataColumnChangeEventArgs
Provides data for the DataTable.ColumnChanging event.
Public classDataColumnCollection
Represents a collection of DataColumn objects for a DataTable.
Public classDataException
Represents the exception that is thrown when errors are generated using ADO.NET components.
Public classDataRelation
Represents a parent/child relationship between two DataTable objects.
Public classDataRelationCollection
Represents the collection of DataRelation objects for this DataSet.
Public classDataRow
Represents a row of data in a DataTable.
Public classDataRowChangeEventArgs
Provides data for the DataTable.RowChanged, DataTable.RowChanging, DataTable.OnRowDeleting(DataRowChangeEventArgs), and DataTable.OnRowDeleted(DataRowChangeEventArgs) events.
Public classDataRowCollection
Represents a collection of rows for a DataTable.
Public classDataRowView
Represents a customized view of a DataRow.
Public classDataSet
Represents an in-memory cache of data.
Public classDataTable
Represents one table of in-memory data.
Public classDataTableClearEventArgs
Provides data for the DataTable.Clear() method.
Public classDataTableCollection
Represents the collection of tables for the DataSet.
Public classDataTableNewRowEventArgs
Provides data for the DataTable.NewRow() method.
Public classDataTableReader
The DataTableReader obtains the contents of one or more DataTable objects in the form of one or more read-only, forward-only result sets.
Public classDataView
Represents a databindable, customized view of a DataTable for sorting, filtering, searching, editing, and navigation.
Public classDataViewManager
Contains a default DataViewSettingCollection for each DataTable in a DataSet.
Public classDataViewSetting
Represents the default settings for DataView.ApplyDefaultSort, DataView.DataViewManager, DataView.RowFilter, DataView.RowStateFilter, DataView.Sort, and DataView.Table for DataViews created from the DataViewManager.
Public classDataViewSettingCollection
Contains a read-only collection of DataViewSetting objects for each DataTable in a DataSet.
Public classDBConcurrencyException
The exception that is thrown by the DataAdapter during an insert, update, or delete operation if the number of rows affected equals zero.
Public classDbException
The base class for all exceptions thrown on behalf of the data source.
Public classDeletedRowInaccessibleException
Represents the exception that is thrown when an action is tried on a DataRow that has been deleted.
Public classDuplicateNameException
Represents the exception that is thrown when a duplicate database object name is encountered during an add operation in a DataSet -related object.
Public classEvaluateException
Represents the exception that is thrown when the DataColumn.Expression property of a DataColumn cannot be evaluated.
Public classFillErrorEventArgs
Provides data for the DataAdapter.FillError event of a DbDataAdapter.
Public classForeignKeyConstraint
Represents an action restriction enforced on a set of columns in a primary key/foreign key relationship when a value or row is either deleted or updated.
Public classInRowChangingEventException
Represents the exception that is thrown when you call the DataRow.EndEdit() method within the DataTable.RowChanging event.
Public classInternalDataCollectionBase
Provides the base functionality for creating collections.
Public classInvalidConstraintException
Represents the exception that is thrown when incorrectly trying to create or access a relation.
Public classInvalidExpressionException
Represents the exception that is thrown when you try to add a DataColumn that contains an invalid DataColumn.Expression to a DataColumnCollection.
Public classMergeFailedEventArgs
Occurs when a target and source DataRow have the same primary key value, and the DataSet.EnforceConstraints property is set to true.
Public classMissingPrimaryKeyException
Represents the exception that is thrown when you try to access a row in a table that has no primary key.
Public classNoNullAllowedException
Represents the exception that is thrown when you try to insert a null value into a column where DataColumn.AllowDBNull is set to false.
Public classPropertyCollection
Represents a collection of properties that can be added to DataColumn, DataSet, or DataTable.
Public classReadOnlyException
Represents the exception that is thrown when you try to change the value of a read-only column.
Public classRowNotInTableException
Represents the exception that is thrown when you try to perform an operation on a DataRow that is not in a DataTable.
Public classStateChangeEventArgs
Provides data for the state change event of a .NET Framework data provider.
Public classStrongTypingException
The exception that is thrown by a strongly typed DataSet when the user accesses a DBNull value.
Public classSyntaxErrorException
Represents the exception that is thrown when the DataColumn.Expression property of a DataColumn contains a syntax error.
Public classUniqueConstraint
Represents a restriction on a set of columns in which all values must be unique.
Public classVersionNotFoundException
Represents the exception that is thrown when you try to return a version of a DataRow that has been deleted.

Interfaces

  InterfaceDescription
Public interfaceIColumnMapping
Associates a data source column with a DataSet column, and is implemented by the DataColumnMapping class, which is used in common by .NET Framework data providers.
Public interfaceIColumnMappingCollection
Contains a collection of DataColumnMapping objects, and is implemented by the DataColumnMappingCollection, which is used in common by .NET Framework data providers.
Public interfaceIDataAdapter
Allows an object to implement a DataAdapter, and represents a set of methods and mapping action-related properties used to fill and refresh a DataSet and update a data source.
Public interfaceIDataParameter
Represents a parameter to a Command object, and optionally, its mapping to DataSet columns; and is implemented by .NET Framework data providers that access data sources.
Public interfaceIDataParameterCollection
Collects all parameters relevant to a Command object and their mappings to DataSet columns, and is implemented by .NET Framework data providers that access data sources.
Public interfaceIDataReader
Provides a means of reading one or more forward-only streams of result sets obtained by executing a command at a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDataRecord
Provides access to the column values within each row for a DataReader, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDbCommand
Represents an SQL statement that is executed while connected to a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDbConnection
Represents an open connection to a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDbDataAdapter
Represents a set of command-related properties that are used to fill the DataSet and update a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceIDbDataParameter
Used by the Visual Basic .NET Data Designers to represent a parameter to a Command object, and optionally, its mapping to DataSet columns.
Public interfaceIDbTransaction
Represents a transaction to be performed at a data source, and is implemented by .NET Framework data providers that access relational databases.
Public interfaceITableMapping
Associates a source table with a table in a DataSet, and is implemented by the DataTableMapping class, which is used in common by .NET Framework data providers.
Public interfaceITableMappingCollection
Contains a collection of TableMapping objects, and is implemented by the DataTableMappingCollection, which is used in common by

Delegates

  DelegateDescription
Public delegateDataColumnChangeEventHandler
Represents the method that will handle the DataTable.ColumnChanging event.
Public delegateDataRowChangeEventHandler
Represents the method that will handle the DataTable.RowChanging, DataTable.RowChanged, DataTable.RowDeleting, and DataTable.RowDeleted events of a DataTable.
Public delegateDataTableClearEventHandler
Represents the method that handles the DataTable.Clear() method.
Public delegateDataTableNewRowEventHandler
Represents the method that handles the DataTable.NewRow() method.
Public delegateFillErrorEventHandler
Represents the method that will handle the DataAdapter.FillError event.
Public delegateMergeFailedEventHandler
Represents the method that will handle the DataSet.MergeFailed event.
Public delegateStateChangeEventHandler
Represents the method that will handle the DbConnection.StateChange event.

Enumerations

  EnumerationDescription
Public enumerationAcceptRejectRule
Determines the action that occurs when the DataSet.AcceptChanges() or DataTable.RejectChanges() method is invoked on a DataTable with a ForeignKeyConstraint.
Public enumerationCommandBehavior
Provides a description of the results of the query and its effect on the database.
Public enumerationCommandType
Specifies how a command string is interpreted.
Public enumerationConflictOption
Specifies how conflicting changes to the data source will be detected and resolved.
Public enumerationConnectionState
Describes the current state of the connection to a data source.
Public enumerationDataRowAction
Describes an action performed on a DataRow.
Public enumerationDataRowState
Gets the state of a DataRow object.
Public enumerationDataRowVersion
Describes the version of a DataRow.
Public enumerationDataSetDateTime
Describes the serialization format for System.DateTime columns in a DataSet.
Public enumerationDataViewRowState
Describes the version of data in a DataRow.
Public enumerationDbType
Specifies the data type of a field, a property, or a Parameter object of a .NET Framework data provider.
Public enumerationIsolationLevel
Specifies the transaction locking behavior for the connection.
Public enumerationLoadOption
Controls how the values from the data source will be applied to existing rows when using the Overload:DataTable.Load or Overload:DataSet.Load method.
Public enumerationMappingType
Specifies how a DataColumn is mapped.
Public enumerationMissingMappingAction
Determines the action that occurs when a mapping is missing from a source table or a source column.
Public enumerationMissingSchemaAction
Specifies the action to take when adding data to the DataSet and the required DataTable or DataColumn is missing.
Public enumerationParameterDirection
Specifies the type of a parameter within a query relative to the DataSet.
Public enumerationRule
Indicates the action that occurs when a ForeignKeyConstraint is enforced.
Public enumerationSchemaType
Specifies how to handle existing schema mappings when performing a DataAdapter.FillSchema(DataSet,SchemaType) operation.
Public enumerationStatementType
Specifies the type of SQL query to be used by the OleDb.OleDbRowUpdatedEventArgs, OleDb.OleDbRowUpdatingEventArgs, SqlClient.SqlRowUpdatedEventArgs, or SqlClient.SqlRowUpdatingEventArgs class.
Public enumerationUpdateRowSource
Specifies how query command results are applied to the row being updated.
Public enumerationUpdateStatus
Specifies the action to take with regard to the current and remaining rows during an DbDataAdapter.Update(DataSet).