SqlCeParameterCollection.Add Method (String, Object)

  • 아티클

Adds a SqlCeParameter to the SqlCeParameterCollection given the parameter name and value.

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

Syntax

'Declaration
Public Function Add ( _
    parameterName As String, _
    value As Object _
) As SqlCeParameter
'Usage
Dim instance As SqlCeParameterCollection
Dim parameterName As String
Dim value As Object
Dim returnValue As SqlCeParameter

returnValue = instance.Add(parameterName, value)

public SqlCeParameter Add (
    string parameterName,
    Object value
)

public:
SqlCeParameter^ Add (
    String^ parameterName, 
    Object^ value
)

public SqlCeParameter Add (
    String parameterName, 
    Object value
)

public function Add (
    parameterName : String, 
    value : Object
) : SqlCeParameter

Not applicable.

Parameters

  • parameterName
    The name of the parameter.

Return Value

A reference to the new SqlCeParameter object.

Exceptions

Exception type Condition

InvalidCastException

The object supplied as the value parameter cannot be converted to a string. This can happen if the object is not a primitive type, SqlDbType or byte array.

Remarks

The SqlDbType of the new SqlCeParameter object is not inferred from the .NET Compact Framework type of the value parameter. The Value property of the new SqlCeParameter object is set to the string obtained from converting value parameter and the SqlDbType is set to SqlDbType.NChar.

If you want to explicitly set the SqlDbType of the parameter when it is created, you should use one of the other overloaded Add methods.

Example

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

cmd.Parameters.Add("@Description", "Beverages")

cmd.Parameters.Add("@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