Skip navigation links
20.2.7 Connector/NET Support »
Section Navigation      [Toggle]

20.2.6.2. MySql.Data.Types

[+/-]

20.2.6.2.1. MySql.Data.TypesHierarchy
20.2.6.2.2. MySqlConversionException Class
20.2.6.2.3. MySqlDateTime Class

Namespace hierarchy

Classes

Class Description
MySqlConversionException Summary description for MySqlConversionException.
MySqlDateTime Summary description for MySqlDateTime.
MySqlValue  
20.2.6.2.1. MySql.Data.TypesHierarchy

See Also

MySql.Data.Types Namespace

20.2.6.2.2. MySqlConversionException Class

[+/-]

20.2.6.2.2.1. MySqlConversionException Members

Summary description for MySqlConversionException.

For a list of all members of this type, see MySqlConversionException Members .

Syntax: Visual Basic 

Public Class MySqlConversionException_
  Inherits ApplicationException

Syntax: C# 

public class MySqlConversionException : ApplicationException

Thread Safety

Public static (Sharedin Visual Basic) members of this type are safe for multithreaded operations. Instance members are notguaranteed to be thread-safe.

Requirements

Namespace: MySql.Data.Types

Assembly: MySql.Data (in MySql.Data.dll)

See Also

MySqlConversionException Members , MySql.Data.Types Namespace

20.2.6.2.2.1. MySqlConversionException Members

[+/-]

20.2.6.2.2.1.1. MySqlConversionException Constructor

MySqlConversionException overview

Public Instance Constructors

MySqlConversionException Constructor Ctor

Public Instance Properties

Data(inherited from Exception) Gets a collection of key/value pairs that provide additional, user-defined information about the exception.
HelpLink(inherited from Exception) Gets or sets a link to the help file associated with this exception.
InnerException(inherited from Exception) Gets the Exceptioninstance that caused the current exception.
Message(inherited from Exception) Gets a message that describes the current exception.
Source(inherited from Exception) Gets or sets the name of the application or the object that causes the error.
StackTrace(inherited from Exception) Gets a string representation of the frames on the call stack at the time the current exception was thrown.
TargetSite(inherited from Exception) Gets the method that throws the current exception.

Public Instance Methods

Equals(inherited from Object) Determines whether the specified Objectis equal to the current Object.
GetBaseException(inherited from Exception) When overridden in a derived class, returns the Exceptionthat is the root cause of one or more subsequent exceptions.
GetHashCode(inherited from Object) Serves as a hash function for a particular type. GetHashCodeis suitable for use in hashing algorithms and data structures like a hash table.
GetObjectData(inherited from Exception) When overridden in a derived class, sets the SerializationInfowith information about the exception.
GetType(inherited from Exception) Gets the runtime type of the current instance.
ToString(inherited from Exception) Creates and returns a string representation of the current exception.

Protected Instance Properties

HResult(inherited from Exception) Gets or sets HRESULT, a coded numerical value that is assigned to a specific exception.

Protected Instance Methods

Finalize(inherited from Object) Allows an Objectto attempt to free resources and perform other cleanup operations before the Objectis reclaimed by garbage collection.
MemberwiseClone(inherited from Object) Creates a shallow copy of the current Object.

See Also

MySqlConversionException Class , MySql.Data.Types Namespace

20.2.6.2.2.1.1. MySqlConversionException Constructor

Syntax: Visual Basic 

Public Sub New( _
   ByVal msg As String _
)

Syntax: C# 

public MySqlConversionException(
stringmsg
);

See Also

MySqlConversionException Class , MySql.Data.Types Namespace

20.2.6.2.3. MySqlDateTime Class

[+/-]

20.2.6.2.3.1. MySqlDateTime Members

Summary description for MySqlDateTime.

For a list of all members of this type, see MySqlDateTime Members .

Syntax: Visual Basic 

Public Class MySqlDateTime_
  Inherits MySqlValue_
  Implements IConvertible, IComparable

Syntax: C# 

public class MySqlDateTime : MySqlValue, IConvertible, IComparable

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Requirements

Namespace: MySql.Data.Types

Assembly: MySql.Data (in MySql.Data.dll)

See Also

MySqlDateTime Members , MySql.Data.Types Namespace

20.2.6.2.3.1. MySqlDateTime Members

[+/-]

20.2.6.2.3.1.1. MySqlDateTime Explicit MySqlDateTime to DateTime Conversion
20.2.6.2.3.1.2. Day Property
20.2.6.2.3.1.3. Hour Property
20.2.6.2.3.1.4. IsNull Property
20.2.6.2.3.1.5. IsValidDateTime Property
20.2.6.2.3.1.6. Minute Property
20.2.6.2.3.1.7. Month Property
20.2.6.2.3.1.8. Second Property
20.2.6.2.3.1.9. Year Property
20.2.6.2.3.1.10. MySqlDateTime.GetDateTime Method
20.2.6.2.3.1.11. MySqlDateTime.ToString Method

MySqlDateTime overview

Public Static (Shared) Type Conversions

Explicit MySqlDateTime to DateTime Conversion  

Public Instance Properties

Day Returns the day portion of this datetime
Hour Returns the hour portion of this datetime
IsNull (inherited from MySqlValue)  
IsValidDateTime Indicates if this object contains a value that can be represented as a DateTime
Minute Returns the minute portion of this datetime
Month Returns the month portion of this datetime
Second Returns the second portion of this datetime
ValueAsObject (inherited from MySqlValue) Returns the value of this field as an object
Year Returns the year portion of this datetime

Public Instance Methods

Equals(inherited from Object) Determines whether the specified Objectis equal to the current Object.
GetDateTime Returns this value as a DateTime
GetHashCode(inherited from Object) Serves as a hash function for a particular type. GetHashCodeis suitable for use in hashing algorithms and data structures like a hash table.
GetType(inherited from Object) Gets the Typeof the current instance.
ToString Returns a MySQL specific string representation of this value

Protected Instance Fields

classType (inherited from MySqlValue) The system type represented by this value
dbType (inherited from MySqlValue) The generic dbtype of this value
isNull (inherited from MySqlValue) Is this value null
mySqlDbType (inherited from MySqlValue) The specific MySQL db type
mySqlTypeName (inherited from MySqlValue) The MySQL specific typename of this value
objectValue (inherited from MySqlValue)  

Protected Instance Methods

Finalize(inherited from Object) Allows an Objectto attempt to free resources and perform other cleanup operations before the Objectis reclaimed by garbage collection.
MemberwiseClone(inherited from Object) Creates a shallow copy of the current Object.

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.1. MySqlDateTime Explicit MySqlDateTime to DateTime Conversion

Syntax: Visual Basic 

MySqlDateTime.op_Explicit(val)

Syntax: C# 

public static explicit operator DateTime(
MySqlDateTimeval
);

Parameters

  • val:

Return Value

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.2. Day Property

Returns the day portion of this datetime

Syntax: Visual Basic 

Public Property Day As Integer

Syntax: C# 

public int Day {get; set;}

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.3. Hour Property

Returns the hour portion of this datetime

Syntax: Visual Basic 

Public Property Hour As Integer

Syntax: C# 

public int Hour {get; set;}

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4. IsNull Property

[+/-]

20.2.6.2.3.1.4.1. MySqlValue Class

Syntax: Visual Basic 

Public Property IsNull As Boolean

Syntax: C# 

public bool IsNull {get; set;}

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1. MySqlValue Class

[+/-]

20.2.6.2.3.1.4.1.1. MySqlValue Members

For a list of all members of this type, see MySqlValue Members .

Syntax: Visual Basic 

MustInherit Public Class MySqlValue

Syntax: C# 

public abstract class MySqlValue

Thread Safety

Public static (Shared in Visual Basic) members of this type are safe for multithreaded operations. Instance members are not guaranteed to be thread-safe.

Requirements

Namespace: MySql.Data.Types

Assembly: MySql.Data (in MySql.Data.dll)

See Also

MySqlValue Members , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1. MySqlValue Members

[+/-]

20.2.6.2.3.1.4.1.1.1. MySqlValue.numberFormat Field
20.2.6.2.3.1.4.1.1.2. MySqlValue Constructor
20.2.6.2.3.1.4.1.1.3. ValueAsObject Property
20.2.6.2.3.1.4.1.1.4. MySqlValue.ToString Method
20.2.6.2.3.1.4.1.1.5. MySqlValue.classType Field
20.2.6.2.3.1.4.1.1.6. MySqlValue.dbType Field
20.2.6.2.3.1.4.1.1.7. MySqlValue.mySqlDbType Field
20.2.6.2.3.1.4.1.1.8. MySqlValue.mySqlTypeName Field
20.2.6.2.3.1.4.1.1.9. MySqlValue.objectValue Field

