This documentation is archived and is not being maintained.

LoadOption Enumeration

Note: This enumeration is new in the .NET Framework version 2.0.

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

Public Enumeration LoadOption
Dim instance As LoadOption

public enum LoadOption
public enum LoadOption

 Member nameDescription
Supported by the .NET Compact FrameworkOverwriteChangesThe incoming values for this row will be written to both the current value and the original value versions of the data for each column. 
Supported by the .NET Compact FrameworkPreserveChangesThe 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. 
Supported by the .NET Compact FrameworkUpsertThe 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. 

Windows 98, Windows 2000 SP4, Windows CE, Windows Millennium Edition, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

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

.NET Framework

Supported in: 2.0

.NET Compact Framework

Supported in: 2.0