SqlCeCommand.UpdatedRowSource Property

Article
10/22/2009

Gets or sets how command results are applied to the DataRow when used by the Update method of the DbDataAdapter. This property should not be used with the .NET Compact Framework Data Provider for SQL Server Compact 3.5 SP1.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Overrides Property UpdatedRowSource As UpdateRowSource

public override UpdateRowSource UpdatedRowSource { get; set; }

public:
virtual property UpdateRowSource UpdatedRowSource {
    UpdateRowSource get () override;
    void set (UpdateRowSource value) override;
}

/** @property */
public UpdateRowSource get_UpdatedRowSource ()

/** @property */
public void set_UpdatedRowSource (UpdateRowSource value)

public override function get UpdatedRowSource () : UpdateRowSource

public override function set UpdatedRowSource (value : UpdateRowSource)

Property Value

One of the UpdateRowSource values. The default is Both. If the command is automatically generated, the default is None.

Exceptions

Exception type	Condition
ArgumentException	The value entered was not one of the UpdateRowSource values.

Example

Dim cmd As SqlCeCommand = conn.CreateCommand()
cmd.CommandText = "SELECT * FROM Categories ORDER BY CategoryID"
cmd.CommandType = CommandType.Text
cmd.UpdatedRowSource = UpdateRowSource.Both

SqlCeCommand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM Categories ORDER BY CategoryID";
cmd.CommandType = CommandType.Text;
cmd.UpdatedRowSource = UpdateRowSource.Both;

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Version Information
.NET Framework and NET Compact Framework
Supported in 3.5
.NET Framework
Supported in 3.0
.NET Compact Framework and .Net Framework
Supported in 2.0