This documentation is archived and is not being maintained.

SqlParameter Members

Represents a parameter to a SqlCommand and optionally its mapping to DataSet columns. This class cannot be inherited. For more information on parameters, see Configuring Parameters and Parameter Data Types (ADO.NET).

The SqlParameter type exposes the following members.

  NameDescription
Public method Supported by the .NET Compact Framework SqlParameter Overloaded. Initializes a new instance of the SqlParameter class.
Top

  NameDescription
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 Supported by the .NET Compact Framework Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Supported by the .NET Compact Framework 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 Supported by the .NET Compact Framework 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 Supported by the .NET Compact Framework 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 Supported by the .NET Compact Framework MemberwiseClone Overloaded.
Public method ResetDbType Resets the type associated with this SqlParameter. (Overrides DbParameter.ResetDbType().)
Public method ResetSqlDbType Resets the type associated with this SqlParameter.
Public method Supported by the .NET Compact Framework ToString Gets a string that contains the ParameterName. (Overrides Object.ToString().)
Top

  NameDescription
Public property CompareInfo Gets or sets the CompareInfo object that defines how string comparisons should be performed for this parameter.
Public property Supported by the .NET Compact Framework DbType Gets or sets the SqlDbType of the parameter. (Overrides DbParameter.DbType.)
Public property Supported by the .NET Compact Framework Direction Gets or sets a value that indicates whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter. (Overrides DbParameter.Direction.)
Public property Supported by the .NET Compact Framework IsNullable Gets or sets a value that indicates whether the parameter accepts null values. (Overrides DbParameter.IsNullable.)
Public property LocaleId Gets or sets the locale identifier that determines conventions and language for a particular region.
Public property Supported by the .NET Compact Framework Offset Gets or sets the offset to the Value property.
Public property Supported by the .NET Compact Framework ParameterName Gets or sets the name of the SqlParameter. (Overrides DbParameter.ParameterName.)
Public property Supported by the .NET Compact Framework Precision Gets or sets the maximum number of digits used to represent the Value property.
Public property Supported by the .NET Compact Framework Scale Gets or sets the number of decimal places to which Value is resolved.
Public property Supported by the .NET Compact Framework Size Gets or sets the maximum size, in bytes, of the data within the column. (Overrides DbParameter.Size.)
Public property Supported by the .NET Compact Framework SourceColumn Gets or sets the name of the source column 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 SqlCommandBuilder to correctly generate Update statements for nullable columns. (Overrides DbParameter.SourceColumnNullMapping.)
Public property Supported by the .NET Compact Framework SourceVersion Gets or sets the DataRowVersion to use when you load Value (Overrides DbParameter.SourceVersion.)
Public property Supported by the .NET Compact Framework SqlDbType Gets or sets the SqlDbType of the parameter.
Public property SqlValue Gets or sets the value of the parameter as an SQL type.
Public property TypeName Gets or sets the type name for a table-valued parameter.
Public property UdtTypeName Gets or sets a string that represents a user-defined type as a parameter.
Public property Supported by the .NET Compact Framework Value Gets or sets the value of the parameter. (Overrides DbParameter.Value.)
Public property XmlSchemaCollectionDatabase Gets the name of the database where the schema collection for this XML instance is located.
Public property XmlSchemaCollectionName Gets the name of the schema collection for this XML instance.
Public property XmlSchemaCollectionOwningSchema The owning relational schema where the schema collection for this XML instance is located.
Top

  NameDescription
Explicit interface implemetation Private method Supported by the .NET Compact Framework ICloneable.Clone For a description of this member, see Clone.
Explicit interface implemetation Private property IDbDataParameter.Precision For a description of this member, see IDbDataParameter.Precision. (Inherited from DbParameter.)
Explicit interface implemetation Private property IDbDataParameter.Scale For a description of this member, see IDbDataParameter.Scale. (Inherited from DbParameter.)
Top
Show: