SqlCeParameter Class

Represents a parameter to a SqlCeCommand and, optionally, its mapping to a DataSet column. This class cannot be inherited.

Inheritance Hierarchy

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)

'Declaration
Public NotInheritable Class SqlCeParameter _
    Inherits DbParameter _
    Implements ICloneable
'Usage
Dim instance As SqlCeParameter

public sealed class SqlCeParameter : DbParameter, 
    ICloneable

public ref class SqlCeParameter sealed : public DbParameter, 
    ICloneable

[<SealedAttribute>]
type SqlCeParameter =  
    class
        inherit DbParameter
        interface ICloneable
    end

public final class SqlCeParameter extends DbParameter implements ICloneable

The SqlCeParameter type exposes the following members.

	Name	Description
	SqlCeParameter()	Initializes a new instance of the SqlCeParameter class.
	SqlCeParameter(String, SqlDbType)	Initializes a new instance of the SqlCeParameter class with the parameter name and data type.
	SqlCeParameter(String, Object)	Initializes a new instance of the SqlCeParameter class with the parameter name and the value of the new SqlCeParameter.
	SqlCeParameter(String, SqlDbType, Int32)	Initializes a new instance of the SqlCeParameter class with the parameter name, data type, and length.
	SqlCeParameter(String, SqlDbType, Int32, String)	Initializes a new instance of the SqlCeParameter class with the parameter name, data type, length, and source column name.
	SqlCeParameter(String, SqlDbType, Int32, Boolean, Byte, Byte, String, DataRowVersion, Object)	Initializes a new instance of the SqlCeParameter class with the parameter name, data type, length, and other properties. SQL Server Compact supports only input parameters.
	SqlCeParameter(String, SqlDbType, Int32, ParameterDirection, Boolean, Byte, Byte, String, DataRowVersion, Object)	Initializes a new instance of the SqlCeParameter class with the parameter name, data type, length, parameter direction, and other properties. SQL Server Compact only supports input parameters.

Top

	Name	Description
	DbType	Gets or sets the DbType of the parameter. (Overrides DbParameter.DbType.)
	Direction	This property always returns ParameterDirection.Input for .NET Compact Framework Data Provider for SQL Server Compact. Setting this property to a different value causes an InvalidOperationException to be thrown. (Overrides DbParameter.Direction.)
	IsNullable	Gets or sets a value indicating whether or not the parameter accepts null values. (Overrides DbParameter.IsNullable.)
	Offset	Infrastructure.
	ParameterName	Gets or sets the name of the SqlCeParameter. (Overrides DbParameter.ParameterName.)
	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 length of the data within the column. (Overrides DbParameter.Size.)
	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.)
	SourceColumnNullMapping	Infrastructure. (Overrides DbParameter.SourceColumnNullMapping.)
	SourceVersion	Gets or sets the DataRowVersion to use when loading Value. (Overrides DbParameter.SourceVersion.)
	SqlDbType	Gets or sets the SqlDbType of the parameter.
	Value	Gets or sets the value of the parameter. (Overrides DbParameter.Value.)

Top

	Name	Description
	CreateObjRef	(inherited from MarshalByRefObject)
	Equals	(inherited from Object)
	Finalize	(inherited from Object)
	GetHashCode	(inherited from Object)
	GetLifetimeService	(inherited from MarshalByRefObject)
	GetType	(inherited from Object)
	InitializeLifetimeService	(inherited from MarshalByRefObject)
	MemberwiseClone()	(inherited from Object)
	MemberwiseClone(Boolean)	(inherited from MarshalByRefObject)
	ResetDbType	Resets the type associated with this SqlCeParameter. (Overrides DbParameter.ResetDbType().)
	ToString	Gets a string containing the ParameterName. (Overrides Object.ToString().)

Top

	Name	Description
	ICloneable.Clone
	IDbDataParameter.Precision	(inherited from DbParameter)
	IDbDataParameter.Scale	(inherited from DbParameter)

Top

Parameter names are not case-sensitive.

The following example shows a typical use of SqlCeParameter.

Dim param As New SqlCeParameter("@Description", SqlDbType.NVarChar)
param.Value = "garden hose"

SqlCeParameter param = new SqlCeParameter("@Description", SqlDbType.NVarChar);
param.Value = "garden hose";

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.