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
'Usage
Dim instance As SqlCeParameterCollection
Dim value As Object
Dim returnValue As Integer

returnValue = instance.Add(value)

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

Not applicable.

Parameters

• value
  The SqlCeParameter object to add to the collection.

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"));

Platforms

Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

Version Information

.NET Framework

Supported in: 3.0

.NET Compact Framework

Supported in: 2.0, 1.0

See Also

Reference

SqlCeParameterCollection Class
SqlCeParameterCollection Members
System.Data.SqlServerCe Namespace