Places the SqlCeDataReader on the record with indexed values that match the specified parameters.
[Visual Basic] Public Sub Seek( _ ByVal dbSeekOptions As DbSeekOptions, _ ByVal ParamArray index() As Object _ ) [C#] public void Seek( DbSeekOptions dbSeekOptions, params object index ); [C++] public: void Seek( DbSeekOptions dbSeekOptions, Object* index __gc ); [JScript] public function Seek( dbSeekOptions : DbSeekOptions, index : Object );
|SqlCeException||The value was not found, or other error.|
This method is intended to be a faster alternative to a SELECT statement for retrieving a row from a base table. Instead of a WHERE clause in a SELECT statement, Seek can be used to quickly retrieve a row based on its index value. For example, to retrieve an employee with an employee ID of 5, you could execute a SELECT statement, but using Seek with a value of 5 on the employee ID index will greatly improve performance.
After using Seek, SqlCeDataReader will return the remaining rows in their index order. When Seek is used on a SqlCeDataReader that has a range specified by SetRange, Seek will only position on rows within the range. For more information, see the "IRowsetIndex::Seek" topic in the OLE DB documentation.
Platforms: .NET Compact Framework
.NET Framework Security:
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries From Partially Trusted Code