C.4 Migrating MSDE to SQL Server

C.4 Migrating MSDE to SQL Server

If you decide to migrate an MSDE database to SQL Server, you have several options. One is to simply install SQL Server on top of MSDE. If you install SQL Server on a separate computer (a more likely approach), you can detach the MSDE database file and reattach it on a SQL Server machine using the sp_detach_db and sp_attach_db stored procedures that are provided in all SQL Server and MSDE databases.

To start, log on to your MSDE instance, and use the following commands (in OSQL) to remove the database:

 USE Master
sp_detach_db '   databaseName   '
GO 

Next, copy the corresponding data and log files ( .mdf and .ldf files) from the current location to the new computer. They should be placed in the data path used by your SQL Server.

Reattach the database to SQL Server using the database name and the database filename (with full path). These commands can be entered on the SQL Server using Query Analyzer or OSQL (which SQL Server also supports). Just make sure that you log on to the correct SQL Server first before you execute these instructions.

 USE master
sp_attach_db '   database name','databaseFile   '
GO 

You can verify the change in file location using the sp_helpfile stored procedure:

 USE   databaseName   sp_helpfile
GO 

Type, Method, Property, and Field Index

Use this index to locate a type or member and see where it's defined. For a type (a class or interface), you can find the enclosing namespace. If you know the name of a member (a method, property, event, or field), you can find all the types that define it.

A-L

M-Z

A-L
Abs( )

SqlDecimal



AcceptChanges( )

DataRow, DataSet, DataTable



AcceptChangesDuringFill

DataAdapter



AcceptRejectRule

ForeignKeyConstraint, System.Data



Action

DataRowChangeEventArgs



Add

DataRowAction, MissingSchemaAction



Add( )

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataRowCollection, DataTableCollection, DataTableMappingCollection, DBDataPermission, IColumnMappingCollection, ITableMappingCollection, OleDbParameterCollection, SqlByte, SqlClientPermission, SqlDecimal, SqlDouble, SqlInt16, SqlInt32, SqlInt64, SqlMoney, SqlParameterCollection, SqlSingle



AddCore( )

DataRelationCollection



Added

DataRowState, DataViewRowState



AddNew( )

DataView



AddRange( )

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataTableCollection, DataTableMappingCollection



AddWithKey

MissingSchemaAction



AdjustScale( )

SqlDecimal



AllowBlankPassword

DBDataPermission, DBDataPermissionAttribute



AllowDBNull

DataColumn



AllowDelete

DataView



AllowEdit

DataView



AllowNew

DataView



AllowOnly

KeyRestrictionBehavior



And( )

SqlBoolean



AnsiString

DbType



AnsiStringFixedLength

DbType



ApplyDefaultSort

DataView, DataViewSetting



Assertions

OleDbSchemaGuid



Attribute

MappingType



Auto

XmlReadMode



AutoIncrement

DataColumn



AutoIncrementSeed

DataColumn



AutoIncrementStep

DataColumn



Begin( )

OleDbTransaction



BeginEdit( )

DataRow, DataRowView



BeginInit( )

DataSet, DataTable, DataView



BeginInvoke( )

DataColumnChangeEventHandler, DataRowChangeEventHandler, FillErrorEventHandler, MergeFailedEventHandler, OleDbInfoMessageEventHandler, OleDbRowUpdatedEventHandler, OleDbRowUpdatingEventHandler, SqlInfoMessageEventHandler, SqlRowUpdatedEventHandler, SqlRowUpdatingEventHandler, StateChangeEventHandler



BeginLoadData( )

DataTable



BeginTransaction( )

IDbConnection, OleDbConnection, SqlConnection



BigInt

OleDbType, SqlDbType



Binary

DbType, OleDbType, SqlDbType



Binary_Literal

OleDbLiteral



BinarySort

SqlCompareOptions, SqlString



BinData

SqlDecimal



Bit

SqlDbType



BitwiseAnd( )

SqlByte, SqlInt16, SqlInt32, SqlInt64



BitwiseOr( )

SqlByte, SqlInt16, SqlInt32, SqlInt64



Boolean

