C# Class MySql.Data.MySqlClient.MySqlDataReader

Inheritance: DbDataReader, IDataReader, IDisposable, IDataRecord
Afficher le fichier Open project: Top-Cat/SteamBot Class Usage Examples

Private Properties

Свойство Type Description
AdjustOutputTypes void
ChangeType object
ClearKillFlag void
GetFieldValue IMySqlValue
IDataRecord IDataReader
MySqlDataReader System
ProcessOutputParameters void
Throw void

Méthodes publiques

Méthode Description
Close ( ) : void

Closes the MySqlDataReader object.
GetBoolean ( int i ) : bool

Gets the value of the specified column as a Boolean.
GetBoolean ( string name ) : bool

Gets the value of the specified column as a Boolean.
GetByte ( int i ) : byte

Gets the value of the specified column as a byte.
GetByte ( string name ) : byte

Gets the value of the specified column as a byte.
GetBytes ( int i, long fieldOffset, byte buffer, int bufferoffset, int length ) : long

Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset.
GetChar ( int i ) : char

Gets the value of the specified column as a single character.
GetChar ( string name ) : char

Gets the value of the specified column as a single character.
GetChars ( int i, long fieldoffset, char buffer, int bufferoffset, int length ) : long

Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.
GetDataTypeName ( int i ) : String

Gets the name of the source data type.
GetDateTime ( int i ) : System.DateTime
GetDateTime ( string column ) : System.DateTime
GetDecimal ( int i ) : Decimal
GetDecimal ( string column ) : Decimal
GetDouble ( int i ) : double
GetDouble ( string column ) : double
GetEnumerator ( ) : IEnumerator

Returns an IEnumerator that iterates through the MySqlDataReader.
GetFieldType ( int i ) : Type

Gets the Type that is the data type of the object.
GetFieldType ( string column ) : Type
GetFloat ( int i ) : float
GetFloat ( string column ) : float
GetGuid ( int i ) : System.Guid
GetGuid ( string column ) : System.Guid
GetInt16 ( int i ) : Int16
GetInt16 ( string column ) : Int16
GetInt32 ( int i ) : Int32
GetInt32 ( string column ) : Int32
GetInt64 ( int i ) : System.Int64
GetInt64 ( string column ) : System.Int64
GetMySqlDateTime ( int column ) : MySqlDateTime
GetMySqlDateTime ( string column ) : MySqlDateTime
GetMySqlDecimal ( int i ) : MySqlDecimal
GetMySqlDecimal ( string column ) : MySqlDecimal
GetName ( int i ) : String

Gets the name of the specified column.
GetOrdinal ( string name ) : int

Gets the column ordinal, given the name of the column.
GetSByte ( int i ) : sbyte

Gets the value of the specified column as a sbyte.
GetSByte ( string name ) : sbyte

Gets the value of the specified column as a sbyte.
GetSchemaTable ( ) : DataTable

Returns a DataTable that describes the column metadata of the MySqlDataReader.
GetString ( int i ) : String
GetString ( string column ) : string
GetTimeSpan ( int column ) : System.TimeSpan
GetTimeSpan ( string column ) : System.TimeSpan
GetUInt16 ( int column ) : UInt16
GetUInt16 ( string column ) : UInt16
GetUInt32 ( int column ) : UInt32
GetUInt32 ( string column ) : UInt32
GetUInt64 ( int column ) : System.UInt64
GetUInt64 ( string column ) : System.UInt64
GetValue ( int i ) : object

Gets the value of the specified column in its native format.
GetValues ( object values ) : int

Gets all attribute columns in the collection for the current row.
IsDBNull ( int i ) : bool

Gets a value indicating whether the column contains non-existent or missing values.
NextResult ( ) : bool

Advances the data reader to the next result, when reading the results of batch SQL statements.
Read ( ) : bool

Advances the MySqlDataReader to the next record.
this ( String name ) : object

