SqlParameter Members
.NET Framework 3.0
Represents a parameter to a SqlCommand and optionally its mapping to DataSet columns. This class cannot be inherited.
The following tables list the members exposed by the SqlParameter type.
| Name | Description | |
|---|---|---|
 | CompareInfo | Gets or sets the CompareInfo object that defines how string comparisons should be performed for this parameter. |
| | DbType | Overridden. Gets or sets the SqlDbType of the parameter. |
| | Direction | Overridden. Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter. |
| | IsNullable | Overridden. Gets or sets a value that indicates whether the parameter accepts null values. |
| | LocaleId | Gets or sets the locale identifier that determines conventions and language for a particular region. |
| | Offset | Gets or sets the offset to the Value property. |
| | ParameterName | Overridden. Gets or sets the name of the SqlParameter. |
| | 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 | Overridden. Gets or sets the maximum size, in bytes, of the data within the column. |
| | SourceColumn | Overridden. Gets or sets the name of the source column mapped to the DataSet and used for loading or returning the Value |
| | SourceColumnNullMapping | Overridden. Sets or gets a value which indicates whether the source column is nullable. This allows SqlCommandBuilder to correctly generate Update statements for nullable columns. |
| | SourceVersion | Overridden. Gets or sets the DataRowVersion to use when you load Value |
| | SqlDbType | Gets or sets the SqlDbType of the parameter. |
| | SqlValue | Gets or sets the value of the parameter as an SQL type. |
| | UdtTypeName | Gets or sets a string that represents a user-defined type as a parameter. |
| | Value | Overridden. Gets or sets the value of the parameter. |
| | XmlSchemaCollectionDatabase | Gets the name of the database where the schema collection for this XML instance is located. |
| | XmlSchemaCollectionName | Gets the name of the schema collection for this XML instance. |
| | XmlSchemaCollectionOwningSchema | The owning relational schema where the schema collection for this XML instance is located. |
(see also
Protected Methods
)
Top
| Name | Description | |
|---|---|---|
| | 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 | Overloaded. Determines whether two Object instances are equal. (inherited from Object) |
| | GetHashCode | Serves as a hash function for a particular type. (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) |
| | ReferenceEquals | Determines whether the specified Object instances are the same instance. (inherited from Object) |
| | ResetDbType | Overridden. Resets the type associated with this SqlParameter. |
| | ResetSqlDbType | Resets the type associated with this SqlParameter. |
| | ToString | Overridden. Gets a string that contains the ParameterName. |
| Name | Description | |
|---|---|---|
| | Finalize | Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection. (inherited from Object) |
| | MemberwiseClone | Overloaded. (inherited from MarshalByRefObject) |