DbType, OleDbType



Both

UpdateRowSource



Broken

ConnectionState



BSTR

OleDbType



Byte

DbType



ByteValue

SqlBoolean



Cancel( )

IDbCommand, OleDbCommand, SqlCommand



CancelEdit( )

DataRow, DataRowView



CanRemove( )

ConstraintCollection, DataColumnCollection, DataRelationCollection, DataTableCollection



Caption

DataColumn



Cascade

AcceptRejectRule, Rule



CaseSensitive

DataSet, DataTable



Catalog_Name

OleDbLiteral



Catalog_Separator

OleDbLiteral



Catalogs

OleDbSchemaGuid



Ceiling( )

SqlDecimal



Change

DataRowAction



ChangeDatabase( )

IDbConnection, OleDbConnection, SqlConnection



Chaos

IsolationLevel



Char

OleDbType, SqlDbType



Char_Literal

OleDbLiteral



Character_Sets

OleDbSchemaGuid



Check_Constraints

OleDbSchemaGuid



Check_Constraints_By_Table

OleDbSchemaGuid



CheckStateForProperty( )

Constraint, DataRelation



CheckUnique( )

DataColumn



ChildColumns

DataRelation



ChildKeyConstraint

DataRelation



ChildRelations

DataTable



ChildTable

DataRelation



Class

SqlError, SqlException



Clear( )

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataRowCollection, DataSet, DataTable, DataTableCollection, DataTableMappingCollection, DBDataPermission, OleDbParameterCollection, SqlParameterCollection



ClearErrors( )

DataRow



ClearFunctionCalled

DataSet



Clone( )

DataSet, DataTable, SqlString



CloneInternals( )

DataAdapter



Close( )

DataView, IDataReader, IDbConnection, OleDbConnection, OleDbDataReader, SqlConnection, SqlDataReader



CloseConnection

CommandBehavior



Closed

ConnectionState



Collations

OleDbSchemaGuid



CollectionChanged

ConstraintCollection, DataColumnCollection, DataRelationCollection, DataTableCollection



CollectionChanging

DataColumnCollection, DataRelationCollection, DataTableCollection



Column

DataColumnChangeEventArgs



Column_Alias

OleDbLiteral



Column_Domain_Usage

OleDbSchemaGuid



Column_Name

OleDbLiteral



Column_Privileges

OleDbSchemaGuid



ColumnChanged

DataTable



ColumnChanging

DataTable



ColumnCollectionChanged( )

DataView



ColumnMapping

DataColumn



ColumnMappings

DataTableMapping, ITableMapping



ColumnName

DataColumn



ColumnPropertyChanged

DataColumnCollection



Columns

DataTable, ForeignKeyConstraint, OleDbSchemaGuid, UniqueConstraint



Command

OleDbRowUpdatedEventArgs, OleDbRowUpdatingEventArgs, RowUpdatedEventArgs, RowUpdatingEventArgs, SqlRowUpdatedEventArgs, SqlRowUpdatingEventArgs



CommandBehavior

System.Data



CommandText

IDbCommand, OleDbCommand, SqlCommand



CommandTimeout

IDbCommand, OleDbCommand, SqlCommand



CommandType

IDbCommand, OleDbCommand, SqlCommand, System.Data



Commit

DataRowAction



Commit( )

IDbTransaction, OleDbTransaction, SqlTransaction



CompareInfo

SqlString



CompareOptionsFromSqlCompareOptions( )

SqlString



CompareTo( )

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



Compute( )

DataTable



Concat( )

SqlBinary, SqlString



Conflict

MergeFailedEventArgs



Connecting

ConnectionState



Connection

IDbCommand, IDbTransaction, OleDbCommand, OleDbTransaction, SqlCommand, SqlTransaction



ConnectionState

System.Data



ConnectionString

DBDataPermissionAttribute, IDbConnection, OleDbConnection, SqlConnection



ConnectionTimeout

IDbConnection, OleDbConnection, SqlConnection



Constraint

System.Data



Constraint_Column_Usage

OleDbSchemaGuid



Constraint_Table_Usage

OleDbSchemaGuid



ConstraintCollection

System.Data



ConstraintException

System.Data



ConstraintName

Constraint



Constraints

DataTable



Contains( )

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



Continue

FillErrorEventArgs, UpdateStatus



ContinueUpdateOnError

DataAdapter



ConvertToPrecScale( )

SqlDecimal



Copy( )

DataSet, DataTable, DBDataPermission, OleDbPermission, SqlClientPermission



CopyTo( )

DataColumnMappingCollection, DataTableMappingCollection, DataView, DataViewSettingCollection, InternalDataCollectionBase, OleDbErrorCollection, OleDbParameterCollection, SqlErrorCollection, SqlParameterCollection



Correlation_Name

OleDbLiteral



Count

DataColumnMappingCollection, DataTableMappingCollection, DataView, DataViewSettingCollection, InternalDataCollectionBase, OleDbErrorCollection, OleDbParameterCollection, SqlErrorCollection, SqlParameterCollection



CreateChildView( )

DataRowView



CreateCommand( )

IDbConnection, OleDbConnection, SqlConnection



CreateDataView( )

DataViewManager



CreateInstance( )

DataTable, DBDataPermission



CreateParameter( )

IDbCommand, OleDbCommand, SqlCommand



CreatePermission( )

OleDbPermissionAttribute, SqlClientPermissionAttribute



CreateRowUpdatedEvent( )

DbDataAdapter, OleDbDataAdapter, SqlDataAdapter



CreateRowUpdatingEvent( )

DbDataAdapter, OleDbDataAdapter, SqlDataAdapter



CreateTableMappings( )

DataAdapter



Cube_Name

OleDbLiteral



CultureInfo

SqlString



Currency

DbType, OleDbType



Current

DataRowVersion, DbEnumerator



CurrentRows

DataViewRowState



CurrentState

StateChangeEventArgs



Cursor_Name

OleDbLiteral



Data

SqlDecimal



DataAdapter

OleDbCommandBuilder, SqlCommandBuilder, System.Data.Common



Database

IDbConnection, OleDbConnection, SqlConnection



DataColumn

System.Data



DataColumnChangeEventArgs

System.Data



DataColumnChangeEventHandler

System.Data



DataColumnCollection

System.Data



DataColumnMapping

System.Data.Common



DataColumnMappingCollection

System.Data.Common



DataException

System.Data



DataRelation

System.Data



DataRelationCollection

System.Data



DataRow

System.Data



DataRowAction

System.Data



DataRowBuilder

System.Data



DataRowChangeEventArgs

System.Data



DataRowChangeEventHandler

System.Data



DataRowCollection

System.Data



DataRowCreated

DataSet



DataRowState

System.Data



DataRowVersion

System.Data



DataRowView

System.Data



DataSet

DataRelation, DataTable, DataViewManager, System.Data



DataSetColumn

DataColumnMapping, IColumnMapping



DataSetName

DataSet



DataSetTable

DataTableMapping, ITableMapping



DataSource

OleDbConnection, SqlConnection



DataSysDescriptionAttribute

System.Data



DataTable

FillErrorEventArgs, System.Data



DataTableCollection

System.Data



DataTableMapping

System.Data.Common



DataTableMappingCollection

System.Data.Common



DataType

DataColumn



DataView

DataRowView, System.Data



DataViewManager

DataView, DataViewSetting, System.Data



DataViewRowState

System.Data



DataViewSetting

System.Data



DataViewSettingCollection

System.Data



DataViewSettingCollectionString

DataViewManager



DataViewSettings

DataViewManager



Date

DbType, OleDbType



DateTime

DbType, SqlDbType



DayTicks

SqlDateTime



DBConcurrencyException

System.Data



DbDataAdapter

System.Data.Common



DBDataPermission

System.Data.Common



DBDataPermissionAttribute

System.Data.Common



DbDataRecord

System.Data.Common



DBDate

OleDbType



DbEnumerator

System.Data.Common



DbInfoLiterals

OleDbSchemaGuid



DBTime

OleDbType



DBTimeStamp

OleDbType



DbType

IDataParameter, OleDbParameter, SqlParameter, System.Data



Decimal

DbType, OleDbType, SqlDbType



Default

CommandBehavior, DataRowVersion



DefaultSourceTableName

DbDataAdapter



DefaultValue

DataColumn



DefaultView

DataTable



DefaultViewManager

DataSet



Delete

DataRowAction, StatementType



Delete( )

DataRow, DataRowView, DataView



DeleteCommand

IDbDataAdapter, OleDbDataAdapter, SqlDataAdapter



Deleted

DataRowState, DataViewRowState



DeletedRowInaccessibleException

System.Data



DeleteRule

ForeignKeyConstraint



Depth

IDataReader, OleDbDataReader, SqlDataReader



DeriveParameters( )

OleDbCommandBuilder, SqlCommandBuilder



Description

DataSysDescriptionAttribute



DesignTimeVisible

OleDbCommand, SqlCommand



Detached

DataRowState



DiffGram

XmlReadMode, XmlWriteMode



Dimension_Name

OleDbLiteral



Direction

IDataParameter, OleDbParameter, SqlParameter



DisplayExpression

DataTable



Dispose( )

DataAdapter, DataView, DbDataAdapter, OleDbCommand, OleDbCommandBuilder, OleDbConnection, OleDbDataAdapter, SqlCommandBuilder, SqlConnection, SqlDataAdapter, SqlTransaction



Divide( )

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



Double

DbType, OleDbType



DuplicateNameException

System.Data



Element

MappingType



Empty

OleDbType



EndEdit( )

DataRow, DataRowView



EndInit( )

DataSet, DataTable, DataView



EndInvoke( )

DataColumnChangeEventHandler, DataRowChangeEventHandler, FillErrorEventHandler, MergeFailedEventHandler, OleDbInfoMessageEventHandler, OleDbRowUpdatedEventHandler, OleDbRowUpdatingEventHandler, SqlInfoMessageEventHandler, SqlRowUpdatedEventHandler, SqlRowUpdatingEventHandler, StateChangeEventHandler



EndLoadData( )

DataTable



EnforceConstraints

DataSet



EnlistDistributedTransaction( )

OleDbConnection, SqlConnection



Equals( )

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



Error

MissingMappingAction, MissingSchemaAction, OleDbType



ErrorCode

OleDbException, OleDbInfoMessageEventArgs



ErrorList

TypedDataSetGeneratorException



Errors

FillErrorEventArgs, OleDbException, OleDbInfoMessageEventArgs, RowUpdatedEventArgs, RowUpdatingEventArgs, SqlException, SqlInfoMessageEventArgs



ErrorsOccurred

UpdateStatus



Escape_Percent_Prefix

OleDbLiteral



Escape_Percent_Suffix

OleDbLiteral



Escape_Underscore_Prefix

OleDbLiteral



Escape_Underscore_Suffix

OleDbLiteral



EvaluateException

System.Data



ExecuteNonQuery( )

IDbCommand, OleDbCommand, SqlCommand



ExecuteReader( )

IDbCommand, OleDbCommand, SqlCommand



ExecuteScalar( )

IDbCommand, OleDbCommand, SqlCommand



ExecuteXmlReader( )

SqlCommand



Executing

ConnectionState



Expression

DataColumn



ExtendedProperties

Constraint, DataColumn, DataRelation, DataSet, DataTable



False

SqlBoolean



Fetching

ConnectionState



FieldCount

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



Filetime

OleDbType



Fill( )

DataAdapter, DbDataAdapter, IDataAdapter, OleDbDataAdapter



FillError

DbDataAdapter



FillErrorEventArgs

System.Data



FillErrorEventHandler

System.Data



FillSchema( )

DataAdapter, DbDataAdapter, IDataAdapter



Finalize( )

OleDbDataReader, OleDbTransaction



Find( )

DataRowCollection, DataView



FindRows( )

DataView



FirstReturnedRecord

UpdateRowSource



Float

SqlDbType



Floor( )

SqlDecimal



Foreign_Keys

OleDbSchemaGuid



ForeignKeyConstraint

System.Data



Fragment