Gets the value of a column in its native format. [C#] In C#, this property is the indexer for the MySqlDataReader class.
this ( int i ) : object

Overloaded. Gets the value of a column in its native format. In C#, this property is the indexer for the MySqlDataReader class.

Private Methods

Méthode Description
AdjustOutputTypes ( ) : void
ChangeType ( IMySqlValue value, int fieldIndex, Type newType ) : object
ClearKillFlag ( ) : void
GetFieldValue ( int index, bool checkNull ) : IMySqlValue
IDataRecord ( int i ) : IDataReader
MySqlDataReader ( MySqlCommand cmd, PreparableStatement statement, CommandBehavior behavior ) : System
ProcessOutputParameters ( ) : void
Throw ( Exception ex ) : void

Method Details

Close() public méthode

Closes the MySqlDataReader object.
public Close ( ) : void
Résultat void

GetBoolean() public méthode

Gets the value of the specified column as a Boolean.
public GetBoolean ( int i ) : bool
i int
Résultat bool

GetBoolean() public méthode

Gets the value of the specified column as a Boolean.
public GetBoolean ( string name ) : bool
name string
Résultat bool

GetByte() public méthode

Gets the value of the specified column as a byte.
public GetByte ( int i ) : byte
i int
Résultat byte

GetByte() public méthode

Gets the value of the specified column as a byte.
public GetByte ( string name ) : byte
name string
Résultat byte

GetBytes() public méthode

Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset.
public GetBytes ( int i, long fieldOffset, byte buffer, int bufferoffset, int length ) : long
i int The zero-based column ordinal.
fieldOffset long The index within the field from which to begin the read operation.
buffer byte The buffer into which to read the stream of bytes.
bufferoffset int The index for buffer to begin the read operation.
length int The maximum length to copy into the buffer.
Résultat long

GetChar() public méthode

Gets the value of the specified column as a single character.
public GetChar ( int i ) : char
i int
Résultat char

GetChar() public méthode

Gets the value of the specified column as a single character.
public GetChar ( string name ) : char
name string
Résultat char

GetChars() public méthode

Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.
public GetChars ( int i, long fieldoffset, char buffer, int bufferoffset, int length ) : long
i int
fieldoffset long
buffer char
bufferoffset int
length int
Résultat long

GetDataTypeName() public méthode

Gets the name of the source data type.
public GetDataTypeName ( int i ) : String
i int
Résultat String

GetDateTime() public méthode

public GetDateTime ( int i ) : System.DateTime
i int
Résultat System.DateTime

GetDateTime() public méthode

public GetDateTime ( string column ) : System.DateTime
column string
Résultat System.DateTime

GetDecimal() public méthode

public GetDecimal ( int i ) : Decimal
i int
Résultat Decimal

GetDecimal() public méthode

public GetDecimal ( string column ) : Decimal
column string
Résultat Decimal

GetDouble() public méthode

public GetDouble ( int i ) : double
i int
Résultat double

GetDouble() public méthode

public GetDouble ( string column ) : double
column string
Résultat double

GetEnumerator() public méthode

Returns an IEnumerator that iterates through the MySqlDataReader.
public GetEnumerator ( ) : IEnumerator
Résultat IEnumerator

GetFieldType() public méthode

Gets the Type that is the data type of the object.
public GetFieldType ( int i ) : Type
i int
Résultat System.Type

GetFieldType() public méthode

public GetFieldType ( string column ) : Type
column string
Résultat System.Type

GetFloat() public méthode

public GetFloat ( int i ) : float
i int
Résultat float

GetFloat() public méthode

public GetFloat ( string column ) : float
column string
Résultat float

GetGuid() public méthode

public GetGuid ( int i ) : System.Guid
i int
Résultat System.Guid

GetGuid() public méthode

public GetGuid ( string column ) : System.Guid
column string
Résultat System.Guid

GetInt16() public méthode

public GetInt16 ( int i ) : Int16
i int
Résultat System.Int16

GetInt16() public méthode

public GetInt16 ( string column ) : Int16
column string
Résultat System.Int16

GetInt32() public méthode

public GetInt32 ( int i ) : Int32
i int
Résultat System.Int32

GetInt32() public méthode

public GetInt32 ( string column ) : Int32
column string
Résultat System.Int32

GetInt64() public méthode

public GetInt64 ( int i ) : System.Int64
i int
Résultat System.Int64

GetInt64() public méthode

public GetInt64 ( string column ) : System.Int64
column string
Résultat System.Int64

GetMySqlDateTime() public méthode

public GetMySqlDateTime ( int column ) : MySqlDateTime
column int
Résultat MySql.Data.Types.MySqlDateTime

GetMySqlDateTime() public méthode

public GetMySqlDateTime ( string column ) : MySqlDateTime
column string
Résultat MySql.Data.Types.MySqlDateTime

GetMySqlDecimal() public méthode

public GetMySqlDecimal ( int i ) : MySqlDecimal
i int
Résultat MySql.Data.Types.MySqlDecimal

GetMySqlDecimal() public méthode

public GetMySqlDecimal ( string column ) : MySqlDecimal
column string
Résultat MySql.Data.Types.MySqlDecimal

GetName() public méthode

Gets the name of the specified column.
public GetName ( int i ) : String
i int
Résultat String

GetOrdinal() public méthode

Gets the column ordinal, given the name of the column.
public GetOrdinal ( string name ) : int
name string
Résultat int

GetSByte() public méthode

Gets the value of the specified column as a sbyte.
public GetSByte ( int i ) : sbyte
i int
Résultat sbyte

GetSByte() public méthode

Gets the value of the specified column as a sbyte.
public GetSByte ( string name ) : sbyte
name string
Résultat sbyte

GetSchemaTable() public méthode

Returns a DataTable that describes the column metadata of the MySqlDataReader.
public GetSchemaTable ( ) : DataTable
Résultat System.Data.DataTable

GetString() public méthode

public GetString ( int i ) : String
i int
Résultat String

GetString() public méthode

public GetString ( string column ) : string
column string
Résultat string

GetTimeSpan() public méthode

public GetTimeSpan ( int column ) : System.TimeSpan
column int
Résultat System.TimeSpan

GetTimeSpan() public méthode

public GetTimeSpan ( string column ) : System.TimeSpan
column string
Résultat System.TimeSpan

GetUInt16() public méthode

public GetUInt16 ( int column ) : UInt16
column int
Résultat System.UInt16

GetUInt16() public méthode

public GetUInt16 ( string column ) : UInt16
column string
Résultat System.UInt16

GetUInt32() public méthode

public GetUInt32 ( int column ) : UInt32
column int
Résultat System.UInt32

GetUInt32() public méthode

public GetUInt32 ( string column ) : UInt32
column string
Résultat System.UInt32

GetUInt64() public méthode

public GetUInt64 ( int column ) : System.UInt64
column int
Résultat System.UInt64

GetUInt64() public méthode

public GetUInt64 ( string column ) : System.UInt64
column string
Résultat System.UInt64

GetValue() public méthode

Gets the value of the specified column in its native format.
public GetValue ( int i ) : object
i int
Résultat object

GetValues() public méthode

Gets all attribute columns in the collection for the current row.
public GetValues ( object values ) : int
values object
Résultat int

IsDBNull() public méthode

Gets a value indicating whether the column contains non-existent or missing values.
public IsDBNull ( int i ) : bool
i int
Résultat bool

NextResult() public méthode

Advances the data reader to the next result, when reading the results of batch SQL statements.
public NextResult ( ) : bool
Résultat bool

Read() public méthode

Advances the MySqlDataReader to the next record.
public Read ( ) : bool
Résultat bool

this() public méthode

Gets the value of a column in its native format. [C#] In C#, this property is the indexer for the MySqlDataReader class.
public this ( String name ) : object
name String
Résultat object

this() public méthode

Overloaded. Gets the value of a column in its native format. In C#, this property is the indexer for the MySqlDataReader class.
public this ( int i ) : object
i int
Résultat object