MySqlParameter Class

MySQL Connector/Net

previous page next page
MySqlParameter Class
Represents a parameter to a MySqlCommand, and optionally, its mapping to DataSet columns. This class cannot be inherited.
Inheritance Hierarchy
SystemObject  SystemMarshalByRefObject
    System.Data.CommonDbParameter
      MySql.Data.MySqlClientMySqlParameter

Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntax
Copy
public sealed class MySqlParameter : DbParameter, 
	IDataParameter, IDbDataParameter, ICloneable
Public NotInheritable Class MySqlParameter
	Inherits DbParameter
	Implements IDataParameter, IDbDataParameter, ICloneable
public ref class MySqlParameter sealed : public DbParameter, 
	IDataParameter, IDbDataParameter, ICloneable
[<SealedAttribute>]
type MySqlParameter =  
    class
        inherit DbParameter
        interface IDataParameter
        interface IDbDataParameter
        interface ICloneable
    end

The MySqlParameter type exposes the following members.

Constructors
  NameDescription
Public methodMySqlParameter
Public methodMySqlParameter(String, MySqlDbType)
Initializes a new instance of the MySqlParameter class with the parameter name and the data type.
Public methodMySqlParameter(String, Object)
Initializes a new instance of the MySqlParameter class with the parameter name and a value of the new MySqlParameter.
Public methodMySqlParameter(String, MySqlDbType, Int32)
Initializes a new instance of the MySqlParameter class with the parameter name, the MySqlDbType, and the size.
Public methodMySqlParameter(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 methodMySqlParameter(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.
Top
Properties
  NameDescription
Public propertyDbType
Gets or sets the DbType of the parameter.
(Overrides DbParameterDbType.)
Public propertyDirection
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 DbParameterDirection.)
Public propertyIsNullable
Gets or sets a value indicating whether the parameter accepts null values.
(Overrides DbParameterIsNullable.)
Public propertyMySqlDbType
Gets or sets the MySqlDbType of the parameter.
Public propertyParameterName (Overrides DbParameterParameterName.)
Public propertyPossibleValues
Returns the possible values for this parameter if this parameter is of type SET or ENUM. Returns null otherwise.
Public propertyPrecision
Gets or sets the maximum number of digits used to represent the Value property.
Public propertyScale
Gets or sets the number of decimal places to which Value is resolved.
Public propertySize
Gets or sets the maximum size, in bytes, of the data within the column.
(Overrides DbParameterSize.)
Public propertySourceColumn
Gets or sets the name of the source column that is mapped to the DataSet and used for loading or returning the Value.
(Overrides DbParameterSourceColumn.)
Public propertySourceColumnNullMapping
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 DbParameterSourceColumnNullMapping.)
Public propertySourceVersion
Gets or sets the DataRowVersion to use when loading Value.
(Overrides DbParameterSourceVersion.)
Public propertyValue
Gets or sets the value of the parameter.
(Overrides DbParameterValue.)
Top
Methods
  NameDescription
Public methodClone
Public methodCreateObjRef
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 methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetLifetimeService
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodInitializeLifetimeService
Obtains a lifetime service object to control the lifetime policy for this instance.
(Inherited from MarshalByRefObject.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected methodMemberwiseClone(Boolean)
Creates a shallow copy of the current MarshalByRefObject object.
(Inherited from MarshalByRefObject.)
Public methodResetDbType
Resets the DbType property to its original settings.
(Overrides DbParameterResetDbType.)
Public methodToString
Overridden. Gets a string containing the ParameterName.
(Overrides ObjectToString.)
Top
See Also
previous page start next page