.NET Framework Class Library  

SqlCeParameter Class

Note: This namespace, class, or member is supported only in version 1.1 of the .NET Framework.

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

For a list of all members of this type, see SqlCeParameter Members.

System.Object
   System.MarshalByRefObject
      System.Data.SqlServerCe.SqlCeParameter

[Visual Basic]
NotInheritable Public Class SqlCeParameter
   Inherits MarshalByRefObject
   Implements IDbDataParameter, IDataParameter, ICloneable
[C#]
public sealed class SqlCeParameter : MarshalByRefObject,
   IDbDataParameter, IDataParameter, ICloneable
[C++]
public __gc __sealed class SqlCeParameter : public
   MarshalByRefObject, IDbDataParameter, IDataParameter, ICloneable
[JScript]
public class SqlCeParameter extends MarshalByRefObject implements
   IDbDataParameter, IDataParameter, ICloneable

Thread Safety

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

Remarks

Parameter names are not case sensitive.

Example

[Visual Basic] 
Public Sub CreateSqlCeParameter()
    Dim myParameter As New SqlCeParameter()
    myParameter.ParameterName = "@Description"
    myParameter.IsNullable    = True
    myParameter.SqlDbType     = SqlDbType.NVarChar
    myParameter.Size          = 88
End Sub

[C#] 
public void CreateSqlCeParameter() {
    SqlCeParameter myParameter = new SqlCeParameter();
    myParameter.ParameterName  = "@Description";
    myParameter.IsNullable     = true;
    myParameter.SqlDbType      = SqlDbType.NVarChar;
    myParameter.Size           = 88;
}

[C++] 
public:
    void CreateSqlCeParameter()
    {
        SqlCeParameter* myParameter = new SqlCeParameter();
        myParameter->ParameterName  = S"@Description";
        myParameter->IsNullable     = true;
        myParameter->SqlDbType      = SqlDbType::NVarChar;
        myParameter->Size           = 88;
    };

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.

Requirements

Namespace: System.Data.SqlServerCe

Platforms: .NET Compact Framework - Windows CE .NET

Assembly: System.Data.Sqlserverce (in System.Data.Sqlserverce.dll)

See Also

SqlCeParameter Members | System.Data.SqlServerCe Namespace