ResultSetOptions Enumeration

Sets options for the ResultSetEnumerator.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in

public enum ResultSetOptions
/** @attribute FlagsAttribute() */ 
public enum ResultSetOptions
public enum ResultSetOptions

Member nameDescription
InsensitiveThe ResultSet does not detect changes made to the data source.
NoneNo ResultSet options are specified.
ScrollableThe ResultSet can be scrolled both forward and backward.
SensitiveThe ResultSet detects changes made to the data source.
UpdatableThe ResultSet allows updates.

If you do not set both the Insensitive and Sensitive settings, the ResultSet is Asensitive and will use the fastest cursor based on the other options specified.

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