Represents a parameter to a ULCommand.
Public NotInheritable Class ULParameter Inherits System.Data.Common.DbParameter Implements System.ICloneable
public sealed class ULParameter : System.Data.Common.DbParameter, System.ICloneable
All members of ULParameter class, including all inherited members.
Name | Description |
---|---|
Initializes a ULParameter object with null (Nothing in Visual Basic) as its value. | |
This method is not supported in UltraLite.NET. | |
Returns the string representation of this instance. | |
Specifies the System.Data.DbType of the parameter | |
A value indicating whether the parameter is input-only, output-only, bidirectional, or a stored procedure return value parameter. | |
Specifies whether the parameter accepts null values. | |
Specifies the offset to the ULParameter.Value. | |
Specifies the name of the parameter. | |
Specifies the maximum number of digits used to represent the ULParameter.Value. | |
Specifies the number of decimal places to which ULParameter.Value is resolved. | |
Specifies the maximum size of the data within the column. | |
Specifies the name of the source column mapped to the DataSet and used for loading or returning the value. | |
Specifies whether the source column is nullable. | |
The System.Data.DataRowVersion to use when loading ULParameter.Value. | |
Specifies the iAnywhere.Data.UltraLite.ULDbType of the parameter | |
Specifies the value of the parameter. |
A ULParameter object can be created directly using one of its many constructors, or using the ULCommand.CreateParameter method. 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 the ULParameter(string,object) constructor. For example:
' Visual Basic Dim p As ULParameter = New ULParameter( "", CType( 0, Object ) ) |
The following code is the C# language equivalent:
// C# ULParameter p = new ULParameter( "", (object)0 ); |
Parameters (including those created by ULCommand.CreateParameter) must be added to a ULCommand.Parameters collection to be used. All parameters are treated as positional parameters and are used by a command in the order that they were added.
In UltraLite.NET, parameters can only be used as IN parameters and all mapping information is ignored. Only the ULParameter.Value is important.
ULParameter constructor
ResetDbType method
ToString method
DbType property
Direction property
IsNullable property
Offset property
ParameterName property
Precision property
Scale property
Size property
SourceColumn property
SourceColumnNullMapping property
SourceVersion property
ULDbType property
Value property
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |