SqlCeParameterCollection.Add Method (String, SqlDbType, Int32)

Adds a SqlCeParameter to the SqlCeParameterCollection given the parameter name, data type, and column width.

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


Public Function Add ( _
    parameterName As String, _
    type As SqlDbType, _
    size As Integer _
) As SqlCeParameter
Dim instance As SqlCeParameterCollection
Dim parameterName As String
Dim type As SqlDbType
Dim size As Integer
Dim returnValue As SqlCeParameter

returnValue = instance.Add(parameterName, type, size)
public SqlCeParameter Add (
    string parameterName,
    SqlDbType type,
    int size
SqlCeParameter^ Add (
    String^ parameterName, 
    SqlDbType type, 
    int size
public SqlCeParameter Add (
    String parameterName, 
    SqlDbType type, 
    int size
public function Add (
    parameterName : String, 
    type : SqlDbType, 
    size : int
) : SqlCeParameter


  • parameterName
    The name of the parameter.
  • type
    One of the SqlDbType values.
  • size
    The width of the column.

Return Value

A reference to the new SqlCeParameter object.


The following example adds new element to a SqlCeParameterCollection and returns a reference to the new SqlCeParameter.

Dim p1 As SqlCeParameter = cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 16)
p1.Value = "Beverages"
SqlCeParameter p1 = cmd.Parameters.Add("@Description", SqlDbType.NVarChar, 16);
p1.Value = "Beverages";

.NET Framework Security

  • Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see .


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

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see System Requirements.

Version Information

.NET Compact Framework

Supported in: 2.0, 1.0

See Also


SqlCeParameterCollection Class
SqlCeParameterCollection Members
System.Data.SqlServerCe Namespace