SqlCeResultSet.ReadAbsolute Method

Article
10/22/2007

Moves the reader to a specific record in the ResultSet.

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

Syntax

'Declaration
Public Function ReadAbsolute ( _
    position As Integer _
) As Boolean
'Usage
Dim instance As SqlCeResultSet
Dim position As Integer
Dim returnValue As Boolean

returnValue = instance.ReadAbsolute(position)

public bool ReadAbsolute (
    int position
)

public:
bool ReadAbsolute (
    int position
)

public boolean ReadAbsolute (
    int position
)

public function ReadAbsolute (
    position : int
) : boolean

Parameters

position
The position to which to move the reader.

Return Value

True if the operation succeeded; otherwise, false.

Remarks

ReadAbsolute is 0-based; calling ReadAbsolute(0) will return the first row of the ResultSet.

This method reads the value of the row based on the row position saved by a bookmark. For example, suppose you have a table with 10 rows, and you open two ResultSets: rs1 and rs2. You call ReadAbsolue(5) on rs1 and change the value of this row to -1. The row's position has now changed to the first position in the list of rows, and row 4 is in the 5th position. However, if you now call ReadAbsolute(5) on rs2, a value of -1 is returned. ResultSet rs2 maintains a bookmark to the original 5th row and continues to read that row, despite its position changing.

If you pass a positive integer to this function, the reader is moved from the first record forward the specified number of records. If you pass a negative integer to this function, the reader is moved from the last record back the specified number of records.

Example

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

Dim conn As SqlCeConnection = Nothing

Try
    File.Delete("Test.sdf")

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

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

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

    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)
        rs.Insert(rec)
    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
    MessageBox.Show(e.Message)
Finally
    conn.Close()
End Try

.NET Framework Security

Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .

Platforms

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