M-Z

M-Z
Mapped

SchemaType



MappingType

System.Data



MaxLength

DataColumn



MaxPrecision

SqlDecimal



MaxScale

SqlDecimal



MaxValue

SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle



Member_Name

OleDbLiteral



Merge( )

DataSet



MergeFailed

DataSet



MergeFailedEventArgs

System.Data



MergeFailedEventHandler

System.Data



Message

OleDbError, OleDbException, OleDbInfoMessageEventArgs, SqlError, SqlException, SqlInfoMessageEventArgs



MinimumCapacity

DataTable



MinValue

SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle



MissingMappingAction

DataAdapter, IDataAdapter, System.Data



MissingPrimaryKeyException

System.Data



MissingSchemaAction

DataAdapter, IDataAdapter, System.Data



Mod( )

SqlByte, SqlInt16, SqlInt32, SqlInt64



Modified

DataRowState



ModifiedCurrent

DataViewRowState



ModifiedOriginal

DataViewRowState



Money

SqlDbType



MoveNext( )

DbEnumerator



Multiply( )

SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle



Namespace

DataColumn, DataSet, Data-Table



NativeError

OleDbError



NChar

SqlDbType



Nested

DataRelation



NewRow( )

DataTable



NewRowFromBuilder( )

DataTable



NextResult( )

IDataReader, OleDbDataReader, SqlDataReader



None

AcceptRejectRule, DataViewRowState, Rule, SqlCompareOptions, UpdateRowSource



NoNullAllowedException

System.Data



NotEquals( )

SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString



Nothing

DataRowAction



NotSupported

PropertyAttributes



NText

SqlDbType



Null

SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString



Number

SqlError, SqlException



Numeric

OleDbType



NVarChar

SqlDbType



Object

DbType



Offset

SqlParameter



OleDbCommand

System.Data.OleDb



OleDbCommandBuilder

System.Data.OleDb



OleDbConnection

System.Data.OleDb



OleDbDataAdapter

System.Data.OleDb



OleDbDataReader

System.Data.OleDb



OleDbError

System.Data.OleDb



OleDbErrorCollection

System.Data.OleDb



OleDbException

System.Data.OleDb



OleDbInfoMessageEventArgs

System.Data.OleDb



OleDbInfoMessageEventHandler

System.Data.OleDb



OleDbLiteral

System.Data.OleDb



OleDbParameter

System.Data.OleDb



OleDbParameterCollection

System.Data.OleDb



OleDbPermission

System.Data.OleDb



OleDbPermissionAttribute

System.Data.OleDb



OleDbRowUpdatedEventArgs

System.Data.OleDb



OleDbRowUpdatedEventHandler

System.Data.OleDb



OleDbRowUpdatingEventArgs

System.Data.OleDb



OleDbRowUpdatingEventHandler

System.Data.OleDb



OleDbSchemaGuid

System.Data.OleDb



OleDbTransaction

System.Data.OleDb



OleDbType

OleDbParameter, System.Data.OleDb



OnCollectionChanged( )

ConstraintCollection, DataColumnCollection, DataRelationCollection, DataTableCollection



OnColumnChanged( )

DataTable



OnColumnChanging( )

DataTable



One

SqlBoolean



OnesComplement( )

SqlBoolean, SqlByte, SqlInt16, SqlInt32, SqlInt64



OnFillError( )

DbDataAdapter



OnListChanged( )

DataView, DataViewManager



OnRemoveRelation( )

DataSet



OnRemoveTable( )

DataSet



OnRowChanged( )

DataTable



OnRowChanging( )

DataTable



OnRowDeleted( )

DataTable



OnRowDeleting( )

DataTable



OnRowUpdated( )

DbDataAdapter, OleDbDataAdapter, SqlDataAdapter



OnRowUpdating( )

DbDataAdapter, OleDbDataAdapter, SqlDataAdapter



Open

ConnectionState



Open( )

DataView, IDbConnection, OleDbConnection, SqlConnection



Optional

PropertyAttributes



Or( )

SqlBoolean



Ordinal

DataColumn



Original

DataRowVersion



OriginalRows

DataViewRowState



OriginalState

StateChangeEventArgs



Output

ParameterDirection



OutputParameters

UpdateRowSource



PacketSize

SqlConnection



ParameterDirection

System.Data



ParameterName

IDataParameter, OleDbParameter, SqlParameter



Parameters

IDbCommand, OleDbCommand, SqlCommand



ParentColumns

DataRelation



ParentKeyConstraint

DataRelation



ParentRelations

DataTable



ParentTable

DataRelation



Parse( )

SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle



Passthrough

MissingMappingAction



Power( )

SqlDecimal



Precision

IDbDataParameter, OleDbParameter, SqlDecimal, SqlParameter



Prefix

DataColumn, DataSet, DataTable



Prepare( )

IDbCommand, OleDbCommand, SqlCommand



PreventUsage

KeyRestrictionBehavior



Primary_Keys

OleDbSchemaGuid



PrimaryKey

DataTable



Procedure

SqlError, SqlException



Procedure_Columns

OleDbSchemaGuid



Procedure_Name

OleDbLiteral



Procedure_Parameters

OleDbSchemaGuid



Procedures

OleDbSchemaGuid



Property_Name

OleDbLiteral



PropertyAttributes

System.Data



PropertyChanging

DataColumn, DataRelation, DataSet, DataTable



PropertyCollection

System.Data



Proposed

DataRowVersion



ProposedValue

DataColumnChangeEventArgs



PropVariant

OleDbType



Provider

OleDbConnection, OleDbPermission, OleDbPermissionAttribute



Provider_Types

OleDbSchemaGuid



Quote_Prefix

OleDbLiteral



Quote_Suffix

OleDbLiteral



QuotePrefix

OleDbCommandBuilder, SqlCommandBuilder



QuoteSuffix

OleDbCommandBuilder, SqlCommandBuilder



Read

PropertyAttributes



Read( )

IDataReader, OleDbDataReader, SqlDataReader



ReadCommitted

IsolationLevel



ReadOnly

DataColumn



ReadOnlyException

System.Data



ReadSchema

XmlReadMode



ReadUncommitted

IsolationLevel



ReadXml( )

DataSet



ReadXmlSchema( )

DataSet



ReadXmlSerializable( )

DataSet



Real

SqlDbType



RecordsAffected

IDataReader, OleDbDataReader, RowUpdatedEventArgs, SqlDataReader



Referential_Constraints

OleDbSchemaGuid



RefreshSchema( )

OleDbCommandBuilder, SqlCommandBuilder



RejectChanges( )

DataRow, DataSet, Data-Table



RelatedColumns

ForeignKeyConstraint



RelatedTable

ForeignKeyConstraint



RelationCollectionChanged( )

DataViewManager



RelationName

DataRelation



Relations

DataSet



ReleaseObjectPool( )

OleDbConnection



Remove( )

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataRowCollection, DataTableCollection, DataTableMappingCollection, OleDbParameterCollection, SqlParameterCollection



RemoveAt( )

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataRowCollection, DataTableCollection, DataTableMappingCollection, IColumnMappingCollection, IDataParameterCollection, ITableMappingCollection, OleDbParameterCollection, SqlParameterCollection



RemoveCore( )

DataRelationCollection



RepeatableRead

IsolationLevel



Required

PropertyAttributes



Reset( )

DataSet, DataTable, DataView, DbEnumerator



ResetCommandTimeout( )

OleDbCommand, SqlCommand



ReturnValue

ParameterDirection



Rollback

DataRowAction



Rollback( )

IDbTransaction, OleDbTransaction, SqlTransaction



Round( )

SqlDecimal



Row

DataColumnChangeEventArgs, DataRowChangeEventArgs, DataRowView, DBConcurrencyException, RowUpdatedEventArgs, RowUpdatingEventArgs



RowChanged

DataTable



RowChanging

DataTable



RowDeleted

DataTable



RowDeleting

DataTable



RowError

DataRow



RowFilter

DataView, DataViewSetting



RowNotInTableException

System.Data



Rows

DataTable



RowState

DataRow



RowStateFilter

DataView, DataViewSetting



RowUpdated

OleDbDataAdapter, SqlDataAdapter



RowUpdatedEventArgs

System.Data.Common



RowUpdating

OleDbDataAdapter, SqlDataAdapter



RowUpdatingEventArgs

System.Data.Common



RowVersion

DataRowView



Rule

System.Data



Save( )

SqlTransaction



SByte

DbType



Scale

IDbDataParameter, OleDbParameter, SqlDecimal, SqlParameter



Schema_Name

OleDbLiteral



Schema_Separator

OleDbLiteral



SchemaOnly

CommandBehavior



Schemata

OleDbSchemaGuid



SchemaType

System.Data



Select

StatementType



Select( )

DataTable



SelectCommand

IDbDataAdapter, OleDbDataAdapter, SqlDataAdapter



SequentialAccess

CommandBehavior



Serializable

IsolationLevel



Server

SqlError, SqlException



ServerVersion

OleDbConnection, SqlConnection



SetColumnError( )

DataRow



SetDefault

Rule



SetNull

Rule



SetNull( )

DataRow



SetParentRow( )

DataRow



ShouldSerializeRelations( )

DataSet



ShouldSerializeTableMappings( )

DataAdapter



ShouldSerializeTables( )

DataSet



Sign( )

SqlDecimal



SimpleContent

MappingType



Single

DbType, OleDbType



SingleResult

CommandBehavior



SingleRow

CommandBehavior



Site

DataSet, DataTable



Size

IDbDataParameter, OleDbParameter, SqlParameter



SkipAllRemainingRows

UpdateStatus



SkipCurrentRow

UpdateStatus



SmallDateTime

SqlDbType



SmallInt

OleDbType, SqlDbType



SmallMoney

SqlDbType



Sort

DataView, DataViewSetting



Source

OleDbError, OleDbException, OleDbInfoMessageEventArgs, SchemaType, SqlError, SqlException, SqlInfoMessageEventArgs



SourceColumn

DataColumnMapping, IColumnMapping, IDataParameter, OleDbParameter, SqlParameter



SourceTable

DataTableMapping, ITableMapping



SourceVersion

IDataParameter, OleDbParameter, SqlParameter



Sql_Languages

OleDbSchemaGuid



SqlBinary

System.Data.SqlTypes



SqlBoolean

System.Data.SqlTypes



SqlByte

System.Data.SqlTypes



SqlClientPermission

System.Data.SqlClient



SqlClientPermissionAttribute

System.Data.SqlClient



SqlCommand

System.Data.SqlClient



SqlCommandBuilder

System.Data.SqlClient



SqlCompareOptions

SqlString, System.Data.SqlTypes



SqlConnection

System.Data.SqlClient



SqlDataAdapter

System.Data.SqlClient



SqlDataReader

System.Data.SqlClient



SqlDateTime

System.Data.SqlTypes



SqlDbType

SqlParameter, System.Data



SQLDebugging

System.Data.SqlClient



SqlDecimal

System.Data.SqlTypes



SqlDouble

System.Data.SqlTypes



SqlError

System.Data.SqlClient



SqlErrorCollection

System.Data.SqlClient



SqlException

System.Data.SqlClient



SqlGuid

System.Data.SqlTypes



SqlInfoMessageEventArgs

System.Data.SqlClient



SqlInfoMessageEventHandler

System.Data.SqlClient



SqlInt16

System.Data.SqlTypes



SqlInt32

System.Data.SqlTypes



SqlInt64

System.Data.SqlTypes



SqlMoney

System.Data.SqlTypes



SqlNullValueException

System.Data.SqlTypes



SqlParameter

System.Data.SqlClient



SqlParameterCollection

System.Data.SqlClient



SqlRowUpdatedEventArgs

System.Data.SqlClient



SqlRowUpdatedEventHandler

System.Data.SqlClient



SqlRowUpdatingEventArgs

System.Data.SqlClient



SqlRowUpdatingEventHandler

System.Data.SqlClient



SqlSingle

System.Data.SqlTypes



SQLState

OleDbError



SqlString

System.Data.SqlTypes



SQLTicksPerHour

SqlDateTime



SQLTicksPerMinute

SqlDateTime



SQLTicksPerSecond

SqlDateTime



SqlTransaction

System.Data.SqlClient



SqlTruncateException

System.Data.SqlTypes



SqlTypeException

System.Data.SqlTypes



State

IDbConnection, OleDbConnection, SqlConnection, SqlError, SqlException



StateChange

OleDbConnection, SqlConnection



StateChangeEventArgs

System.Data



StateChangeEventHandler

System.Data



StatementType

RowUpdatedEventArgs, RowUpdatingEventArgs, System.Data



Statistics

OleDbSchemaGuid



Status

RowUpdatedEventArgs, RowUpdatingEventArgs



StoredProcedure

CommandType



String

DbType



StringFixedLength

DbType



StrongTypingException

System.Data



Subtract( )

SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle



SyncRoot

DataViewSettingCollection, InternalDataCollectionBase



SyntaxErrorException

System.Data



Table

Constraint, DataColumn, DataRow, DataView, DataViewSetting, ForeignKeyConstraint, MergeFailedEventArgs, UniqueConstraint



Table_Constraints

OleDbSchemaGuid



Table_Name

OleDbLiteral



Table_Privileges

OleDbSchemaGuid



Table_Statistics

OleDbSchemaGuid



TableCollectionChanged( )

DataViewManager



TableDirect

CommandType



TableMapping

RowUpdatedEventArgs, RowUpdatingEventArgs



TableMappings

DataAdapter, IDataAdapter



TableName

DataTable



Tables

DataSet, OleDbSchemaGuid



Tables_Info

OleDbSchemaGuid



