C# 클래스 MySql.Data.MySqlClient.MySqlDataReader

상속: DbDataReader, IDataReader, IDisposable, IDataRecord
파일 보기 프로젝트 열기: Top-Cat/SteamBot 1 사용 예제들

Private Properties

프로퍼티 타입 설명
AdjustOutputTypes void
ChangeType object
ClearKillFlag void
GetFieldValue IMySqlValue
IDataRecord IDataReader
MySqlDataReader System
ProcessOutputParameters void
Throw void

공개 메소드들

메소드 설명
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.

비공개 메소드들

메소드 설명
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

메소드 상세

Close() 공개 메소드

Closes the MySqlDataReader object.
public Close ( ) : void
리턴 void

GetBoolean() 공개 메소드

Gets the value of the specified column as a Boolean.
public GetBoolean ( int i ) : bool
i int
리턴 bool

GetBoolean() 공개 메소드

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

GetByte() 공개 메소드

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

GetByte() 공개 메소드

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

GetBytes() 공개 메소드

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.
리턴 long

GetChar() 공개 메소드

Gets the value of the specified column as a single character.
public GetChar ( int i ) : char
i int
리턴 char

GetChar() 공개 메소드

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

GetChars() 공개 메소드

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
리턴 long

GetDataTypeName() 공개 메소드

Gets the name of the source data type.
public GetDataTypeName ( int i ) : String
i int
리턴 String

GetDateTime() 공개 메소드

public GetDateTime ( int i ) : System.DateTime
i int
리턴 System.DateTime

GetDateTime() 공개 메소드

public GetDateTime ( string column ) : System.DateTime
column string
리턴 System.DateTime

GetDecimal() 공개 메소드

public GetDecimal ( int i ) : Decimal
i int
리턴 Decimal

GetDecimal() 공개 메소드

public GetDecimal ( string column ) : Decimal
column string
리턴 Decimal

GetDouble() 공개 메소드

public GetDouble ( int i ) : double
i int
리턴 double

GetDouble() 공개 메소드

public GetDouble ( string column ) : double
column string
리턴 double

GetEnumerator() 공개 메소드

Returns an IEnumerator that iterates through the MySqlDataReader.
public GetEnumerator ( ) : IEnumerator
리턴 IEnumerator

GetFieldType() 공개 메소드

Gets the Type that is the data type of the object.
public GetFieldType ( int i ) : Type
i int
리턴 System.Type

GetFieldType() 공개 메소드

public GetFieldType ( string column ) : Type
column string
리턴 System.Type

GetFloat() 공개 메소드

public GetFloat ( int i ) : float
i int
리턴 float

GetFloat() 공개 메소드

public GetFloat ( string column ) : float
column string
리턴 float

GetGuid() 공개 메소드

public GetGuid ( int i ) : System.Guid
i int
리턴 System.Guid

GetGuid() 공개 메소드

public GetGuid ( string column ) : System.Guid
column string
리턴 System.Guid

GetInt16() 공개 메소드

public GetInt16 ( int i ) : Int16
i int
리턴 System.Int16

GetInt16() 공개 메소드

public GetInt16 ( string column ) : Int16
column string
리턴 System.Int16

GetInt32() 공개 메소드

public GetInt32 ( int i ) : Int32
i int
리턴 System.Int32

GetInt32() 공개 메소드

public GetInt32 ( string column ) : Int32
column string
리턴 System.Int32

GetInt64() 공개 메소드

public GetInt64 ( int i ) : System.Int64
i int
리턴 System.Int64

GetInt64() 공개 메소드

public GetInt64 ( string column ) : System.Int64
column string
리턴 System.Int64

GetMySqlDateTime() 공개 메소드

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

GetMySqlDateTime() 공개 메소드

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

GetMySqlDecimal() 공개 메소드

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

GetMySqlDecimal() 공개 메소드

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

GetName() 공개 메소드

Gets the name of the specified column.
public GetName ( int i ) : String
i int
리턴 String

GetOrdinal() 공개 메소드

Gets the column ordinal, given the name of the column.
public GetOrdinal ( string name ) : int
name string
리턴 int

GetSByte() 공개 메소드

Gets the value of the specified column as a sbyte.
public GetSByte ( int i ) : sbyte
i int
리턴 sbyte

GetSByte() 공개 메소드

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

GetSchemaTable() 공개 메소드

Returns a DataTable that describes the column metadata of the MySqlDataReader.
public GetSchemaTable ( ) : DataTable
리턴 System.Data.DataTable

GetString() 공개 메소드

public GetString ( int i ) : String
i int
리턴 String

GetString() 공개 메소드

public GetString ( string column ) : string
column string
리턴 string

GetTimeSpan() 공개 메소드

public GetTimeSpan ( int column ) : System.TimeSpan
column int
리턴 System.TimeSpan

GetTimeSpan() 공개 메소드

public GetTimeSpan ( string column ) : System.TimeSpan
column string
리턴 System.TimeSpan

GetUInt16() 공개 메소드

public GetUInt16 ( int column ) : UInt16
column int
리턴 System.UInt16

GetUInt16() 공개 메소드

public GetUInt16 ( string column ) : UInt16
column string
리턴 System.UInt16

GetUInt32() 공개 메소드

public GetUInt32 ( int column ) : UInt32
column int
리턴 System.UInt32

GetUInt32() 공개 메소드

public GetUInt32 ( string column ) : UInt32
column string
리턴 System.UInt32

GetUInt64() 공개 메소드

public GetUInt64 ( int column ) : System.UInt64
column int
리턴 System.UInt64

GetUInt64() 공개 메소드

public GetUInt64 ( string column ) : System.UInt64
column string
리턴 System.UInt64

GetValue() 공개 메소드

Gets the value of the specified column in its native format.
public GetValue ( int i ) : object
i int
리턴 object

GetValues() 공개 메소드

Gets all attribute columns in the collection for the current row.
public GetValues ( object values ) : int
values object
리턴 int

IsDBNull() 공개 메소드

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

NextResult() 공개 메소드

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

Read() 공개 메소드

Advances the MySqlDataReader to the next record.
public Read ( ) : bool
리턴 bool

this() 공개 메소드

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
리턴 object

this() 공개 메소드

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
리턴 object