SDB::Data::SDBDataReader Class Reference

Provides a class for reading data rows from the database. More...

List of all members.

Public Member Functions

• override IEnumerator GetEnumerator () public IEnumerator GetEnumerator()
• override DataTable GetSchemaTable () public DataTable GetSchemaTable()

  Returns a DataTable that describes the column metadata.
  

• override bool NextResult () public bool NextResult()

  Reads next result, when reading the results of batch SQL statements.
  

• override bool Read () public bool Read()

  Reads the next record from the result.
  

• override bool GetBoolean (int i) public bool GetBoolean(int i)

  Gets the value of the specified column as a Boolean.
  

• override byte GetByte (int i) public byte GetByte(int i)

  Gets the value of the specified column as a byte data.
  

• override char GetChar (int i) public char GetChar(int i)

  Gets the value of the specified column as char data.
  

• override long GetBytes (int i, long fieldOffset, byte[] buffer, int bufferoffset, int length) public long GetBytes(int i

  Gets an array of bytes from the specified column.
  

• override long GetChars (int i, long fieldOffset, char[] buffer, int bufferoffset, int length) public long GetChars(int i

  Gets an array of characters from the specified column.
  

• IDataReader GetData (int i)

  Unsupported by the .NET Framework.
  

• override string GetDataTypeName (int i) public string GetDataTypeName(int i)

  The SQL data type name.
  

• override DateTime GetDateTime (int i) public DateTime GetDateTime(int i)

  Gets a date/time value from the specified column.
  

• override decimal GetDecimal (int i) public decimal GetDecimal(int i)

  Gets a decimal value from the specified column.
  

• override double GetDouble (int i) public double GetDouble(int i)

  Gets a double value from the specified column.
  

• override Type GetFieldType (int i) public Type GetFieldType(int i)

  Gets the data type of the data.
  

• override float GetFloat (int i) public float GetFloat(int i)

  Gets a float value from the specified column.
  

• override Guid GetGuid (int i) public Guid GetGuid(int i)

  Gets a GUID value from the specified column.
  

• override short GetInt16 (int i) public short GetInt16(int i)

  Gets a short value value from the specified column.
  

• override int GetInt32 (int i) public int GetInt32(int i)

  Gets a int value value from the specified column.
  

• override long GetInt64 (int i) public long GetInt64(int i)

  Gets a long value value from the specified column.
  

• override string GetName (int i) public string GetName(int i)

  Gets the column name of the specified column.
  

• override int GetOrdinal (string name) public int GetOrdinal(string name)

  Gets the column index for the specified column name.
  

• override string GetString (int i) public string GetString(int i)

  Gets a string value value from the specified column.
  

• override object GetValue (int i) public object GetValue(int i)

  Gets a native value from the specified column.
  

• override int GetValues (object[] values) public int GetValues(object[] values)

  Gets all column values of the row as an array of objects.
  

• override bool IsDBNull (int i) public bool IsDBNull(int i)

  Checks if the specified column contains a NULL value.
  

• void Dispose ()

  public override void Dispose()
  

Properties

• override int RecordsAffected
  int RecordsAffected

  Gets the number of row changed during execution of the SQL statement.
  

• override int FieldCount int FieldCount

  Gets the number of columns in the result set.
  

• override object this[int i]
  object this [int i]

  Gets the value of the specified column in its native format by index.
  

• override object this[string
  name] object this [string name]

  Gets the value of the specified column in its native format given the column name.
  

• override bool HasRows bool HasRows

  Get information if the result has more than one row.
  

---

Detailed Description

Provides a class for reading data rows from the database.

---

Member Function Documentation

override bool SDB::Data::SDBDataReader::GetBoolean (  int  i  )

Gets the value of the specified column as a Boolean. Parameters: i  Column index in result Returns:

override byte SDB::Data::SDBDataReader::GetByte (  int  i  )

Gets the value of the specified column as a byte data. Parameters: i  Column index in result Returns: The value as byte data

override long SDB::Data::SDBDataReader::GetBytes (  int  i, long  fieldOffset, byte[]  buffer, int  bufferoffset, int  length )

Gets an array of bytes from the specified column. Parameters: i  Column index in result fieldOffset  The position from where the data is read into buffer buffer  Buffer to store the data bufferoffset  The position in buffer to where where the data is stored length  The number of bytes to read Returns: The number of byte read into buffer

override char SDB::Data::SDBDataReader::GetChar (  int  i  )

Gets the value of the specified column as char data. Parameters: i  Column index in result Returns: The value as char data

override long SDB::Data::SDBDataReader::GetChars (  int  i, long  fieldOffset, char[]  buffer, int  bufferoffset, int  length )

Gets an array of characters from the specified column. Parameters: i  Column index in result fieldOffset  The position from where the data is read into buffer buffer  Buffer to store the data bufferoffset  The position in buffer to where where the data is stored length  The number of characters to read Returns:

IDataReader SDB::Data::SDBDataReader::GetData (  int  i  )

Unsupported by the .NET Framework. Parameters: i  Returns:

override string SDB::Data::SDBDataReader::GetDataTypeName (  int  i  )

The SQL data type name. Parameters: i  Column index in result Returns: The SQL identifier data type name

override DateTime SDB::Data::SDBDataReader::GetDateTime (  int  i  )

Gets a date/time value from the specified column. Parameters: i  Column index in result Returns: The column data as date/time value

override decimal SDB::Data::SDBDataReader::GetDecimal (  int  i  )

Gets a decimal value from the specified column. Parameters: i  Column index in result Returns: The column data as decimal value

override double SDB::Data::SDBDataReader::GetDouble (  int  i  )

Gets a double value from the specified column. Parameters: i  Column index in result Returns: The column data as double value

override IEnumerator SDB::Data::SDBDataReader::GetEnumerator (   )

Todo: Implement this feature

override Type SDB::Data::SDBDataReader::GetFieldType (  int  i  )

Gets the data type of the data. Parameters: i  Column index in result Returns: The data type of the coulnm

override float SDB::Data::SDBDataReader::GetFloat (  int  i  )

Gets a float value from the specified column. Parameters: i  Column index in result Returns: The column data as float value

override Guid SDB::Data::SDBDataReader::GetGuid (  int  i  )

Gets a GUID value from the specified column. Parameters: i  Column index in result Returns: The column data as GUID

override short SDB::Data::SDBDataReader::GetInt16 (  int  i  )

Gets a short value value from the specified column. Parameters: i  Column index in result Returns: The column data as a 2 byte value

override int SDB::Data::SDBDataReader::GetInt32 (  int  i  )

Gets a int value value from the specified column. Parameters: i  Column index in result Returns: The column data as a 4 byte value

override long SDB::Data::SDBDataReader::GetInt64 (  int  i  )

Gets a long value value from the specified column. Parameters: i  Column index in result Returns: The column data as a 8 byte value

override string SDB::Data::SDBDataReader::GetName (  int  i  )

Gets the column name of the specified column. Parameters: i  Column index in result Returns: The column name

override int SDB::Data::SDBDataReader::GetOrdinal (  string  name  )

Gets the column index for the specified column name. Parameters: name  The name of the column to search Returns: The index of the column

override DataTable SDB::Data::SDBDataReader::GetSchemaTable (   )

Returns a DataTable that describes the column metadata. Todo: Implement this feature

override string SDB::Data::SDBDataReader::GetString (  int  i  )

Gets a string value value from the specified column. Parameters: i  Column index in result Returns: The column data as a string value

override object SDB::Data::SDBDataReader::GetValue (  int  i  )

Gets a native value from the specified column. Parameters: i  Column index in result Returns: The column data as native value

override int SDB::Data::SDBDataReader::GetValues (  object[]  values  )

Gets all column values of the row as an array of objects. Parameters: values  Object array to which the values are copied Returns: The number of array instances

override bool SDB::Data::SDBDataReader::IsDBNull (  int  i  )

Checks if the specified column contains a NULL value. Parameters: i  Column index in result Returns: A true value if the column contains the NULL indicator otherwise false

override bool SDB::Data::SDBDataReader::NextResult (   )

Reads next result, when reading the results of batch SQL statements. Returns: A true value if a next result is available otherwise false

override bool SDB::Data::SDBDataReader::Read (   )

Reads the next record from the result. Returns: A true value if a next record is available otherwise false