Public Function Add(
     ByVal parameterName As String,
    ByVal value As Object
) As ULParameter

public ULParameter Add(string parameterName, object value)

The new ULParameter object.

All parameters in the collection are treated as positional parameters and must be added to the collection in the same order as the corresponding question mark placeholders in the ULCommand.CommandText. For example, the first parameter in the collection corresponds to the first question mark in the SQL statement, the second parameter in the collection corresponds to the second question mark in the SQL statement, and so on. There must be at least as many question marks in the ULCommand.CommandText as there are parameters in the collection. Nulls are substituted for missing parameters.

Because of the special treatment of the 0 and 0.0 constants and the way overloaded methods are resolved, it is highly recommended that you explicitly cast constant values to type object when using this method.

• ULParameterCollection.Add method [UltraLite.NET]
• ULParameter class [UltraLite.NET]
• ULCommand.CommandText property [UltraLite.NET]
• ULCommand class [UltraLite.NET]
•  System.Object

The following code adds a ULParameter with the value 0 to a ULCommand called cmd.

' Visual Basic
cmd.Parameters.Add( "", CType( 0, Object ) )

The following code is the C# language equivalent:

// C#
cmd.Parameters.Add( "", (object)0 );