A read-only, forward-only result set from a query or stored procedure. This class cannot be inherited.
Visual Basic Public NotInheritable Class SADataReader Inherits DbDataReader Implements IListSource
C# public sealed class SADataReader : DbDataReader, IListSource
There is no constructor for SADataReader. To get an SADataReader object, execute an SACommand:
SACommand cmd = new SACommand( "SELECT EmployeeID FROM Employees", conn ); SADataReader reader = cmd.ExecuteReader(); |
You can only move forward through an SADataReader. If you need a more flexible object to manipulate results, use an SADataAdapter.
The SADataReader retrieves rows as needed, whereas the SADataAdapter must retrieve all rows of a result set before you can carry out any action on the object. For large result sets, this difference gives the SADataReader a much faster response time.
Implements: IDataReader, IDisposable, IDataRecord, IListSource
For more information, see Accessing and manipulating data.
SADataReader members
Depth property
FieldCount property
HasRows property
IsClosed property
Item properties
RecordsAffected property
Close method
GetBoolean method
GetByte method
GetBytes method
GetChar method
GetChars method
GetData method
GetDataTypeName method
GetDateTime method
GetDecimal method
GetDouble method
GetEnumerator method
GetFieldType method
GetFloat method
GetGuid method
GetInt16 method
GetInt32 method
GetInt64 method
GetName method
GetOrdinal method
GetSchemaTable method
GetString method
GetTimeSpan method
GetUInt16 method
GetUInt32 method
GetUInt64 method
GetValue methods
GetValues method
IsDBNull method
NextResult method
Read method
myDispose method
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |