SqlCeParameterCollection.Add Method (String, SqlDbType)
Adds a SqlCeParameter to the SqlCeParameterCollection given the parameter name and data type.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
Syntax
'Declaration
Public Function Add ( _
parameterName As String, _
type As SqlDbType _
) As SqlCeParameter
'Usage
Dim instance As SqlCeParameterCollection
Dim parameterName As String
Dim type As SqlDbType
Dim returnValue As SqlCeParameter
returnValue = instance.Add(parameterName, _
type)
public SqlCeParameter Add(
string parameterName,
SqlDbType type
)
public:
SqlCeParameter^ Add(
String^ parameterName,
SqlDbType type
)
member Add :
parameterName:string *
type:SqlDbType -> SqlCeParameter
public function Add(
parameterName : String,
type : SqlDbType
) : SqlCeParameter
Parameters
- parameterName
Type: System.String
The name of the parameter.
- type
Type: System.Data.SqlDbType
One of the SqlDbType values.
Return Value
Type: System.Data.SqlServerCe.SqlCeParameter
A reference to the new SqlCeParameter object.
Examples
The following example adds new element to a SqlCeParameterCollection. It assumes that a SqlCeCommand has already been created.
Dim p1 As SqlCeParameter = cmd.Parameters.Add("@Description", SqlDbType.NVarChar)
p1.Size = 16
p1.Value = "Beverages"
SqlCeParameter p1 = cmd.Parameters.Add("@Description", SqlDbType.NVarChar);
p1.Size = 16;
p1.Value = "Beverages";