ReadRelative Method

SqlCeResultSet.ReadRelative Method

Moves the reader the specified amount from the current position.

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

public bool ReadRelative (
	int position
public boolean ReadRelative (
	int position
public function ReadRelative (
	position : int
) : boolean



The number of positions to move the reader.

Return Value

True if the operation succeeded; otherwise, false.

If you pass a positive integer for the position, this function moves the reader forward in the result set. A negative integer moves the reader backward through the result set.

The following example creates a ResultSet object and then calls several methods, including ReadRelative.

Dim conn As SqlCeConnection = Nothing


    Dim engine As New SqlCeEngine("Data Source = Test.sdf")

    conn = New SqlCeConnection("Data Source = Test.sdf")

    Dim cmd As SqlCeCommand = conn.CreateCommand()
    cmd.CommandText = "CREATE TABLE myTable (col1 INT)"

    cmd.CommandText = "SELECT * FROM myTable"

    Dim rs As SqlCeResultSet = cmd.ExecuteResultSet(ResultSetOptions.Updatable Or ResultSetOptions.Scrollable)

    Dim rec As SqlCeUpdatableRecord = rs.CreateRecord()

    ' Insert 10 records
    Dim i As Integer
    For i = 0 To 9
        rec.SetInt32(0, i)
    Next i

    ' Scroll through the results
    If True = rs.ReadFirst() Then
        MessageBox.Show("col1 = " & rs.GetInt32(0)) 'ordinal
    End If

    If True = rs.ReadRelative(5) Then
        MessageBox.Show("col1 = " & rs.GetInt32(0)) 'ordinal
    End If

    If True = rs.ReadLast() Then
        MessageBox.Show("col1 = " & rs.GetInt32(0)) 'ordinal
    End If

    If True = rs.ReadPrevious() Then
        MessageBox.Show("col1 = " & rs.GetInt32(0)) 'ordinal
    End If

    If True = rs.ReadAbsolute(5) Then
        MessageBox.Show("col1 = " & rs.GetInt32(0)) 'ordinal
    End If
Catch e As Exception
End Try

  • 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.

.NET Compact Framework

Supported in: 2.0

Community Additions

© 2016 Microsoft