XmlReadMode



FromXml( )

DBDataPermission, OleDbPermission



Generate( )

TypedDataSetGenerator



GenerateIdName( )

TypedDataSetGenerator



GetBoolean( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetByDataSetColumn( )

DataColumnMappingCollection, IColumnMappingCollection



GetByDataSetTable( )

DataTableMappingCollection, ITableMappingCollection



GetByte( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetBytes( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetChanges( )

DataSet, DataTable



GetChar( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetChars( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetChildRows( )

DataRow



GetColumnError( )

DataRow



GetColumnMappingBySchemaAction( )

DataColumnMappingCollection, DataTableMapping



GetColumnsInError( )

DataRow



GetData( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetDataColumnBySchemaAction( )

DataColumnMapping



GetDataSet( )

DataRelationCollection



GetDataTableBySchemaAction( )

DataTableMapping



GetDataTypeName( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetDateTime( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetDecimal( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetDeleteCommand( )

OleDbCommandBuilder, SqlCommandBuilder



GetDouble( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetEnumerator( )

DataColumnMappingCollection, DataTableMappingCollection, DataView, DataViewSettingCollection, InternalDataCollectionBase, OleDbErrorCollection, OleDbParameterCollection, SqlErrorCollection, SqlParameterCollection



GetErrors( )

DataTable



GetFieldType( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetFillParameters( )

DataAdapter, DbDataAdapter, IDataAdapter



GetFloat( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetGuid( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetHashCode( )

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



GetInsertCommand( )

OleDbCommandBuilder, SqlCommandBuilder



GetInt16( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetInt32( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetInt64( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetName( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetNonUnicodeBytes( )

SqlString



GetObjectData( )

DBConcurrencyException, OleDbException, SqlException, TypedDataSetGeneratorException



GetOleDbSchemaTable( )

OleDbConnection



GetOrdinal( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetParentRow( )

DataRow



GetParentRows( )

DataRow



GetRowType( )

DataTable



GetSchemaSerializable( )

DataSet



GetSchemaTable( )

IDataReader, OleDbDataReader, SqlDataReader



GetSerializationData( )

DataSet



GetSqlBinary( )

SqlDataReader



GetSqlBoolean( )

SqlDataReader



GetSqlByte( )

SqlDataReader



GetSqlDateTime( )

SqlDataReader



GetSqlDecimal( )

SqlDataReader



GetSqlDouble( )

SqlDataReader



GetSqlGuid( )

SqlDataReader



GetSqlInt16( )

SqlDataReader



GetSqlInt32( )

SqlDataReader



GetSqlInt64( )

SqlDataReader



GetSqlMoney( )

SqlDataReader



GetSqlSingle( )

SqlDataReader



GetSqlString( )

SqlDataReader



GetSqlValue( )

SqlDataReader



GetSqlValues( )

SqlDataReader



GetString( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetTableMappingBySchemaAction( )

DataTableMappingCollection



GetTimeSpan( )

OleDbDataReader



GetUnicodeBytes( )

SqlString



GetUpdateCommand( )

OleDbCommandBuilder, SqlCommandBuilder



GetValue( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetValues( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



GetXml( )

DataSet



GetXmlSchema( )

DataSet



GreaterThan( )

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



GreaterThanOrEqual( )

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



Guid

DbType, OleDbType



HasChanges( )

DataSet



HasErrors

DataRow, DataSet, DataTable



HasRows

OleDbDataReader, SqlDataReader



HasVersion( )

DataRow



Hidden

MappingType



Hierarchy_Name

OleDbLiteral



IColumnMapping

System.Data



IColumnMappingCollection

System.Data



IDataAdapter

System.Data



IDataParameter

System.Data



IDataParameterCollection

System.Data



IDataReader

System.Data



IDataRecord

System.Data



IDbCommand

System.Data



IDbConnection

System.Data



IDbDataAdapter

System.Data



IDbDataParameter

System.Data



IDbTransaction

System.Data



IDispatch

OleDbType



Ignore

MissingMappingAction, MissingSchemaAction



IgnoreCase

SqlCompareOptions, SqlString



IgnoreKanaType

SqlCompareOptions, SqlString



IgnoreNonSpace

SqlCompareOptions, SqlString



IgnoreSchema

XmlReadMode, XmlWriteMode



IgnoreWidth

SqlCompareOptions, SqlString



Image

SqlDbType



ImportRow( )

DataTable



Index_Name

OleDbLiteral



Indexes

OleDbSchemaGuid



IndexListChanged( )

DataView



IndexOf( )

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



IndexOfDataSetColumn( )

DataColumnMappingCollection



IndexOfDataSetTable( )

DataTableMappingCollection



InferSchema

XmlReadMode



InferXmlSchema( )

DataSet



InfoMessage

OleDbConnection, SqlConnection



Input

ParameterDirection



InputOutput

ParameterDirection



InRowChangingEventException

System.Data



Insert

StatementType



Insert( )

DataColumnMappingCollection, DataTableMappingCollection, OleDbParameterCollection, SqlParameterCollection



InsertAt( )

DataRowCollection



InsertCommand

IDbDataAdapter, OleDbDataAdapter, SqlDataAdapter



Int

SqlDbType



Int16

DbType



Int32

DbType



Int64

DbType



Integer

OleDbType



InternalDataCollectionBase

System.Data



Intersect( )

DBDataPermission, OleDbPermission



INullable

System.Data.SqlTypes



Invalid

OleDbLiteral



InvalidConstraintException

System.Data



InvalidExpressionException

System.Data



Invoke( )

DataColumnChangeEventHandler, DataRowChangeEventHandler, FillErrorEventHandler, MergeFailedEventHandler, OleDbInfoMessageEventHandler, OleDbRowUpdatedEventHandler, OleDbRowUpdatingEventHandler, SqlInfoMessageEventHandler, SqlRowUpdatedEventHandler, SqlRowUpdatingEventHandler, StateChangeEventHandler



IsClosed

IDataReader, OleDbDataReader, SqlDataReader



IsDBNull( )

DbDataRecord, IDataRecord, OleDbDataReader, SqlDataReader



IsEdit

DataRowView



IsFalse

SqlBoolean



IsNew

DataRowView



IsNull

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



IsNull( )

DataRow



IsNullable

IDataParameter, OleDbParameter, SqlParameter



IsolationLevel

IDbTransaction, OleDbTransaction, SqlTransaction, System.Data



IsPositive

SqlDecimal



IsPrimaryKey

UniqueConstraint



IsReadOnly

DataViewSettingCollection, InternalDataCollectionBase



IsSubsetOf( )

DBDataPermission



IsSynchronized

DataViewSettingCollection, InternalDataCollectionBase



IsTrue

SqlBoolean



IsUnrestricted( )

DBDataPermission



ITableMapping

System.Data



ITableMappingCollection

System.Data



Item

ConstraintCollection, DataColumnCollection, DataColumnMappingCollection, DataRelationCollection, DataRow, DataRowCollection, DataRowView, DataTableCollection, DataTableMappingCollection, DataView, DataViewSettingCollection, DbDataRecord, IColumnMappingCollection, IDataParameterCollection, IDataRecord, ITableMappingCollection, OleDbDataReader, OleDbErrorCollection, OleDbParameterCollection, SqlBinary, SqlDataReader, SqlErrorCollection, SqlParameterCollection



ItemArray

DataRow



IUnknown

OleDbType



Key_Column_Usage

OleDbSchemaGuid



KeyInfo

CommandBehavior



KeyRestrictionBehavior

DBDataPermissionAttribute, System.Data



KeyRestrictions

DBDataPermissionAttribute



LCID

SqlString



Length

SqlBinary



LessThan( )

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



LessThanOrEqual( )

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



Level_Name

OleDbLiteral



Like_Percent

OleDbLiteral



Like_Underscore

OleDbLiteral



LineNumber

SqlError, SqlException



ListChanged

DataView, DataViewManager



LoadDataRow( )

DataTable



Locale

DataSet, DataTable



LongVarBinary

OleDbType



LongVarChar

OleDbType



LongVarWChar

OleDbType