SqlCeResultSet.Insert Method (SqlCeUpdatableRecord, DbInsertOptions)

  • Article

Inserts the specified SqlCeUpdatableRecord into the underlying rowset and specifies how the cursor is positioned.

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
)

Not applicable.

Parameters

  • record
    The record to insert.
  • options
    The DbInsertOptions option to specify how the cursor is positioned after the insert.

Remarks

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.

A InvalidOperationException is thrown if this function is called on a non-updatable SqlCeResultSet or if the reader is not positioned on a valid record.

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

See Also

Reference

SqlCeResultSet Class
SqlCeResultSet Members
System.Data.SqlServerCe Namespace