MySQL Connector/Net
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
System.Data.CommonDbParameter
MySql.Data.MySqlClientMySqlParameter
Namespace: MySql.Data.MySqlClient
Assembly: MySql.Data (in MySql.Data.dll) Version: 6.9.9
Syntax
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
Name | Description | |
---|---|---|
MySqlParameter | ||
MySqlParameter(String, MySqlDbType) |
Initializes a new instance of the MySqlParameter class with the parameter name and the data type.
| |
MySqlParameter(String, Object) |
Initializes a new instance of the MySqlParameter class with the parameter name and a value of the new MySqlParameter.
| |
MySqlParameter(String, MySqlDbType, Int32) |
Initializes a new instance of the MySqlParameter class with the parameter name, the MySqlDbType, and the size.
| |
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.
| |
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.
|
Properties
Name | Description | |
---|---|---|
DbType |
Gets or sets the DbType of the parameter.
(Overrides DbParameterDbType.) | |
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 DbParameterDirection.) | |
IsNullable |
Gets or sets a value indicating whether the parameter accepts null values.
(Overrides DbParameterIsNullable.) | |
MySqlDbType |
Gets or sets the MySqlDbType of the parameter.
| |
ParameterName | (Overrides DbParameterParameterName.) | |
PossibleValues |
Returns the possible values for this parameter if this parameter is of type
SET or ENUM. Returns null otherwise.
| |
Precision |
Gets or sets the maximum number of digits used to represent the Value property.
| |
Scale |
Gets or sets the number of decimal places to which Value is resolved.
| |
Size |
Gets or sets the maximum size, in bytes, of the data within the column.
(Overrides DbParameterSize.) | |
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 DbParameterSourceColumn.) | |
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 DbParameterSourceColumnNullMapping.) | |
SourceVersion |
Gets or sets the DataRowVersion to use when loading Value.
(Overrides DbParameterSourceVersion.) | |
Value |
Gets or sets the value of the parameter.
(Overrides DbParameterValue.) |
Methods
Name | Description | |
---|---|---|
Clone | ||
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.) | |
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
GetHashCode | Serves as the default hash function. (Inherited from Object.) | |
GetLifetimeService | Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.) | |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
InitializeLifetimeService | Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.) | |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
MemberwiseClone(Boolean) | Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.) | |
ResetDbType |
Resets the DbType property to its original settings.
(Overrides DbParameterResetDbType.) | |
ToString |
Overridden. Gets a string containing the ParameterName.
(Overrides ObjectToString.) |
See Also