Text

CommandType, SqlDbType



Text_Command

OleDbLiteral



Time

DbType



Timestamp

SqlDbType



TimeTicks

SqlDateTime



TinyInt

OleDbType, SqlDbType



ToByteArray( )

SqlGuid



ToDecimal( )

SqlMoney



ToDouble( )

SqlDecimal, SqlMoney



ToInt32( )

SqlMoney



ToInt64( )

SqlMoney



ToSqlBinary( )

SqlGuid



ToSqlBoolean( )

SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString



ToSqlByte( )

SqlBoolean, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString



ToSqlDateTime( )

SqlString



ToSqlDecimal( )

SqlBoolean, SqlByte, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString



ToSqlDouble( )

SqlBoolean, SqlByte, SqlDecimal, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString



ToSqlGuid( )

SqlBinary, SqlString



ToSqlInt16( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt32, SqlInt64, SqlMoney, SqlSingle, SqlString



ToSqlInt32( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt64, SqlMoney, SqlSingle, SqlString



ToSqlInt64( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlMoney, SqlSingle, SqlString



ToSqlMoney( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlSingle, SqlString



ToSqlSingle( )

SqlBoolean, SqlByte, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlString



ToSqlString( )

SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle



ToString( )

Constraint, DataColumn, DataColumnMapping, DataRelation, DataTable, DataTableMapping, OleDbError, OleDbInfoMessageEventArgs, OleDbParameter, SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlError, SqlGuid, SqlInfoMessageEventArgs, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlParameter, SqlSingle, SqlString



ToXml( )

DBDataPermission, OleDbPermission



Transaction

IDbCommand, OleDbCommand, SqlCommand



Translations

OleDbSchemaGuid



True

SqlBoolean



Truncate( )

SqlDecimal



Trustee

OleDbSchemaGuid



TypedDataSetGenerator

System.Data



TypedDataSetGeneratorException

System.Data



UInt16

DbType



UInt32

DbType



UInt64

DbType



Unchanged

DataRowState, DataViewRowState



Union( )

DBDataPermission, OleDbPermission



Unique

DataColumn



UniqueConstraint

System.Data



UniqueIdentifier

SqlDbType



UnsignedBigInt

OleDbType



UnsignedInt

OleDbType



UnsignedSmallInt

OleDbType



UnsignedTinyInt

OleDbType



Unspecified

IsolationLevel



Update

StatementType



Update( )

DataAdapter, DbDataAdapter, IDataAdapter



UpdateCommand

IDbDataAdapter, OleDbDataAdapter, SqlDataAdapter



UpdatedRowSource

IDbCommand, OleDbCommand, SqlCommand



UpdateIndex( )

DataView



UpdateRowSource

System.Data



UpdateRule

ForeignKeyConstraint



UpdateStatus

System.Data



Usage_Privileges

OleDbSchemaGuid



User_Name

OleDbLiteral



Value

IDataParameter, OleDbParameter, SqlBinary, SqlBoolean, SqlByte, SqlDateTime, SqlDecimal, SqlDouble, SqlGuid, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlParameter, SqlSingle, SqlString



value_ _

AcceptRejectRule, CommandBehavior, CommandType, ConnectionState, DataRowAction, DataRowState, DataRowVersion, DataViewRowState, DbType, IsolationLevel, KeyRestrictionBehavior, MappingType, MissingMappingAction, MissingSchemaAction, OleDbLiteral, OleDbType, ParameterDirection, PropertyAttributes, Rule, SchemaType, SqlCompareOptions, SqlDbType, StatementType, UpdateRowSource, UpdateStatus, XmlReadMode, XmlWriteMode



Values

FillErrorEventArgs



VarBinary

OleDbType, SqlDbType



VarChar

OleDbType, SqlDbType



Variant

OleDbType, SqlDbType



VarNumeric

DbType, OleDbType



VarWChar

OleDbType



VersionNotFoundException

System.Data



View_Column_Usage

OleDbSchemaGuid



View_Name

OleDbLiteral



View_Table_Usage

OleDbSchemaGuid



Views

OleDbSchemaGuid



WChar

OleDbType



WorkstationId

SqlConnection



Write

PropertyAttributes



WriteSchema

XmlWriteMode



WriteXml( )

DataSet



WriteXmlSchema( )

DataSet



XmlReadMode

System.Data



XmlWriteMode

System.Data



Xor( )

SqlBoolean, SqlByte, SqlInt16, SqlInt32, SqlInt64



Zero

SqlBoolean, SqlByte, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlSingle





    Part I: ADO.NET Tutorial
    Part II: ADO.NET Core Classes
    Part III: API Quick Reference