SqlCeResultSet.Insert Method (SqlCeUpdatableRecord, DbInsertOptions)

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


Public Sub Insert ( _
    record As SqlCeUpdatableRecord, _
    options As DbInsertOptions _
Dim instance As SqlCeResultSet
Dim record As SqlCeUpdatableRecord
Dim options As DbInsertOptions

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


  • record
    The record to insert.


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 .


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

See Also


SqlCeResultSet Class
SqlCeResultSet Members
System.Data.SqlServerCe Namespace