MySqlValue overview

Protected Static (Shared) Fields

numberFormat  

Public Instance Constructors

MySqlValue Constructor Initializes a new instance of the MySqlValue class.

Public Instance Properties

IsNull  
ValueAsObject Returns the value of this field as an object

Public Instance Methods

Equals(inherited from Object) Determines whether the specified Objectis equal to the current Object.
GetHashCode(inherited from Object) Serves as a hash function for a particular type. GetHashCodeis suitable for use in hashing algorithms and data structures like a hash table.
GetType(inherited from Object) Gets the Typeof the current instance.
ToString Returns a string representation of this value

Protected Instance Fields

classType The system type represented by this value
dbType The generic dbtype of this value
isNull Is this value null
mySqlDbType The specific MySQL db type
mySqlTypeName The MySQL specific typename of this value
objectValue  

Protected Instance Methods

Finalize(inherited from Object) Allows an Objectto attempt to free resources and perform other cleanup operations before the Objectis reclaimed by garbage collection.
MemberwiseClone(inherited from Object) Creates a shallow copy of the current Object.

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.1. MySqlValue.numberFormat Field

Syntax: Visual Basic 

Protected Shared numberFormat As NumberFormatInfo

Syntax: C# 

protected static NumberFormatInfo numberFormat;

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.2. MySqlValue Constructor

Initializes a new instance of the MySqlValue class.

Syntax: Visual Basic 

Public Sub New()

Syntax: C# 

public MySqlValue();

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.3. ValueAsObject Property

Returns the value of this field as an object

Syntax: Visual Basic 

Public ReadOnly Property ValueAsObject As Object

Syntax: C# 

public object ValueAsObject {get;}

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.4. MySqlValue.ToString Method

Returns a string representation of this value

Syntax: Visual Basic 

Overrides Public Function ToString() As String

Syntax: C# 

public override string ToString();

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.5. MySqlValue.classType Field

The system type represented by this value

Syntax: Visual Basic 

Protected classType As Type

Syntax: C# 

protected Type classType;

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.6. MySqlValue.dbType Field

The generic dbtype of this value

Syntax: Visual Basic 

Protected dbType As DbType

Syntax: C# 

protected DbType dbType;

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.7. MySqlValue.mySqlDbType Field

The specific MySQL db type

Syntax: Visual Basic 

Protected mySqlDbType As MySqlDbType

Syntax: C# 

protected MySqlDbType mySqlDbType;

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.8. MySqlValue.mySqlTypeName Field

The MySQL specific typename of this value

Syntax: Visual Basic 

Protected mySqlTypeName As String

Syntax: C# 

protected string mySqlTypeName;

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.4.1.1.9. MySqlValue.objectValue Field

Syntax: Visual Basic 

Protected objectValue As Object

Syntax: C# 

protected object objectValue;

See Also

MySqlValue Class , MySql.Data.Types Namespace

20.2.6.2.3.1.5. IsValidDateTime Property

Indicates if this object contains a value that can be represented as a DateTime

Syntax: Visual Basic 

Public ReadOnly Property IsValidDateTime As Boolean

Syntax: C# 

public bool IsValidDateTime {get;}

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.6. Minute Property

Returns the minute portion of this datetime

Syntax: Visual Basic 

Public Property Minute As Integer

Syntax: C# 

public int Minute {get; set;}

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.7. Month Property

Returns the month portion of this datetime

Syntax: Visual Basic 

Public Property Month As Integer

Syntax: C# 

public int Month {get; set;}

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.8. Second Property

Returns the second portion of this datetime

Syntax: Visual Basic 

Public Property Second As Integer

Syntax: C# 

public int Second {get; set;}

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.9. Year Property

Returns the year portion of this datetime

Syntax: Visual Basic 

Public Property Year As Integer

Syntax: C# 

public int Year {get; set;}

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.10. MySqlDateTime.GetDateTime Method

Returns this value as a DateTime

Syntax: Visual Basic 

Public Function GetDateTime() As Date

Syntax: C# 

public DateTime GetDateTime();

See Also

MySqlDateTime Class , MySql.Data.Types Namespace

20.2.6.2.3.1.11. MySqlDateTime.ToString Method

Returns a MySQL specific string representation of this value

Syntax: Visual Basic 

Overrides Public Function ToString() As String

Syntax: C# 

public override string ToString();

See Also

MySqlDateTime Class , MySql.Data.Types Namespace