SqlCeCommand.UpdatedRowSource Property

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 Edition.

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

Syntax

'Declaration
Public Overrides Property UpdatedRowSource As UpdateRowSource
'Usage
Dim instance As SqlCeCommand
Dim value As UpdateRowSource

value = instance.UpdatedRowSource

instance.UpdatedRowSource = value

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)

Not applicable.

Property Value

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

Exceptions

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;

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeCommand Class
SqlCeCommand Members
System.Data.SqlServerCe Namespace