DbRangeOptions Enumeration
.NET Framework 2.0
Specifies the options used by the SetRange method when specifying the index range over which to seek.
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
This enumeration has a FlagsAttribute attribute that allows a bitwise combination of its member values.
Namespace: System.Data.SqlServerCeAssembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
| Member name | Description | |
|---|---|---|
![]() | Default | Equivalent to setting both the InclusiveStart and InclusiveEnd flags. |
![]() | ExcludeNulls | Excludes a null reference (Nothing in Visual Basic) values from the range. |
![]() | ExclusiveEnd | Excludes the endData value from the range. |
![]() | ExclusiveStart | Excludes the startData value from the range. |
![]() | InclusiveEnd | Includes the endData value in the range. |
![]() | InclusiveStart | Includes the startData value in the range. |
![]() | Match | Specifies a range in which index values match the value of startData. When using the Match option, endData must be set to a null reference (Nothing in Visual Basic). |
![]() | Prefix | Specifies a range in which index values begin with the value of startData. When using the Prefix option, endData must be set to a null reference (Nothing in Visual Basic). |
In this example, the range options for the Seek operation on the index are specified as InclusiveStart or InclusiveEnd when calling the SetRange method.
Try Dim conn As New SqlCeConnection("Data Source = MyDatabase.sdf") conn.Open() Dim cmd As SqlCeCommand = conn.CreateCommand() cmd.CommandType = CommandType.TableDirect cmd.IndexName = "Orders_PK" cmd.CommandText = "Orders" ' We are interested in orders that match Order ID = 10020 ' cmd.SetRange(DbRangeOptions.Match, New Object() {10020, Nothing) Dim reader As SqlCeDataReader = cmd.ExecuteReader(CommandBehavior.Default) While reader.Read() MessageBox.Show(String.Format("{0 ; {1", reader("Order ID"), reader("Order Date"))) End While ' Now we are interested in orders with Order ID between (10020, 10050) ' cmd.SetRange(DbRangeOptions.InclusiveStart Or DbRangeOptions.InclusiveEnd, New Object() {10020, New Object() {10050) reader = cmd.ExecuteReader(CommandBehavior.Default) ' Now seek to Order ID = 10045 ' Dim onRow As Boolean = reader.Seek(DbSeekOptions.FirstEqual, New Object() {10045) ' Now ,the reader will return rows with Order ID >= 10045 <= 10050 ' because the range was set to (10020, 10050) ' If onRow Then While reader.Read() MessageBox.Show(String.Format("{0 ; {1", reader("Order ID"), reader("Order Date"))) End While End If Catch e As Exception MessageBox.Show(e.Message) End Try
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.
Community Additions
ADD
Show:
