United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

.NET Development

.NET Framework 4.5

.NET Framework Class Library

System.Data Namespaces

System.Data

AcceptRejectRule Enumeration

CommandBehavior Enumeration

CommandType Enumeration

ConflictOption Enumeration

ConnectionState Enumeration

Constraint Class

ConstraintCollection Class

ConstraintException Class

DataColumn Class

DataColumnChangeEventArgs Class

DataColumnChangeEventHandler Delegate

DataColumnCollection Class

DataException Class

DataRelation Class

DataRelationCollection Class

DataRow Class

DataRowAction Enumeration

DataRowBuilder Class

DataRowChangeEventArgs Class

DataRowChangeEventHandler Delegate

DataRowCollection Class

DataRowComparer Class

DataRowComparer(TRow) Class

DataRowExtensions Class

DataRowState Enumeration

DataRowVersion Enumeration

DataRowView Class

DataSet Class

DataSetDateTime Enumeration

DataSetSchemaImporterExtension Class

DataSysDescriptionAttribute Class

DataTable Class

DataTableClearEventArgs Class

DataTableClearEventHandler Delegate

DataTableCollection Class

DataTableExtensions Class

DataTableNewRowEventArgs Class

DataTableNewRowEventHandler Delegate

DataTableReader Class

DataViewManager Class

DataViewRowState Enumeration

DataViewSetting Class

DataViewSettingCollection Class

DBConcurrencyException Class

DbType Enumeration

DeletedRowInaccessibleException Class

DuplicateNameException Class

EntityCommandCompilationException Class

EntityCommandExecutionException Class

EntityException Class

EntityKey Class

EntityKeyMember Class

EntitySqlException Class

EntityState Enumeration

EnumerableRowCollection Class

EnumerableRowCollection(TRow) Class

EnumerableRowCollectionExtensions Class

EvaluateException Class

FillErrorEventArgs Class

FillErrorEventHandler Delegate

ForeignKeyConstraint Class

IColumnMapping Interface

IColumnMappingCollection Interface

IDataAdapter Interface

IDataParameter Interface

IDataParameterCollection Interface

IDataReader Interface

IDataRecord Interface

IDbCommand Interface

IDbConnection Interface

IDbDataAdapter Interface

IDbDataParameter Interface

IDbTransaction Interface

IExtendedDataRecord Interface

InRowChangingEventException Class

InternalDataCollectionBase Class

InvalidCommandTreeException Class

InvalidConstraintException Class

InvalidExpressionException Class

IsolationLevel Enumeration

ITableMapping Interface

ITableMappingCollection Interface

KeyRestrictionBehavior Enumeration

LoadOption Enumeration

MappingException Class

MappingType Enumeration

MergeFailedEventArgs Class

MergeFailedEventHandler Delegate

MetadataException Class

MissingMappingAction Enumeration

MissingPrimaryKeyException Class

MissingSchemaAction Enumeration

NoNullAllowedException Class

ObjectNotFoundException Class

OperationAbortedException Class

OptimisticConcurrencyException Class

OrderedEnumerableRowCollection(TRow) Class

ParameterDirection Enumeration

PropertyAttributes Enumeration

PropertyCollection Class

PropertyConstraintException Class

ProviderIncompatibleException Class

ReadOnlyException Class

RowNotInTableException Class

Rule Enumeration

SchemaSerializationMode Enumeration

SchemaType Enumeration

SerializationFormat Enumeration

SqlDbType Enumeration

StateChangeEventArgs Class

StateChangeEventHandler Delegate

StatementCompletedEventArgs Class

StatementCompletedEventHandler Delegate

StatementType Enumeration

StrongTypingException Class

SyntaxErrorException Class

TypedDataSetGenerator Class

TypedDataSetGeneratorException Class

TypedTableBase(T) Class

TypedTableBaseExtensions Class

UniqueConstraint Class

UpdateException Class

UpdateRowSource Enumeration

UpdateStatus Enumeration

VersionNotFoundException Class

XmlReadMode Enumeration

XmlWriteMode Enumeration

Minimize

This topic has not yet been rated - Rate this topic

LoadOption Enumeration

.NET Framework 4.5

Controls how the values from the data source will be applied to existing rows when using the Load or Load method.

Namespace: System.Data
Assembly: System.Data (in System.Data.dll)

public enum LoadOption

Member name

Description

Supported by the XNA Framework

OverwriteChanges

The incoming values for this row will be written to both the current value and the original value versions of the data for each column.

Note
This member is supported by the .NET Framework version 2.0.

Supported by the XNA Framework

PreserveChanges

The incoming values for this row will be written to the original value version of each column. The current version of the data in each column will not be changed. [This] is the default.

Note
This member is supported by the .NET Framework version 2.0.

Supported by the XNA Framework

Upsert

The incoming values for this row will be written to the current version of each column. The original version of each column's data will not be changed.

Note
This member is supported by the .NET Framework version 2.0.

Version Information

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

System.Data Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.