MySqlDataReader Members


MySqlDataReader overview

Public Instance Properties

Depth Gets a value indicating the depth of nesting for the current row. This method is not supported currently and always returns 0.
FieldCount Gets the number of columns in the current row.
HasRows Gets a value indicating whether the MySqlDataReader contains one or more rows.
IsClosed Gets a value indicating whether the data reader is closed.
Item Overloaded. Overloaded. Gets the value of a column in its native format. In C#, this property is the indexer for the MySqlDataReader class.
RecordsAffected Gets the number of rows changed, inserted, or deleted by execution of the SQL statement.

Public Instance Methods

Close Closes the MySqlDataReader object.
CreateObjRef (inherited from MarshalByRefObject) Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Equals (inherited from Object) Determines whether the specified Object is equal to the current Object.
GetBoolean Gets the value of the specified column as a Boolean.
GetByte Gets the value of the specified column as a byte.
GetBytes Reads a stream of bytes from the specified column offset into the buffer an array starting at the given buffer offset.
GetChar Gets the value of the specified column as a single character.
GetChars Reads a stream of characters from the specified column offset into the buffer as an array starting at the given buffer offset.
GetDataTypeName Gets the name of the source data type.
GetDateTime
GetDecimal
GetDouble
GetFieldType Gets the Type that is the data type of the object.
GetFloat
GetGuid
GetHashCode (inherited from Object) Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table.
GetInt16
GetInt32
GetInt64
GetLifetimeService (inherited from MarshalByRefObject) Retrieves the current lifetime service object that controls the lifetime policy for this instance.
GetMySqlDateTime
GetName Gets the name of the specified column.
GetOrdinal Gets the column ordinal, given the name of the column.
GetSchemaTable Returns a DataTable that describes the column metadata of the MySqlDataReader.
GetString
GetTimeSpan
GetType (inherited from Object) Gets the Type of the current instance.
GetUInt16
GetUInt32
GetUInt64
GetValue Gets the value of the specified column in its native format.
GetValues Gets all attribute columns in the collection for the current row.
InitializeLifetimeService (inherited from MarshalByRefObject) Obtains a lifetime service object to control the lifetime policy for this instance.
IsDBNull Gets a value indicating whether the column contains non-existent or missing values.
NextResult Advances the data reader to the next result, when reading the results of batch SQL statements.
Read Advances the MySqlDataReader to the next record.
ToString (inherited from Object) Returns a String that represents the current Object.

See Also

MySqlDataReader Class, MySql.Data.MySqlClient Namespace

Retornar