MySqlParameter Members

MySQL Connector.Net

Collapse image Expand Image Copy image CopyHover image

The MySqlParameter type exposes the following members.

Constructors

  Name Description
Public method MySqlParameter()()()()
Public method MySqlParameter(String, MySqlDbType)
Initializes a new instance of the MySqlParameter class with the parameter name and the data type.
Public method MySqlParameter(String, Object)
Initializes a new instance of the MySqlParameter class with the parameter name and a value of the new MySqlParameter.
Public method MySqlParameter(String, MySqlDbType, Int32)
Initializes a new instance of the MySqlParameter class with the parameter name, the MySqlDbType, and the size.
Public method MySqlParameter(String, MySqlDbType, Int32, String)
Initializes a new instance of the MySqlParameter class with the parameter name, the MySqlDbType, the size, and the source column name.
Public method MySqlParameter(String, MySqlDbType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object)
Initializes a new instance of the MySqlParameter class with the parameter name, the type of the parameter, the size of the parameter, a ParameterDirection, the precision of the parameter, the scale of the parameter, the source column, a DataRowVersion to use, and the value of the parameter.

Methods

  Name Description
Public method Clone
Public method CreateObjRef
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
(Inherited from MarshalByRefObject.)
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method InitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected method MemberwiseClone()()()()
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected method MemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
Public method ResetDbType
Resets the DbType property to its original settings.
(Overrides DbParameter..::..ResetDbType()()()().)
Public method ToString
Overridden. Gets a string containing the ParameterName.
(Overrides Object..::..ToString()()()().)

Properties

  Name Description
Public property DbType
Gets or sets the DbType of the parameter.
(Overrides DbParameter..::..DbType.)
Public property Direction
Gets or sets a value indicating whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter. As of MySql version 4.1 and earlier, input-only is the only valid choice.
(Overrides DbParameter..::..Direction.)
Public property IsNullable
Gets or sets a value indicating whether the parameter accepts null values.
(Overrides DbParameter..::..IsNullable.)
Public property MySqlDbType
Gets or sets the MySqlDbType of the parameter.
Public property ParameterName (Overrides DbParameter..::..ParameterName.)
Public property PossibleValues
Returns the possible values for this parameter if this parameter is of type SET or ENUM. Returns null otherwise.
Public property Precision
Gets or sets the maximum number of digits used to represent the Value property.
Public property Scale
Gets or sets the number of decimal places to which Value is resolved.
Public property Size
Gets or sets the maximum size, in bytes, of the data within the column.
(Overrides DbParameter..::..Size.)
Public property SourceColumn
Gets or sets the name of the source column that is mapped to the DataSet and used for loading or returning the Value.
(Overrides DbParameter..::..SourceColumn.)
Public property SourceColumnNullMapping
Sets or gets a value which indicates whether the source column is nullable. This allows DbCommandBuilder to correctly generate Update statements for nullable columns.
(Overrides DbParameter..::..SourceColumnNullMapping.)
Public property SourceVersion
Gets or sets the DataRowVersion to use when loading Value.
(Overrides DbParameter..::..SourceVersion.)
Public property Value
Gets or sets the value of the parameter.
(Overrides DbParameter..::..Value.)

See Also