Name
SqlDataReader
Synopsis
This class represents a forward-only, read-only cursor that reads
data from a SQL Server database and allows you to access it one
record at a time. For information about the basic
SqlDataReader
methods and properties, refer to the
reference for the System.Data.IDataReader
and
System.Data.IDataRecord
interfaces, which
SqlDataReader
implements. In addition,
you’ll find that SqlDataReader
adds many methods that retrieve data in native SQL Server data types.
public sealed class SqlDataReader : MarshalByRefObject, IEnumerable, System.Data.IDataReader, IDisposable, System.Data IDataRecord { // Public Instance Properties public int Depth{get; } // implements System.Data.IDataReader public int FieldCount{get; } // implements System.Data.IDataRecord public bool HasRows{get; } public bool IsClosed{get; } // implements System.Data.IDataReader public int RecordsAffected{get; } // implements System.Data.IDataReader public object this[inti
]{get; } // implements System.Data.IDataRecord public object this[stringname
]{get; } // implements System.Data.IDataRecord // Public Instance Methods public void Close( ); // implements System.Data.IDataReader public bool GetBoolean(inti
); // implements System.Data.IDataRecord public byte GetByte(inti
); // implements System.Data.IDataRecord public long GetBytes(inti
, longdataIndex
, byte[ ]buffer
, intbufferIndex
, intlength
); // implements System.Data.IDataRecord public char GetChar(inti
); // implements System.Data.IDataRecord ...
Get ADO.NET in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.