Share via


SqlCeParameterCollection.Add Method (Object)

Adds a SqlCeParameter object to the SqlCeCommand.

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)

Syntax

'Declaration
Public Overrides Function Add ( _
    value As Object _
) As Integer
public override int Add (
    Object value
)
public:
virtual int Add (
    Object^ value
) override
public int Add (
    Object value
)
public override function Add (
    value : Object
) : int

Parameters

Return Value

The index of the new SqlCeParameter object in the collection.

Exceptions

Exception type Condition
InvalidCastException

The parameter passed was not a SqlCeParameter.

Example

The following example adds a SqlCeParameter object to a SqlCeParameterCollection. It assumes that a SqlCeCommand has already been created.

Dim pIndex As Integer = cmd.Parameters.Add(CType(New SqlCeParameter("Description", "Beverages"), [Object]))
int pIndex = cmd.Parameters.Add((Object)new SqlCeParameter("Description", "Beverages"));

Thread Safety

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.

Platforms

Development Platforms

Windows Vista, Windows Mobile 5.0, Windows XP Professional with Service Pack 2 (SP2), Windows Server 2003, Windows Mobile 2003 for Pocket PC, Windows CE 5.0
Version Information
.NET Framework and NET Compact Framework
Supported in 3.5
.NET Framework
Supported in 3.0
.NET Compact Framework and .Net Framework
Supported in 2.0

See Also

Reference

SqlCeParameterCollection Class
SqlCeParameterCollection Members
System.Data.SqlServerCe Namespace