SqlCeResultSet.Insert Method (SqlCeUpdatableRecord, DbInsertOptions)

Article
10/22/2007

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

Syntax

'Declaration
Public Sub Insert ( _
    record As SqlCeUpdatableRecord, _
    options As DbInsertOptions _
)
'Usage
Dim instance As SqlCeResultSet
Dim record As SqlCeUpdatableRecord
Dim options As DbInsertOptions

instance.Insert(record, options)

public void Insert (
    SqlCeUpdatableRecord record,
    DbInsertOptions options
)

public:
void Insert (
    SqlCeUpdatableRecord^ record, 
    DbInsertOptions options
)

public void Insert (
    SqlCeUpdatableRecord record, 
    DbInsertOptions options
)

public function Insert (
    record : SqlCeUpdatableRecord, 
    options : DbInsertOptions
)

Parameters

record
The record to insert.

options
The DbInsertOptions option to use.

Remarks

Inserting a record does not change the current position of the ResultSet.

Calling this function performs the insertion immediately without requiring additional calls to complete the operation.

An exception is thrown if the record specified has more columns than the underlying rowset has defined. If fewer values are specified, the remaining columns must allow NULL values or have a default value defined.

An InvalidOperation exception is thrown if this function is called on a non-updatable ResultSet or if the reader is not positioned on a valid record.

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .

Platforms

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

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

Version Information

.NET Compact Framework

Supported in: 2.0