C# Class MySql.Data.MySqlClient.MySqlDataReader

Inheritance: DbDataReader, IDataReader, IDisposable, IDataRecord

ファイルを表示 Open project: Top-Cat/SteamBot Class Usage Examples

Private Properties

Property	Type	Description
AdjustOutputTypes	void
ChangeType	object
ClearKillFlag	void
GetFieldValue	IMySqlValue
IDataRecord	IDataReader
MySqlDataReader	System
ProcessOutputParameters	void
Throw	void

Public Methods

Method	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

Method	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 method

Closes the MySqlDataReader object.

public Close ( ) : void
return	void

GetBoolean() public method

Gets the value of the specified column as a Boolean.

public GetBoolean ( int i ) : bool
i	int
return	bool

GetBoolean() public method

Gets the value of the specified column as a Boolean.

public GetBoolean ( string name ) : bool
name	string
return	bool

GetByte() public method

Gets the value of the specified column as a byte.

public GetByte ( int i ) : byte
i	int
return	byte

GetByte() public method

Gets the value of the specified column as a byte.

public GetByte ( string name ) : byte
name	string
return	byte

GetBytes() public method

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.
return	long

GetChar() public method

Gets the value of the specified column as a single character.

public GetChar ( int i ) : char
i	int
return	char

GetChar() public method

Gets the value of the specified column as a single character.

public GetChar ( string name ) : char
name	string
return	char

GetChars() public method

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
return	long

GetDataTypeName() public method

Gets the name of the source data type.

public GetDataTypeName ( int i ) : String
i	int
return	String

GetDateTime() public method

public GetDateTime ( int i ) : System.DateTime
i	int
return	System.DateTime

GetDateTime() public method

public GetDateTime ( string column ) : System.DateTime
column	string
return	System.DateTime

GetDecimal() public method

public GetDecimal ( int i ) : Decimal
i	int
return	Decimal

GetDecimal() public method

public GetDecimal ( string column ) : Decimal
column	string
return	Decimal

GetDouble() public method

public GetDouble ( int i ) : double
i	int
return	double

GetDouble() public method

public GetDouble ( string column ) : double
column	string
return	double

GetEnumerator() public method

Returns an IEnumerator that iterates through the MySqlDataReader.

public GetEnumerator ( ) : IEnumerator
return	IEnumerator

GetFieldType() public method

Gets the Type that is the data type of the object.

public GetFieldType ( int i ) : Type
i	int
return	System.Type

GetFieldType() public method

public GetFieldType ( string column ) : Type
column	string
return	System.Type

GetFloat() public method

public GetFloat ( int i ) : float
i	int
return	float

GetFloat() public method

public GetFloat ( string column ) : float
column	string
return	float

GetGuid() public method

public GetGuid ( int i ) : System.Guid
i	int
return	System.Guid

GetGuid() public method

public GetGuid ( string column ) : System.Guid
column	string
return	System.Guid

GetInt16() public method

public GetInt16 ( int i ) : Int16
i	int
return	System.Int16

GetInt16() public method

public GetInt16 ( string column ) : Int16
column	string
return	System.Int16

GetInt32() public method

public GetInt32 ( int i ) : Int32
i	int
return	System.Int32

GetInt32() public method

public GetInt32 ( string column ) : Int32
column	string
return	System.Int32

GetInt64() public method

public GetInt64 ( int i ) : System.Int64
i	int
return	System.Int64

GetInt64() public method

public GetInt64 ( string column ) : System.Int64
column	string
return	System.Int64

GetMySqlDateTime() public method

public GetMySqlDateTime ( int column ) : MySqlDateTime
column	int
return	MySql.Data.Types.MySqlDateTime

GetMySqlDateTime() public method

public GetMySqlDateTime ( string column ) : MySqlDateTime
column	string
return	MySql.Data.Types.MySqlDateTime

GetMySqlDecimal() public method

public GetMySqlDecimal ( int i ) : MySqlDecimal
i	int
return	MySql.Data.Types.MySqlDecimal

GetMySqlDecimal() public method

public GetMySqlDecimal ( string column ) : MySqlDecimal
column	string
return	MySql.Data.Types.MySqlDecimal

GetName() public method

Gets the name of the specified column.

public GetName ( int i ) : String
i	int
return	String

GetOrdinal() public method

Gets the column ordinal, given the name of the column.

public GetOrdinal ( string name ) : int
name	string
return	int

GetSByte() public method

Gets the value of the specified column as a sbyte.

public GetSByte ( int i ) : sbyte
i	int
return	sbyte

GetSByte() public method

Gets the value of the specified column as a sbyte.

public GetSByte ( string name ) : sbyte
name	string
return	sbyte

GetSchemaTable() public method

Returns a DataTable that describes the column metadata of the MySqlDataReader.

public GetSchemaTable ( ) : DataTable
return	System.Data.DataTable

GetString() public method

public GetString ( int i ) : String
i	int
return	String

GetString() public method

public GetString ( string column ) : string
column	string
return	string

GetTimeSpan() public method

public GetTimeSpan ( int column ) : System.TimeSpan
column	int
return	System.TimeSpan

GetTimeSpan() public method

public GetTimeSpan ( string column ) : System.TimeSpan
column	string
return	System.TimeSpan

GetUInt16() public method

public GetUInt16 ( int column ) : UInt16
column	int
return	System.UInt16

GetUInt16() public method

public GetUInt16 ( string column ) : UInt16
column	string
return	System.UInt16

GetUInt32() public method

public GetUInt32 ( int column ) : UInt32
column	int
return	System.UInt32

GetUInt32() public method

public GetUInt32 ( string column ) : UInt32
column	string
return	System.UInt32

GetUInt64() public method

public GetUInt64 ( int column ) : System.UInt64
column	int
return	System.UInt64

GetUInt64() public method

public GetUInt64 ( string column ) : System.UInt64
column	string
return	System.UInt64

GetValue() public method

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

public GetValue ( int i ) : object
i	int
return	object

GetValues() public method

Gets all attribute columns in the collection for the current row.

public GetValues ( object values ) : int
values	object
return	int

IsDBNull() public method

Gets a value indicating whether the column contains non-existent or missing values.

public IsDBNull ( int i ) : bool
i	int
return	bool

NextResult() public method

Advances the data reader to the next result, when reading the results of batch SQL statements.

public NextResult ( ) : bool
return	bool

Read() public method

Advances the MySqlDataReader to the next record.

public Read ( ) : bool
return	bool

this() public method

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
return	object

this() public method

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
return	object